| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find which formula in Excel sheet has an invalid reference
I have been receiving an error maessage that my worksheet contains one or
more invalid references. (Everytime a new data value is entered) And that I should varify that my formulas contain valid references . The trouble is that my workbook contains lots of formulas and I have no idea where to look for the invalid reference. It seems that if Excel can recognize that there are invalid references, it should be able to tell me where they are. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! Formula to find the address of particular value in sheet | Excel Worksheet Functions | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
Threaded Mode
