98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking workbooks
Linking workbooks
Resolved · Medium Priority · Version 2010
Mon 30 Sep 2013, 23:19Delegate Genta said...
Genta has attended:
Excel Advanced course
Linking workbooks
If you wanted to link 2 tables located in different workbooks, do the columns of each table have to be titled the same?
I have a table in one workbook, the last column of which needs to update the table on another workbook.
Is the linking done as you would normally link 2 workbooks?
Tue 1 Oct 2013, 09:19Trainer Cindy said...
RE: Linking workbooks
Hello Genta,
Thank you for your question regarding Linking workbooks.
If you want to link 2 tables in different workbooks, the column headings do not need to be the same. And yes, the linking is done in the same way as normal.
Hope this helps.
Kind regards
Cindy
Microsoft Office Trainer
Mon 7 Oct 2013: Automatically marked as resolved.
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:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |
