offset formula causing Circular reference
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
|