Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Copy worksheet containing names to other workbook w/o problems? | Excel Discussion (Misc queries) | |||
Person Names Smart Tag problems | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Recurring Problems with Links with Full Path Names | Excel Discussion (Misc queries) |