Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet not calculating
Hi, I am having problems with a spreadsheet where the formulas are not re-calculating, even though auto calc is on. If i hit F2 on the formula and then enter it works though. Any ideas? Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=520836 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet not calculating
What's your formula?
-- Kind regards, Niek Otten "Gazzr" wrote in message ... Hi, I am having problems with a spreadsheet where the formulas are not re-calculating, even though auto calc is on. If i hit F2 on the formula and then enter it works though. Any ideas? Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=520836 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet not calculating
Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet not calculating
Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions |