Prev: runtime error 429 when trying to create Inet object
Next: how to delete an excel worksheet?
From: Trent G Trent on 15 Apr 2010 09:43
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

From: Paul C on 15 Apr 2010 14:36
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
>
 | 
Pages: 1
Prev: runtime error 429 when trying to create Inet object
Next: how to delete an excel worksheet?