G
Guest
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
excel sheet.
How do I disable the links or can't I do this?
Di
Thank You
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.
G
Guest
That sounds like it would work. I will give it a try when i work on monday.
Thank you for your help.
Di
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 said: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
G
Guest
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?
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 said: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 said: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
G
Guest
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.
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 said: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 said: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 said: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
G
Guest
Thank you
Di
Di
JLatham said: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 said: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 said: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.
:
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.