98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple Users Updating a Central Spreadsheet | Excel forum
Multiple Users Updating a Central Spreadsheet | Excel forum
Resolved · High Priority · Version 2013
Rehana has attended:
Excel Intermediate course
Multiple Users Updating a Central Spreadsheet
If there was a central spreadsheet on a network and the team had to update their section, how do you allow multiple users to update the spreadsheet without it being 'read only'?
RE: Multiple Users Updating a Central Spreadsheet
Hi Rehana
Thanks for your question.
For multiple users to access your Excel file you first save it into a common shared foldfer on the network.
Then make it into a shared workbook as follows:
Select the Review tab, Share Workbook
Tick the option
'Allow changes by more than one user at the same time.'
Pressin Ok then resaves the file and allows multiple users to open it without the workbook being read only.
If you ever need to make it unshared remove the same tick in Review, Share Workbook.
This is used mainly for data entry. Pivot tables and graphs cannot be created while it is a shared workbook.
Hope that works for your example with multiple sheets.
Regards
Doug Dunn
Best STL
Tue 17 May 2016: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |