Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2017, 05:53 AM
riothecat riothecat is offline circular reference Windows 10 circular reference Office 2007
Novice
circular reference
 
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default circular reference

I have a spreadsheet that when I open it, I have to update the sheet or not. I hit the button (either one) and it says I have a circular reference error. I have gone over the whole book and cannot find it. I used the error checking tool and nothing. What else is there top do:
Reply With Quote
  #2  
Old 06-28-2017, 09:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline circular reference Windows 7 64bit circular reference Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
usually the circular reference is indicated in the lower left corner of the sheet
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 06-28-2017, 10:53 AM
riothecat riothecat is offline circular reference Windows 10 circular reference Office 2007
Novice
circular reference
 
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default

Thank you. I couldn't find the circular reference, even through error check. Everything else but no circular references. sTill have the error but deleted all but one sheet and it is still there
Reply With Quote
  #4  
Old 06-28-2017, 11:03 AM
NBVC's Avatar
NBVC NBVC is offline circular reference Windows 10 circular reference Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Best to post the workbook if not confidential...so we can help investigate...
Reply With Quote
  #5  
Old 06-28-2017, 11:27 AM
riothecat riothecat is offline circular reference Windows 10 circular reference Office 2007
Novice
circular reference
 
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default

Unfortunately I cannot post, privileged work product. It's just an annoyance, I'll try to redo it and leave out product and work info.

Thank you all
stand by for another, hopefully easier post
Reply With Quote
  #6  
Old 06-28-2017, 03:29 PM
joeu2004 joeu2004 is offline circular reference Windows 7 32bit circular reference Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

Quote:
Originally Posted by riothecat View Post
I have a spreadsheet that when I open it, I have to update the sheet or not. I hit the button (either one) and it says I have a circular reference error.
Is this the same file that has "an amount error after the calculations", per your posting at https://www.msofficeforums.com/excel...e-amounts.html ?

I was suggesting that the latter is due to rounding issues.

But circular references, be they on purpose or by accident, can cause all sorts of unexpected results.
Reply With Quote
  #7  
Old 06-29-2017, 10:56 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline circular reference Windows 7 64bit circular reference Office 2010 64bit
Novice
 
Join Date: Jun 2017
Location: suburban Chicago
Posts: 28
ProudLiberal is on a distinguished road
Default

Are you using the Circular References tool in the Error Checking dropdown? It should identify both the cell location and sheet where the circular reference is (see attachments)
Attached Images
File Type: png circular reference 1.png (69.8 KB, 14 views)
File Type: png circular reference 2.png (78.9 KB, 14 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do the green circular arrows appear or not appear on the save icon aidih Office 0 04-23-2014 05:06 AM
circular reference Why does the circular and U Turn arrow only go left to right? Cerdic PowerPoint 1 10-22-2013 07:16 PM
circular reference Circular Reference Warning in Excel Sheet. Rahmat_uk20 Excel 3 06-08-2012 02:31 AM
Circular Reference Errors BecciJane Project 2 06-01-2011 03:11 AM
Circular error markg2 Excel 2 05-17-2010 07:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft