I have attached a spreadsheet with a large table on it, who's values will not automatically re-calculate with each cell change, save etc.. (I have Workbook Calculations set to Automatic)
I never experienced this problem before. Can anyone help?
I have attached a spreadsheet with a large table on it, who's values will not automatically re-calculate with each cell change, save etc.. (I have Workbook Calculations set to Automatic)
I never experienced this problem before. Can anyone help?
No solution but you have circular references on this file.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
How do I go about finding where the circular references are? Could this be causing the problem?
https://www.google.co.uk/#q=excel+lo...ular+reference
Not sure if it will resolve because of that.
Turn your calculations back to automatic.
Google calculation in Excel and you should find a guide.
Circular references should be viewable by going Formulas -> Error Checking -> Circular References
My calculations are set to automatic.
"(I have Workbook Calculations set to Automatic)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks