The file I would like to rename is linked to an excel sheet which is an
imported report from ACCESS . Everytime I generate a new report from ACCESS
it over wirtes the excel sheet from before. Sounds like option two would
work. Would the report coming from ACCESS be problem?

"JLatham" wrote:

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