One Excel File updated by many

shonaart

Board Regular
Joined
Nov 1, 2004
Messages
214
Hi
Please could you give me some advice.
My IT guys have created a folder on the Network where I have placed a Excel File. A number of staff will update & delete information on different parts of the worksheet.

Is there any setting I have to place on the worksheet or anything I need to know. I was worried that maybe I have opened the file at the same time as some one else and when I save it their info will not be saved ??

You advice will be greatly appreciated.
Thanks for your time and help.
Vaughan Lundin
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

agerrard

Active Member
Joined
Apr 4, 2005
Messages
405
Is the file that you are working in saved on a network (so all other users will be sourcing it from the network as well?). If this is the case, then Excel will tell you if another user is currently working in that file, so you shouldn't have any problems.
 

shonaart

Board Regular
Joined
Nov 1, 2004
Messages
214
full access

Hi
Yes my file is on a network and other have been given full access to the file.
Thanks
Vaughan
 

Forum statistics

Threads
1,136,267
Messages
5,674,729
Members
419,523
Latest member
Urnovio

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
Top