LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default Trace errant formula to stop annoying message

Hi,

Every now and then my worekbook throws up a dialogue box with the following
warning message:

'A formula in this worksheet contains one or more invalid references

Verify that your formulas contain a valid path, workbook, range name and
cell reference'


Short of ploughing through every page and searching every cell containing
formula, does anyone know an easier way of locating the culprit formula?

Thanks and regards, Mark


 
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
Stop displaying a message because of a formula Urgent Help Excel Worksheet Functions 2 April 10th 09 07:29 PM
How Do You Stop Annoying Excel Message Boxes? Colin Hayes Excel Worksheet Functions 36 January 14th 08 09:44 PM
excel links popup message - very annoying marsenal Excel Discussion (Misc queries) 3 August 16th 06 05:45 AM
Annoying clipboard message Sion Smith[_2_] Excel Programming 2 August 25th 04 01:31 PM
stop annoying cell selection change mark kubicki Excel Programming 1 February 25th 04 11:33 PM


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