Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 80
Default Finding Invalid References

Hi

I have a very large workbook with many thousands of calculations.

An error message has recently appeared when saving.

"A formula in this worksheet contains one or more invalid references.
Veryfy that your formulas contain a valid path, workbook, range name, and
cell reference."

There are no links to other workbooks.

Does anyone know if there is a tool, within Excel 2007, which will help me
to find the erroneous formulae?

Regards

Phil Smith
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Finding Invalid References

If excel thinks you have links, then you have links.

I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm



Philip J Smith wrote:

Hi

I have a very large workbook with many thousands of calculations.

An error message has recently appeared when saving.

"A formula in this worksheet contains one or more invalid references.
Veryfy that your formulas contain a valid path, workbook, range name, and
cell reference."

There are no links to other workbooks.

Does anyone know if there is a tool, within Excel 2007, which will help me
to find the erroneous formulae?

Regards

Phil Smith


--

Dave Peterson
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 a formulas PapaBigE Excel Discussion (Misc queries) 3 October 1st 08 08:14 PM
invalid references Shooter Excel Worksheet Functions 2 January 15th 08 12:20 AM
invalid references in formula jk Excel Discussion (Misc queries) 2 September 25th 06 08:04 AM
"A formula in worksheet contains 1 or more invalid references?" Bill Charts and Charting in Excel 1 September 6th 06 01:22 PM
" invalid cell references. BillyRogers Excel Worksheet Functions 0 March 5th 06 03:30 AM


All times are GMT +1. The time now is 08:58 PM.

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

About Us

"It's about Microsoft Excel"