Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Find formulas that use a named range
I have a client who has a large workbook. He converted the file from 2003 to
2007 and now it hangs when he manually calculates one of the sheets. I looked in the Name Manager and saw that many named ranges had a location in another file and that in the Value column of that list, it said #REF. I imagine because that file is not currently open. Is there a way to find all the formulas that contain a reference to that Named Range? Additionally, if any of those files have been moved or deleted, would that cause the calculation to hang but not receive an error message? -- Judy L |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find in Named Range problem (2nd Try) | New Users to Excel | |||
Find Row in a named range | Excel Worksheet Functions | |||
Find Cell in Named Range | Excel Worksheet Functions | |||
VBA: find number of columns in named range? | Excel Discussion (Misc queries) | |||
How to find all formulas that used a certain named range | Excel Discussion (Misc queries) |