If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problems with 'Names'
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 Trent |
#2
|
|||
|
|||
Problems with 'Names'
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 enabled. -- If this helps, please remember to click yes. "Trent G" wrote: 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 Trent |
Thread Tools | |
Display Modes | |
|
|