Circular references error when opening macro enabled workbook

[c.davidson]

I have quite a large macro enabled workbook use for predicting performance of units. It involves lots of balances and formulas across many sheets. Some calculations are in VBA code, some are formulas in cells.

It has worked perfectly up until recently, now whenever I open it I get the "Excel cannot calculate a formula, circular reference that cannot be listed. Try entering the formula again or pressing undo" (or something similar).

Well as I've just opened the workbook I can't undo anything. The bottom left of the window says where there is a circular reference on each sheet but when I go through them there's nothing wrong with the formulas that allowed them to work in the first place. No reference errors, all named cells are present in the name manager.

It's becoming very frustrating to have to close this error every time I open the workbook and sometimes when I'm working in the workbook.

For confidential reasons I can't share the workbook in this forum, but has anyone else experienced this and found a solution?

[shukla.ankur281190]

You can check which cell is making this problem to do so , go to the formula tab ->> under formula auditing ->>drag error checking you will see the third option which is circular reference . Check which cell is visible there and can remove if that cell is not so important.

[c.davidson]

That option in the error checking is greyed out for me

[shukla.ankur281190]

If you can't upload a sample workbook you can post error picture instead. Without a sample file we will not sure what actual problem is there