How to get a file to auto update fron a shared file.

MBCMDR

New Member
Joined
Mar 19, 2015
Messages
5
Ok,

This not so easy in my case. I have a shared file with shapes on multi monitor for each working position as a share file. To edit shapes you have to un-share the file, that I do in code and re-share in code when complete (10-30sec).
My problem is the when on share I lose the connection between all the other using the shared files in the share.

File located on a central server.

I looking for a way that have, the file on the display to reconnect themselves when the file is share again.
Sample 4 people sharing the file user 1 does and edit and it un-shares while update and then re-shares the file. Code so user 2,3,4 will auto link back up to the file. same if user 4 did edit and 1, 2, 3 would auto link back up to current info..

Thz
 
Last edited:

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,223,956
Messages
6,175,619
Members
452,661
Latest member
Nonhle

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