MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Misbehaving formula


Posted by Susie Pappas on September 07, 2001 12:22 PM

I am stumped. I am using the Fill Down function to
duplicate the same simple formula (sum of two
adjacent cells) in a column. The formula appears
correct in the formula bar; however the value in all
cells in the column is the same is the value in the
cell where the formula was originally entered. The
same thing happens if I try to do a Copy and Paste or
even a Copy and Paste Special/Paste Formula. The only
way I am able to get the correct values is to enter
the formula in each cell individually.

Anybody have an idea what's going on here?


Posted by Barrie Davidson on September 07, 2001 12:23 PM

Do you have your calculation set to Manual?

Barrie

Posted by Wingz on September 07, 2001 12:29 PM

I have seen this too! I absolutely hate when this happens (happened to me twice now...) I found that this happened to me after transferring the saved file (via disk or email) and then reopening it. It strikes me as corruption... though I could be wrong. If anyone can explain this (and yes, calculations were on auto) please let me know as well.

Posted by Barrie Davidson on September 07, 2001 12:31 PM

Okay, calcs set to auto. This is a known bug for Excel97 (not sure for Excel 2000). You need to force Excel to calculate by CTRL+ALT+F9 (F9 alone won't do it).

Regards,
Barrie