Multiple users accessing Excel file on shared folder.
I'm looking to have an excel file in a shared folder in a small network 5-10 users.
1) If multiple users access the file at the same time, it will only save the user who saved the file last, correct? Is there any way around this?
2) Is there any way of knowing that a user has the excel file opened? Is there a way to make it (in whatever way.. altering the folder, using excel, etc.) so that the user knows if another user has the file opened OR to block the user trying to access the already opened folder?
Thanks in Advance!
Reply to Q1
You can share a workbook so that multiple people can open it, alter it, save it
This option is under the Tools menu > ShareWorkbook
Reply to Q2
If the workbook is not setup to be shared then the person will get a popup saying Filename is locked foe editing by users login id with the option to open in read only mode
Please Read Forum Rules
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post
Top Excel links
for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1