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
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
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
