98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Linking workbooks
microsoft excel training - Linking workbooks
Resolved · Low Priority · Version Standard
Ashpal has attended:
Excel Intermediate course
Excel Advanced course
Linking workbooks
How do you update links within a workbook that has been linked to another workbook without manually having to update each cell?
RE: Linking workbooks
Dear Ashpal
Thank you for attending Excel Intermediate course.
Please note that if you have linked the two files then they should automatically update without you having to do anything.
When you link two workbooks together you have the Source file (This is the file where the original data is COMING FROM) and the destination file (The file where the data is GOING TO).
If the Source file is closed and you try to open the Destination file then a message is displayed informing you that the file has external links and you are given the option of updating or not updating the file.
But if both the Source and Destination files are open and you change the data in the Source file then the cells in the Destination file automatically update.
I hope this helps. If you need further clarification or may have a work based scenario then please post your question and I
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Saving your Excel Spreadsheet as a CSV FileIn situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps. |