Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas not calculating - Calculation is on Automatic & I pressed
Consider limiting the amount of formulas in your worksheet. Excel
keeps track of your formula relationships, so if you have too many, Excel cannot keep up. Also check out these sites: http://j-walk.com/ss//excel/usertips/tip063.htm http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx HTH, JP On Nov 6, 6:10 pm, dano wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas not calculating - Calculation is on Automatic & I pressed
The imported data may not be numerical.
Hitting F2 + ENTER helps Excel refresh. One method to try is select all cells then EditReplace What: = With: = Replace all. Gord Dibben MS Excel MVP On Tue, 6 Nov 2007 15:10:00 -0800, dano wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Calculation | Excel Worksheet Functions | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
Automatic calculation | Excel Discussion (Misc queries) |