| Home |
| Search |
| Today's Posts |
|
#1
September 12th 13, 05:13 PM
|
|||
|
|||
offset formula causing Circular reference
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? |
|
#2
April 13th 15, 12:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
offset formula causing Circular reference
Was there any reply to this? I have it also now and cant find a fix for it...
|
|
#3
April 13th 15, 08:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
offset formula causing Circular reference
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. |
|
#4
April 14th 15, 01:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Circular Reference / OFFSET | Excel Discussion (Misc queries) | |||
| Formula help in a circular reference | Excel Worksheet Functions | |||
| Issues with my excel formula as it needs Circular reference - hlp | Excel Worksheet Functions | |||
| circular reference formula | Excel Discussion (Misc queries) | |||
| Avoiding circular reference on formula | Excel Discussion (Misc queries) | |||
Linear Mode
