That sounds like it would work. I will give it a try when i work on monday.
Thank you for your help.
Di




You have a couple or three options.
First - you could open both workbooks and then save the one to be renamed
with the new name. The links will be updated in the other one automatically
with the proper filename.

Second and Third: open the workbook with the broken links and choose Edit |
Links (may have to expand the list to see that option). This brings up a
dialog that allows you to choose to BREAK the links, using the last known
good values as the basis for cell contents, OR you can use [Change Source] to
browse to the renamed file and identify it as the source of the links, which
will revise the formulas linked to it appropriately.

"dls25" wrote:

I have problems when I rename an excel file, witch is linked to another
excel sheet.
How do I disable the links or can't I do this?

Di
Thank You