ExcelBanter - Reference another spreadsheet on a share drive

Easiest way, and way that will work from any system on the network:
Go to the other file using 'My Network Places' and open it. Now just treat
it as if were part of your own workbook. In the workbook you want to be
linked to it and get summary values from, set things up to create a formula
by starting a cell with the = symbol, then click on the other workbook, go to
the needed sheet, choose the range of cells to be used and hit enter.

For doing calculations or using functions with reference to the other book,
start your cell's formula off with the function such as:
=sum(
and then go to the other book/sheet/cells and select them and hit enter.
Normally that will provide the closing ). If it doesn't you'll get a message
telling you that it's missing such a thing and usually will repair it for you.

Basically, anytime you need to reference data in the other workbook, get
everything ready to put in cell references and then go identify those cells
in the other workbook.

When you close the other workbook, it will still retain a link to it and
your functions will still work. There are exceptions - some functions will
not work unless both books are actually open, but that's a relatively short
list.

"Robert C." wrote:

Can anyone help me reference a range of cells off another spread sheet on our
share drive? for example, sumerize a range of cells to represent M-T-D, Y-T-D
and last 52 weeks.