Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding one or more "Invalid References" in big spreadsheet
I need help with an automatic way to find the one or more formulas in a large
spreadsheet that have "invalid references". Is there a tool or method to easily find the offending formula(s)? I have a rather large workbook that has many pivots and a summary scorecard tab that has approx 5000 formulas in it. I received an error when saving this workbook as follows: "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." Thanks, BAM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding one or more "Invalid References" in big spreadsheet
Hi,
Since you haven't told us what version of Excel you are using, you may want to look through these topics: http://support.microsoft.com/search/...3comm=1&res=20 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Brian - FM" wrote: I need help with an automatic way to find the one or more formulas in a large spreadsheet that have "invalid references". Is there a tool or method to easily find the offending formula(s)? I have a rather large workbook that has many pivots and a summary scorecard tab that has approx 5000 formulas in it. I received an error when saving this workbook as follows: "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." Thanks, BAM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
Finding Invalid References | Excel Worksheet Functions | |||
Missing data and "invalid references" | Charts and Charting in Excel | |||
"A formula in worksheet contains 1 or more invalid references?" | Charts and Charting in Excel | |||
" invalid cell references. | Excel Worksheet Functions |