Workbook Won't Recalculate some Worksheets

[LarryMckeown]

I have some workbooks, 10MB to 30MB, someitmes won't perform all of the recalculations when a value is changed on another worksheet in the workbook.

The Calculation tab is marked "automatic" and the "iteration" button is on.

If I spot the error, I have to copy and re-paste the formula to get it to re-calc.

Closing the file and re-opening won't fix it.

HELP! I'm doing a live interactive presentation on Monday and I can't not have the formulas not always recalculating.

Thanks

 

[acw]

Hi

Do you have a circular reference?

Tony