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 » Excel
Excel
Resolved · Medium Priority · Version 2007
Mon 23 Mar 2009, 09:33Delegate Rachel said...
Rachel has attended:
Excel Intermediate course
Excel Advanced course
Excel
How do you link spreadsheet data?
Mon 23 Mar 2009, 19:51Trainer Amanda said...
RE: Excel
Hello Rachel
Thank you for your question and welcome to the forum.
To create a link between one cell and another:
1. Select the cell you want to create the link in.
2. Type = into the cell.
3. Select the cell you wish to link to.
4. Press Enter. The link is created.
Kind regards
Amanda
Wed 25 Mar 2009, 10:00Delegate Rachel said...
RE: Excel
Thanks Amanda, however I need to link 'spreadsheets' not cells. One spreadsheet has certain information which I would like to draw from to use in another. Rachel
Wed 25 Mar 2009, 17:07Trainer Amanda said...
RE: Excel
Hello Rachel
Links are created on a cell by cell basis, unless you are using something like VLOOKUP or HLOOKUP to be able to pull through certain bits of information.
Kind regards
Amanda
Thu 2 Apr 2009, 14:15Delegate Simon said...
RE: Excel - formulae linking to other spreadsheets
For example:
='[Workbook name.xls]sheet name'!(absolute)cell reference
The worksheet name is in square brackets, it is immediately followed by the sheet name. The two of these are within one set of apostrophies. This is followed by an exclamation mark, then the cell reference, which will be absolute if you create the link as suggested above.
Thus... ='[Example_Workbook.xls]Sheet1'!$A$1
would return the contents of cell A1 of Sheet 1 of the linked Example_Workbook.xls.
You can use this as part of a larger formula, with more links if desired. I would guard against linking too much. In my experience, links have a tendency to break when linked spreadsheets are subsequently saved under new names and/or in new locations. Also, if you send a spreadsheet with links to someone else, it is very likely that the links will not work.
As far as possible it is better to copy the required data in to a new spreadsheet and work it up from there (although I appreciate the links can be more efficient and effective in some circumstances).
I hope that this helps.
Thu 2 Apr 2009, 14:15Delegate Simon said...
RE: Excel - formulae linking to other spreadsheets
For example:
='[Workbook name.xls]sheet name'!(absolute)cell reference
The worksheet name is in square brackets, it is immediately followed by the sheet name. The two of these are within one set of apostrophies. This is followed by an exclamation mark, then the cell reference, which will be absolute if you create the link as suggested above.
Thus... ='[Example_Workbook.xls]Sheet1'!$A$1
would return the contents of cell A1 of Sheet 1 of the linked Example_Workbook.xls.
You can use this as part of a larger formula, with more links if desired. I would guard against linking too much. In my experience, links have a tendency to break when linked spreadsheets are subsequently saved under new names and/or in new locations. Also, if you send a spreadsheet with links to someone else, it is very likely that the links will not work.
As far as possible it is better to copy the required data in to a new spreadsheet and work it up from there (although I appreciate the links can be more efficient and effective in some circumstances).
I hope that this helps.
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:Adjusting the Elevation and Rotation in a 3-D ChartFor any 3-D chart you create, you can adjust the chart |
