updating linked workbooks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Updating linked workbooks

Updating linked workbooks

resolvedResolved · Medium Priority · Version 2007

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

RE: Updating linked workbooks

Thanks


 

Excel articles

Please browse our web site to find out more about
excel computer training and other training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.