Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 12th 13, 05:13 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2013
Posts: 1
Default 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   Report Post  
Old April 13th 15, 12:39 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1
Default offset formula causing Circular reference

Was there any reply to this? I have it also now and cant find a fix for it...
  #3   Report Post  
Old April 13th 15, 08:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2014
Posts: 27
Default 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   Report Post  
Old April 14th 15, 01:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular Reference / OFFSET nastech Excel Discussion (Misc queries) 3 September 30th 07 10:43 PM
Formula help in a circular reference Rayasiom Excel Worksheet Functions 2 September 19th 07 10:00 AM
Issues with my excel formula as it needs Circular reference - hlp im_not_excelling Excel Worksheet Functions 1 July 4th 06 08:21 AM
circular reference formula Abhi Excel Discussion (Misc queries) 4 March 12th 06 02:22 PM
Avoiding circular reference on formula Chuck W Excel Discussion (Misc queries) 4 February 22nd 05 02:52 AM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017