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