Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multi-spreadsheet formulae
|
|
|
The UK's most regular 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. |
Multi-spreadsheet formulae
Resolved · Medium Priority · Version 2003
Reply Tue 23 Sep 2008, 11:37Delegate Ludovic said...
Ludovic has attended:
Excel Intermediate course
Multi-spreadsheet formulae
When linking up with other spreadsheets, for instance asking to lookup in another file or if in another file do you type out the whole file as in, for instance
N:/ assets/uk/reports/2008/combined daily
or is
/combined daily/ sufficient
Does this depend on the command (ie whether its look up or not)?
Thanks
For upcoming training course dates see: Pricing & availability
RE: multi-spreadsheet formulae
Hello Ludovic,
My name is Greg Eze and I am one of the trainers at BEST.
In order to link up with other spreadsheets, it is necessary to put the whole path unless your workbook is in the same location. If that is the case, you need to put [combined daily.xls] then the name of the worksheet.
I hope this helps. Please contact us if you need further assistance.
Thank you,
Greg
BEST STL Training
Reply Mon 29 Sep 2008, 17:21Delegate Ludovic said...
RE: multi-spreadsheet formulae
When you say the same location, and going on some of the workbooks I have open, I take it you mean if workbooks are in the same drive then I can use the shorter title (combined daily.xls).
Only when workbooks are in different drives do I have to specify (N:/..../comb..)
RE: multi-spreadsheet formulae
Hello Ludovic
Sorry for the delay in coming back to you on your query.
Links will display differently when workbook you have linked to is open as opposed to closed. When the workbook you have linked to is open, the link will display without the location of the file, whereas when it is closed you will see the filepath as well.
The 'same location' that Greg refers to means that the file you have linked to is saved in exactly the same place (drives and folders) as the file that the link/s are in.
I hope this helps.
Amanda
|