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 » Multi-spreadsheet formulae
Multi-spreadsheet formulae
Resolved · Medium Priority · Version 2003
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
Thu 25 Sep 2008, 11:41Trainer Greg said...
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
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..)
Fri 3 Oct 2008, 10:59Trainer Amanda said...
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
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:Switching Between SpreadsheetsAs the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet. |
