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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com