Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not really. You can take a look at shared workbooks but read up on them
carefully before you head down that road. Sharing is a form of protection and it locks out a lot of functionallity in XL. I personally never share workbooks. It causes a lot more problems than it solves. When I need concurrent access I tend to use a database to store the data. You can still use XL as the front end but all of the data is stored in the database. Doing this I can make the spreadsheet read only as there is nothing actually being saved in the spreadsheet. Databases have no difficulty handling concurrency and the XL users have real time access to the data being input. That being said it can be a whole pile of work, especially if you do not understand ADO... -- HTH... Jim Thomlinson "Rachel" wrote: Hi all, I have created a userform in excel and I want it to be shared to multiple user in that it is being edited by multiple user at the same time. Is this possible? THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
allow a user to edit ranges in a protected worksheet | Excel Worksheet Functions | |||
Multiple user excel file | New Users to Excel | |||
Tabbing thru User-Edit Cells in Protected Sheet | Excel Discussion (Misc queries) | |||
Edit exsisting data with userform | Excel Discussion (Misc queries) | |||
Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) |