Obsession Massage
Toronto Escorts

Excel: Circular Formula Problem

Keebler Elf

The Original Elf
Aug 31, 2001
14,572
203
63
The Keebler Factory
I've inherited an Excel file at work that every time you load up gets hit with a popup message warning of a malfunctioning formula due to a circular formula problem.

I understand what the problem is, but I can't get rid of the message. It doesn't help that I can't find where the circular problem is. I think the cell in question may have been deleted at some point in the past, yet the message keeps popping up.

Is there some way to permanently get rid of this message (for this file) or at least locate the source cell of the problem?
 

MarkII

New member
Sep 22, 2004
1,904
0
0
Keebler...I found some info on this in the link below. Won't be a direct answer but it might give you somewhere to begin looking.

Seems the answer is in checking the formula linkage.

http://www.mrexcel.com/archive2/11400/12713.htm
 

Keebler Elf

The Original Elf
Aug 31, 2001
14,572
203
63
The Keebler Factory
Thanks. I don't get any blue arrows and I think the formula might have been linked to a different spreadsheet (?).
 

pianoman

New member
Sep 14, 2001
67
0
0
Circular Error Message

Depending on the version of Excel ( office 2002 and greater ) you are using there is a toolbar for circular references. You can find it in the help section. Usually you will also see a cell reference at the bottem of your file. If you go to that cell Under tools auditing there is a trace precidence icon which will show you ( in Office 2000 ) the cells that are used in that calculation. That should help you track it down.

I recently began having files give me this error message when I knew there wasn't a problem. It appeared to be related to the recent microsoft security updates of about a month ago. The only was I was able to resolve the problem was to only have one file opened at a time. I also restored my window to pre update condition and turned off the automatic update feature until I solve the problem.

Closing the file without saving it and reopening it usually corrected the situation.

Was the file attached to an email through outlook? This may also be the source of the problem.
 
Toronto Escorts