No and yes. Not a problem in that as long as you change the name and the
file is an Excel file.

Yes in that unless the data is in the same number of data items, located in
the same cells each time, then you could have a problem - the other workbook
would pick up the wrong data.

The worksheet name after importing needs to be the same as before also. I
don't know if you'll have to change it during the import process or not. If
it always comes in as the same sheet name, then again, that's not a problem.



"dls25" wrote:

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