Abhijit has attended:
Excel VBA Intro Intermediate course
Updating linked workbooks
If 2 workbooks are linked and we change the file name using Save as of the source file, does the destination filed has to be opened for the change to take effect?
RE: Updating linked workbooks
Hi Abhijit
If you have both files open and you rename the source file by using save as then the destination file automaticaly updates its reference to the new filename of the source. If the desitination file (that contains the reference) is closed when the source file is renamed (using save as) the next time you open the destination file you will need to go to Edit > Links and change the source file from the old document to the new one.
Hope this helps - let us know if you have any further questions.
Kind regards,
Andrew
