Shared excel - multiple users

benwork

Board Regular
Joined
Oct 8, 2010
Messages
69
Hi all,

I'm looking to solve a work issue by having a shared workbook which will be saved on a shared network drive and I have a few questions around it. I'm doing a sanity check before I allocate time to build this thing.

There will be about 5-10 people editing the spreadsheet and probably about the same time of the day (all within about 15 minutes)
They will only be comments (based on each areas performance) entered into a specific cell so there really isn't any complexity to the spreadsheet, other than it being shared and used by multiple users.

Is this suitable for my needs?

What type of issues will I encounter?

Is there an better method and why?

Really appreciate the assistance

Thanks in advanced

Ben
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
Simultaneously working on a shared workbook should not cause any problems as long as everyone has their own worksheet and good agreements are made (and everyone adheres to it). The moment the workbook is saved by a user Excel will ask for a decision the moment Excel encounters differences in equal data areas. This may cause confusion for users when working on the same worksheet.
 

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
720
Office Version
  1. 365
Platform
  1. Windows
If you need to all work the same file at the same time
OneDrive/SharePoint is best for this as it allows co authoring
 

Watch MrExcel Video

Forum statistics

Threads
1,122,364
Messages
5,595,719
Members
414,013
Latest member
tnobbs

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