Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invalid references in a formulas | Excel Discussion (Misc queries) | |||
invalid references | Excel Worksheet Functions | |||
invalid references in formula | Excel Discussion (Misc queries) | |||
"A formula in worksheet contains 1 or more invalid references?" | Charts and Charting in Excel | |||
" invalid cell references. | Excel Worksheet Functions |