[Fighting Illini Mike]

I have come across this before but don't know what the solution is. I had a Excel 2010 workbook open with many offset formulas in it when I opened an old .xls worksheet. After I opened up the old worksheet, I got circular references in my other workbook because of my offset formulas. They previously hadn't been causing circular references.

How do I stop these incorrect circular references?

[[email protected]]

Was there any reply to this? I have it also now and cant find a fix for it...

[[email protected]]

On Monday, April 13, 2015 at 6:39:42 AM UTC-5, wrote:
Was there any reply to this? I have it also now and cant find a fix for it...

If you want to send to me with the info here, I'll check in both versions.

[[email protected]]

As per my understanding...you need to click on file---Option---Formulas---and check the box-enable iterative calculation.

Hope it will help you.

On Thursday, September 12, 2013 at 9:43:56 PM UTC+5:30, Fighting Illini Mike wrote:
I have come across this before but don't know what the solution is. I
had a Excel 2010 workbook open with many offset formulas in it when I
opened an old .xls worksheet. After I opened up the old worksheet, I
got circular references in my other workbook because of my offset
formulas. They previously hadn't been causing circular references.

How do I stop these incorrect circular references?




--
Fighting Illini Mike