Link C://excel to H://excel
 

I work at a company that has offices in several different states, but we have
a common or public drive. Can I put an excel spreadsheet there, where our
other offices can use and update it, and link it so it updates a spreadsheet
on my C drive automatically or at least when I open it?
Jean

Link C://excel to H://excel
 

You can use formulas in the workbook on the C: that retrieve values from the
workbook on the H: drive.

If you open both, you can select a cell in a worksheet from the H: drive
workbook and edit|copy.

Then select a cell on a worksheet from the C: drive workbook.

Edit|paste special|Paste link

You'll see syntax you have to use to retrieve those values.

If you close the H: drive workbook, excel will adjust the formula to get the
data from the closed workbook on the H: drive.

ps. One hint: You may find yourself having better luck using the UNC path
instead of the mapped drive letter:

='\\server\folder\folder\[book1.xls]Sheet1'!$A$1
instead of
='H:\folder\folder\[book1.xls]Sheet1'!$A$1



Jean wrote:

I work at a company that has offices in several different states, but we have
a common or public drive. Can I put an excel spreadsheet there, where our
other offices can use and update it, and link it so it updates a spreadsheet
on my C drive automatically or at least when I open it?
Jean

--

Dave Peterson