If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
workbook qustion
I have a share drive that contains some files that need to be able to be
edited by two people at the same time without the other having to close out of the program. Also if you know of a feature of Excel to automatically save the file to the share drive every few seconds (or whatever amount of time) that would also be helpful; I know about Autosave and that isn’t what we need since it saves a copy of the file somewhere else for backup purposes). This way if my associate makes a change to the file; it would update on my screen as well. |
#2
|
|||
|
|||
workbook qustion
Take a look at shared workbooks. That being said XL does not handle
conccurenty well and from my experience shared workbooks can be a bit buggy. Additionally before proceeding with a shared workbook look at the restrictions on shared workbooks carefully. I personally never use shared workbooks but some people around here seem quite fond of them. Generally speaking a database is a much better solution for sharing data... -- HTH... Jim Thomlinson "brfrench" wrote: I have a share drive that contains some files that need to be able to be edited by two people at the same time without the other having to close out of the program. Also if you know of a feature of Excel to automatically save the file to the share drive every few seconds (or whatever amount of time) that would also be helpful; I know about Autosave and that isn’t what we need since it saves a copy of the file somewhere else for backup purposes). This way if my associate makes a change to the file; it would update on my screen as well. |
Thread Tools | |
Display Modes | |
|
|