O
Office Productivity Consultant
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?
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?