Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Access to a Spreadsheet
We have a computer network that allows us to access a shared drive. On this
drive are to workbooks One workbook is linked to another, and both are open on different computers at the same time. Is there any way to change something on one workbook on one computer, save that workbook, and remotely update the workbook on the other computer? The bottom line is the workbook that is linked may be at a computer where no one currently is, but the workbook needs to be updated anyways, without anyone physically going to edit-links-update links. Any input would be greatly appreciated, Adam Bush |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Access to a Spreadsheet
Click TOOLS in the menu and select SHARE WORKBOOK and check the ALLOW CHANGES
check box. The advanced tab lets you set history, tracking and conflict resolution settings. This makes the workbook accessible simultaneously from any number of workstations. -- Kevin Backmann " wrote: We have a computer network that allows us to access a shared drive. On this drive are to workbooks One workbook is linked to another, and both are open on different computers at the same time. Is there any way to change something on one workbook on one computer, save that workbook, and remotely update the workbook on the other computer? The bottom line is the workbook that is linked may be at a computer where no one currently is, but the workbook needs to be updated anyways, without anyone physically going to edit-links-update links. Any input would be greatly appreciated, Adam Bush |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Access to a Spreadsheet
So let's say I have the same workbook open on two computers. If I make
changes on one, will it automatically update the other? Thanks Adam Bush "Kevin B" wrote: Click TOOLS in the menu and select SHARE WORKBOOK and check the ALLOW CHANGES check box. The advanced tab lets you set history, tracking and conflict resolution settings. This makes the workbook accessible simultaneously from any number of workstations. -- Kevin Backmann " wrote: We have a computer network that allows us to access a shared drive. On this drive are to workbooks One workbook is linked to another, and both are open on different computers at the same time. Is there any way to change something on one workbook on one computer, save that workbook, and remotely update the workbook on the other computer? The bottom line is the workbook that is linked may be at a computer where no one currently is, but the workbook needs to be updated anyways, without anyone physically going to edit-links-update links. Any input would be greatly appreciated, Adam Bush |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Access to a Spreadsheet
Other users in the file will have to do a save to pick up any changes that
have occurred. So there has to be some user interaction. -- Kevin Backmann " wrote: So let's say I have the same workbook open on two computers. If I make changes on one, will it automatically update the other? Thanks Adam Bush "Kevin B" wrote: Click TOOLS in the menu and select SHARE WORKBOOK and check the ALLOW CHANGES check box. The advanced tab lets you set history, tracking and conflict resolution settings. This makes the workbook accessible simultaneously from any number of workstations. -- Kevin Backmann " wrote: We have a computer network that allows us to access a shared drive. On this drive are to workbooks One workbook is linked to another, and both are open on different computers at the same time. Is there any way to change something on one workbook on one computer, save that workbook, and remotely update the workbook on the other computer? The bottom line is the workbook that is linked may be at a computer where no one currently is, but the workbook needs to be updated anyways, without anyone physically going to edit-links-update links. Any input would be greatly appreciated, Adam Bush |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Access to a Spreadsheet
The problem IS user interaction. There's no way to do this wothout saving at
the other location? Thanks Adam Bush "Kevin B" wrote: Other users in the file will have to do a save to pick up any changes that have occurred. So there has to be some user interaction. -- Kevin Backmann " wrote: So let's say I have the same workbook open on two computers. If I make changes on one, will it automatically update the other? Thanks Adam Bush "Kevin B" wrote: Click TOOLS in the menu and select SHARE WORKBOOK and check the ALLOW CHANGES check box. The advanced tab lets you set history, tracking and conflict resolution settings. This makes the workbook accessible simultaneously from any number of workstations. -- Kevin Backmann " wrote: We have a computer network that allows us to access a shared drive. On this drive are to workbooks One workbook is linked to another, and both are open on different computers at the same time. Is there any way to change something on one workbook on one computer, save that workbook, and remotely update the workbook on the other computer? The bottom line is the workbook that is linked may be at a computer where no one currently is, but the workbook needs to be updated anyways, without anyone physically going to edit-links-update links. Any input would be greatly appreciated, Adam Bush |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remote Access to a Spreadsheet
I'm not certain, but I believe that the Auto Recover settings in the
application will capture updates to a shared file. Click on TOOLS in the menu, click the SAVE tab and set the autosave to every 4 minutes or something. I -- Kevin Backmann " wrote: The problem IS user interaction. There's no way to do this wothout saving at the other location? Thanks Adam Bush "Kevin B" wrote: Other users in the file will have to do a save to pick up any changes that have occurred. So there has to be some user interaction. -- Kevin Backmann " wrote: So let's say I have the same workbook open on two computers. If I make changes on one, will it automatically update the other? Thanks Adam Bush "Kevin B" wrote: Click TOOLS in the menu and select SHARE WORKBOOK and check the ALLOW CHANGES check box. The advanced tab lets you set history, tracking and conflict resolution settings. This makes the workbook accessible simultaneously from any number of workstations. -- Kevin Backmann " wrote: We have a computer network that allows us to access a shared drive. On this drive are to workbooks One workbook is linked to another, and both are open on different computers at the same time. Is there any way to change something on one workbook on one computer, save that workbook, and remotely update the workbook on the other computer? The bottom line is the workbook that is linked may be at a computer where no one currently is, but the workbook needs to be updated anyways, without anyone physically going to edit-links-update links. Any input would be greatly appreciated, Adam Bush |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with using VBA to access a second spreadsheet | Excel Discussion (Misc queries) | |||
Sharing an Excel Workbook and Remote Web Access | Excel Discussion (Misc queries) | |||
Connect to Access Database On Remote Server | Excel Discussion (Misc queries) | |||
cannot access excel spreadsheet | Excel Discussion (Misc queries) | |||
Remote access to excel | Excel Discussion (Misc queries) |