Multiple users

BRIITO

New Member
Joined
Oct 3, 2008
Messages
19
Does anyone know how to set XL so that in a workgroup, multiple users can modify an excel file at the same time?

any help will be greatly appreciated!!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Makrini

Well-known Member
Joined
May 22, 2007
Messages
1,035
tools\share workbook...

not highly recommended.

I have to second this. I use shared workbooks in a limited number of occasions - and have trouble with them without fail...

If it MUST be shared then go ahead - but if there is ANY other solution - use it.
 

crimson_b1ade

Well-known Member
Joined
Sep 27, 2008
Messages
1,557
we've actually banned 'shared' workbooks from the office as a result of file corruption and lockouts and other random errors that cause more work than had we not employed the use of a shared file.
 

Makrini

Well-known Member
Joined
May 22, 2007
Messages
1,035

ADVERTISEMENT

I have one key shared file that was written by my predecessor and I have modified to kind of work.

I plan to replace it next week with DAP directly off my Access database instead..
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,661
Office Version
  1. 365
Platform
  1. Windows
For an opposing viewpoint: I have been using shared workbooks at work pretty much every day for many years with virtually no adverse consequences.
 

Forum statistics

Threads
1,141,715
Messages
5,708,046
Members
421,540
Latest member
quocbinh

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