Formulas not calculating - Calculation is on Automatic & I pressed

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

Guest

Hi there,
Have a bunch of formulas not calculating. I had the calculation switched to
manual because this spreadsheet uses a GL interface into Oracle, and I didn't
want it refreshing all the time. I switched it back to automatic, pressed
F9, clicked calculate now and clicked calculate sheet. Its still not
calculating. Any ideas?

not an excel novice, but have hit this problem several times, this sheet is
just much bigger. If I go to the cell, hit F2 and enter, it "refreshes" the
formula and then it calcs. any help would be greatly appreciated!!
 
The imported data may not be numerical.

Hitting F2 + ENTER helps Excel refresh.

One method to try is select all cells then Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP
 
Back
Top