delay in function response

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please help? I've been using excel for a few years and I've
never had this happen. I was using a spreadsheet all day off and on. In the
afternoon, when I continued to change data in a reference cell, the formula
cell did not change as I changed reference data. I checkec the formula, it
was correct. When i "saved" however, all of the functions carried through.
It's been like that ever since and it's driving me crazy. How do i get back
to having imediate update in all formula cells as i change reference cells?
 
Sorry, this newsgroup is intended for questions about Access, the database
product that's part of Office Professional. Your question would be best
reposted to a newsgroup related to Excel.

That having been said, look at the Calculation tab under Tools | Options.
 
Back
Top