Hello all..
Ok, I am working in a new spreadsheet that was designed in 97 but I am
now using 2000. Not sure if that is the problem. BUt everytime I open
the spreadsheet or change any data, I have to go to not one, not two but
all formulas in the spreadsheet and f2 then enter to clear it before it
will recalculate. I dont understand it. For example, I am just using
a sum.. =sum(a2:a8) in a9. i can change any one of a2:a8 and a9
will NOT change unless i f2 then enter in a9. It is happening with
multiple formulas in multiple cells. any ideas....????

Thanks
schlep


--
schleppy2
------------------------------------------------------------------------
schleppy2's Profile: http://www.excelforum.com/member.php...o&userid=27013
View this thread: http://www.excelforum.com/showthread...hreadid=429513