This feature seems to have been removed from the recent "update" on Office 365. In the Allow Users to Edit Ranges dialog, click New button.
much rather my users enter and edit data in a true database that was designed from the ground up to be a multi-user application, and then bring the data into Excel for analysis using either an external data range or a pivot table.--C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "Vindell" wrote in message news:3DC59659-526A-4EDB … Before you allow certain users to edit the range of cells, you should make sure that the workbook has not been protected.
Click on Trust Center Settings. Check the box “Allow changes by more than one user at a time. Click on OK. You will be able to share workbook. When I select range 1, then the allow users to edit ranges option is disabled. The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time. Excel Online offers basic options for sharing a workbook from any Web browser. if more than one user changes same cell on save they will be prompted "whose changes to keep" now if they choose theirs the other gets deleted Presently - when one person is editing the workbook, Sharepoint correctly says the file is locked by user xxxx for editing. That's the real problem. Multiple people editing excel worksheet simultaneously: How to prevent conflicts/overwrite The database/worksheet will use some macros to process files and enter data.