LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis
 
Posts: n/a
Default Odd "circular refference" error

When I open a particular workbook, I am getting an error message that I have
not seen befo

"Microsoft Excel cannot calculate a formula. There is a circular reference
in an open workbook, but the references that cause it cannot be listed for
you. Try editing the last formula you entered or removing it with the Undo
command (Edit menu)."

I am familiar with the usual €ścircular reference€ť message, and how to deal
with it, but this isnt it. Since I am trying to open the workbook, the
message's suggestions obviously do not apply. No such message appeared
before the workbook was last saved. Without the circular reference toolbar,
or any other visual clues, it is not obvious how I can locate the offending
cell (assuming that there is one).

Am I correct in assuming that the workbook somehow became corrupted during
the last save, and that I should rescue what I can and start over with an
earlier backup copy?

Possibly useless additional information: An add-in is required to fully
recalculate; if it is present, then Excel crashes when I try to open the
file. If I unload the add-in, then I can open this file, permitting rescue
efforts. No formulas directly involving the add-in were edited in the last
session where the file opened properly.

Jerry
 
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
Custom error bars not working [email protected] Charts and Charting in Excel 3 December 8th 05 10:17 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Problem Opening an Excel File MSO9.DLL Error Mash23 Links and Linking in Excel 0 August 24th 05 03:21 PM
error "module not found" Amit Excel Discussion (Misc queries) 1 May 13th 05 01:24 PM
#REF error Christen Excel Worksheet Functions 5 November 3rd 04 07:29 PM


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

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

About Us

"It's about Microsoft Excel"