| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invalid Reference Message?
Excel2003 ... I have a file consisting of 1 worksheet ...
Issue is ... whenever I open the file I receive a Pop-Up Warning Message: "A formula in this worksheet contains 1 or more invalid references" Worksheet is small & appears to work fine ... & I can not find cause for this error message in any of my formulas ... Any suggestions? Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Invalid Reference Message?
With your WB open click (at the menu)
Edit, Goto..., Special... Button (atbottom) Select Formulas, errors (only) and OK Any functions errors in your WS should be Highlighted !! HTH, Jim May "Ken" wrote: Excel2003 ... I have a file consisting of 1 worksheet ... Issue is ... whenever I open the file I receive a Pop-Up Warning Message: "A formula in this worksheet contains 1 or more invalid references" Worksheet is small & appears to work fine ... & I can not find cause for this error message in any of my formulas ... Any suggestions? Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find which formula in Excel sheet has an invalid reference | Excel Worksheet Functions | |||
| How do I fix an Invalid Reference? | New Users to Excel | |||
| A formula in this worksheet contains one or more invalid reference | Excel Discussion (Misc queries) | |||
| Getting rid of a circular reference error message | Excel Discussion (Misc queries) | |||
| Formula Contains an invalid external reference to a worksheet | Setting up and Configuration of Excel | |||
Linear Mode
