If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Where is circular reference?
I'm using Excel 2002. I have a spreadsheet with several function cells.
When I open the sheet, I get a circular reference message. It doesn't tell me where the reference is. I can click OK and the help appears or Cancel and the popup goes away. How can I find out which cell is causing the circular reference? Thanks, Brett |
#2
|
|||
|
|||
Where is circular reference?
Viewtoolbarscircular reference
-- Regards, Peo Sjoblom "Brett" wrote in message ... I'm using Excel 2002. I have a spreadsheet with several function cells. When I open the sheet, I get a circular reference message. It doesn't tell me where the reference is. I can click OK and the help appears or Cancel and the popup goes away. How can I find out which cell is causing the circular reference? Thanks, Brett |
#3
|
|||
|
|||
Where is circular reference?
Click on TOOLS MENU then click CUSTOMIZE then click the
TOOLBARS tab and select the CIRCULAR REFERENCE check box and you will get a pop up for locating and resolving circular references. -----Original Message----- I'm using Excel 2002. I have a spreadsheet with several function cells. When I open the sheet, I get a circular reference message. It doesn't tell me where the reference is. I can click OK and the help appears or Cancel and the popup goes away. How can I find out which cell is causing the circular reference? Thanks, Brett . |
#4
|
|||
|
|||
Where is circular reference?
Got it. Thanks.
Brett "Peo Sjoblom" wrote in message ... Viewtoolbarscircular reference -- Regards, Peo Sjoblom "Brett" wrote in message ... I'm using Excel 2002. I have a spreadsheet with several function cells. When I open the sheet, I get a circular reference message. It doesn't tell me where the reference is. I can click OK and the help appears or Cancel and the popup goes away. How can I find out which cell is causing the circular reference? Thanks, Brett |
Thread Tools | |
Display Modes | |
|
|