Excel 2007 - Find formulas that use a named range

  • Thread starter Office Productivity Consultant
  • Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top