Problems with 'Names'


Trent G

I am using MS Excel 2007.

I have a series of linked files - 1 main 'parent' file with 5 'children'
files. The parent file contains 'names' which are used in all the children
files (eg..titles across columns, drop down boxes/lists (referencing name
ranges) etc)

I need to find and replace some of the external links in the files with new
file extensions - XLSM and XLSX.

I can find and replace as required in all the formulas which work, however
the 'names' in the file still refer to the .XLSM file. If you search the
entire workbook .XLSM cannot be found but under "Edit Links" a link to the
original file still exists. When you break the links, all the name ranges
are turned to values.

Any ideas on how to change this?

Many thanks



Paul C

You are on the right track but don't break the links, change the source to
the new file(s). If your change source button is not enable, you likely have
protected sheets. If you unprotect all the sheets the button should be

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