Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find: formulas containing invalid references?
In a large wksheet, find the faulty formula?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find: formulas containing invalid references?
Perhaps you could try pressing F5 Special, check "Formulas" & uncheck all
its sub-options except "Errors" OK -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Boswell" wrote: In a large wksheet, find the faulty formula? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find: formulas containing invalid references?
Thank You ... exactly my request!
Except now it reports 'no cell found', while, the error: 'formulas containg invalid reference', comes up. ? "Max" wrote: Perhaps you could try pressing F5 Special, check "Formulas" & uncheck all its sub-options except "Errors" OK -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Boswell" wrote: In a large wksheet, find the faulty formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invalid References | Excel Worksheet Functions | |||
Finding Invalid References | Excel Worksheet Functions | |||
Invalid references in a formulas | Excel Discussion (Misc queries) | |||
invalid references | Excel Worksheet Functions | |||
Cant find & delete invalid formulas or links | Excel Discussion (Misc queries) |