View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dano dano is offline
external usenet poster
 
Posts: 11
Default Formulas not calculating - Calculation is on Automatic & I pressed

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!!
--
dano