Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default How do I track down 'invalid references'

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
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
Invalid References in formula ck13 Excel Discussion (Misc queries) 4 May 10th 10 08:23 AM
Invalid references Shell Excel Discussion (Misc queries) 0 December 29th 09 02:47 PM
Invalid References Elliot Excel Worksheet Functions 1 August 10th 09 08:13 PM
invalid references Shooter Excel Worksheet Functions 2 January 14th 08 11:20 PM
pesky invalid external reference error: how to track it down? Matthew Dodds Excel Programming 0 November 17th 06 03:33 PM


All times are GMT +1. The time now is 12:10 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"