Excel 2010 Not Calculating

[lauser]

I'm working in Excel 2010 with a file (6.93MB) that is not calculating. The calculation settings are set to "Automatic", I've tried Ctrl + Alt + F9, Alt + M + B, etc., but whenever I do that, in the bottom right it will show "Calculating: (4 Processor(s)): 0%" and the "Calculate" label is constantly showing in the bottom left. When trying to save the file, the same thing happens, but the calculations never get beyond 0%, so I can only save the file without recalculating. I tried restarting my computer, and I tried recalculating in a separate file which worked fine. Just seems to be this one file and have no idea what would be preventing the workbook from ever recalculating. I'm talking about leaving it for minutes and it never gets above 0%, and at 6.93MB that just shouldn't be the case.

I've even tried opening an older version of this file and that works fine. All I've been doing today is updating and adding formulas, but don't understand why that would impact the workbook's ability to recalculate.

Any help would be appreciated!

 

[lauser]

Are you sure it's a circular rather than an infinite calculation.
Maybe if you posted the formula ??

100% sure it's circular, the formula itself would not give you any help as it refers to other cells and there is a long chain of circularity, so pasting a formula won't display that.

 

[Michael M]

Ok, no worries...another thing to consider is that, if you have a lot of SUBTOTALS in the worksheet, everytime a cell changes in connection with that SUBTOTAL, the sheet recalculates.
If that is the case have a read here....

https://support.microsoft.com/en-us...ssly-loop-calculating-cells-when-you-insert-s

otherwise, good luck with your project...