PC Review


Reply
Thread Tools Rate Thread

How do I track down 'invalid references'

 
 
Dreiding
Guest
Posts: n/a
 
      13th Feb 2008
I have a workbook that has many worksheets and associated formulas. Every
once in a while when I close the file I get the following message:
----------------------
A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain valid path, workbook, range name, and cell
reference.
-----------------------

I've been able to track this checking to be after "Workbook_BeforeClose"
execution, but I don't have a clue on finding the formulas with the invalid
references.
I found cells with "#DIV/0!", "#VALUE!", #NUM!, #N/A.
Which of these should I attach first? Could it be something else?

Any suggestions?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Track Changes for Cross-References Pam Microsoft Word Document Management 4 3rd Nov 2009 09:41 PM
How remove invalid references in Tools>References drop down box? EagleOne@discussions.microsoft.com Microsoft Excel Programming 1 7th Jul 2009 09:52 AM
Update of cross references with track changes on Alessandro Triglia Microsoft Word Document Management 1 18th Jun 2008 09:53 AM
Why is track changes crossing out cross-references when TC toggle =?Utf-8?B?SG9sbHk=?= Microsoft Word Document Management 6 14th May 2007 10:37 PM
Re: track changes, cross references and printing Chad DeMeyer Microsoft Word Document Management 0 14th Jul 2004 09:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:31 PM.