![]() |
excel not calculating
I have a very large excel workbook (about 60MB) that I created with some
nested if statements, and sumproduct calculations, about 25 macros including a macro that does an intense caluculation, and all types of other formulas. I created this for the planning department of a large organization. All of a sudden today, it will not calculate anything. When the data is changed nothing happens. I can't even get it to calculate manually. I have all the automatic calculations settings correct. Can anyone help? |
excel not calculating
Try Ctrl-Alt-F9 (calculate Full)
if that does not work try Ctrl-Alt-Shift-F9 (calculate full rebuild dependency trees) Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Rob" wrote in message ... I have a very large excel workbook (about 60MB) that I created with some nested if statements, and sumproduct calculations, about 25 macros including a macro that does an intense caluculation, and all types of other formulas. I created this for the planning department of a large organization. All of a sudden today, it will not calculate anything. When the data is changed nothing happens. I can't even get it to calculate manually. I have all the automatic calculations settings correct. Can anyone help? |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com