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

Hi Di,

When you rename an Excel file that is linked to another Excel sheet, the link between the two files gets broken. This can cause errors in your formulas and data. However, you can easily update the links to the new file name by following these steps:

1. Open the Excel file that contains the links.
2. Click on the "Data" tab in the ribbon.
3. Click on "Edit Links" in the "Connections" group.
4. In the "Edit Links" dialog box, select the link that you want to update.
5. Click on "Change Source" and browse to the new file name.
6. Select the new file and click "Open".
7. Click "OK" to close the "Edit Links" dialog box.

This will update the link to the new file name and your formulas and data should work correctly. If you want to disable the links completely, you can break the links by following these steps:

1. Open the Excel file that contains the links.
2. Click on the "Data" tab in the ribbon.
3. Click on "Edit Links" in the "Connections" group.
4. In the "Edit Links" dialog box, select the link that you want to break.
5. Click on "Break Link" and then click "OK" to confirm.

This will break the link between the two files and your formulas and data will no longer be linked. However, be aware that breaking links may cause errors in your formulas and data if they were relying on the linked data.

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

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

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

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

Thank you
Di

"JLatham" wrote:

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