(Msg. 1) Posted: Mon Apr 13, 2009 7:53 am
Post subject: Formula Result Does Not Change when a component does Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
Changed an entry in a spread sheet that drives results in a numebr of cells.
The results change in some cells and not others. Sheet and cells are
unprotected and calcualtion option is set at automatic. When I erase one of
the affected formulas and reenter, I get "0" as a result. If I copy the
formula from the cell below, i get the right formula but the result displayed
is from the cell below. Can anyone tell me what's going on?
(Msg. 2) Posted: Tue Apr 14, 2009 4:37 am
Post subject: RE: Formula Result Does Not Change when a component does [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I am not sure if the formatting of these cells has got anything to do with
this. However, if you could share the spreadsheet, it might be helpful.
P.S If this post is helpful, please select 'Yes' for this post
"Alan" wrote:
> Changed an entry in a spread sheet that drives results in a numebr of cells.
> The results change in some cells and not others. Sheet and cells are
> unprotected and calcualtion option is set at automatic. When I erase one of
> the affected formulas and reenter, I get "0" as a result. If I copy the
> formula from the cell below, i get the right formula but the result displayed
> is from the cell below. Can anyone tell me what's going on?
(Msg. 3) Posted: Tue Apr 14, 2009 5:00 am
Post subject: RE: Formula Result Does Not Change when a component does [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Will check the formatting and would share the sheet but can't - too much
confidential information would have to be removed. Thanks for the suggestion.
"KidontheBlock" wrote:
> I am not sure if the formatting of these cells has got anything to do with
> this. However, if you could share the spreadsheet, it might be helpful.
>
> P.S If this post is helpful, please select 'Yes' for this post
>
> "Alan" wrote:
>
> > Changed an entry in a spread sheet that drives results in a numebr of cells.
> > The results change in some cells and not others. Sheet and cells are
> > unprotected and calcualtion option is set at automatic. When I erase one of
> > the affected formulas and reenter, I get "0" as a result. If I copy the
> > formula from the cell below, i get the right formula but the result displayed
> > is from the cell below. Can anyone tell me what's going on?
(Msg. 4) Posted: Wed Apr 15, 2009 12:30 pm
Post subject: RE: Formula Result Does Not Change when a component does [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I am having the same issue - if someone can look into it for me I would
happily share the spreadsheet.
Thanks!
Robin
"Alan" wrote:
> Changed an entry in a spread sheet that drives results in a numebr of cells.
> The results change in some cells and not others. Sheet and cells are
> unprotected and calcualtion option is set at automatic. When I erase one of
> the affected formulas and reenter, I get "0" as a result. If I copy the
> formula from the cell below, i get the right formula but the result displayed
> is from the cell below. Can anyone tell me what's going on?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office