Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking then Sorting Objects of the Link - Is this feasible? | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
Link Link Link | Excel Discussion (Misc queries) | |||
Breaking the link | New Users to Excel | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |