Multiple users updating excel spreadsheet

Rated 4.26/5 based on 855 customer reviews

Hi all, I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations.

multiple users updating excel spreadsheet-64

multiple users updating excel spreadsheet-87

multiple users updating excel spreadsheet-45

This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance. Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker.. Every so often when I attempt to save a file, (including save as), Excel won'r let me. Some days I can work without this problem, other days I encounter this 2 or 3 times.

Hey guys, I have an excel file that is password protected. Is there any way to unlock it & do it modifiable when I already opened it as read only (of course without having to close it & re-open it and enter password lol) Thanks, I have a VBMacro Excel file loaded on a Server that numerous people access.

A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop.

Prevent multiple users accessing the same file at one time regardless of read only or not.

I have an excel file in a LAN drive that is shared by a couple departments. has restricted access to this folder to a handful of people who are intimate with this project. This project has live for a few months now, so there is no need for more than one person to be in the file at a time.

Leave a Reply