Multiple Users Updating the Same Sheet Simultaneously... Is This Possible??

killpaddy

Board Regular
Joined
Jul 31, 2012
Messages
52
Hello,

I have a workbook with a list of drawing numbers (with customer, date, author etc.). New drawing numbers and their associated row of information are entered onto the sheet...

..HOWEVER, multiple users can be at least viewing and potentially entering information simultaneously.

I have written code where multiple people can view the same read only file, but not edit it and it be updated.

It seems quite unlikely, but is there anyway of 'live' updating a workbook whilst multiple people are viewing it? Or at least notifying other users when the sheet has been updated?

Thanks,

Joe
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Ive just thought. I could have a read only workbook for viewing (e.g. DRAWINGS LIST.xls) and an update workbook that isn't read only (e.g. DRAWINGS LIST Update.xls). Then when a user wants to update the list they enter it in DRAWINGS LIST Update.xls which then copies it over to DRAWINGS LIST.xls (or just saves as the read only DRAWINGS LIST.xls) then instantly closes DRAWINGS LIST Update.xls.

Is there any way of notifying another user viewing the readonly file that an update had occurred?
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top