Multi-spreadsheet formulae

Resolved · Medium Priority · Version 2003

Tue 23 Sep 2008, 11:37 Delegate 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:41 Trainer 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:21 Delegate 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:59 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Switching Between Spreadsheets

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

View all Excel hints and tips