If a user tries to open a Workbook that is already open, then they normally get a message saying that the File is locked by a certain user and would you like to open the file in Read only mode. However, you can open a workbook in shared mode by following these steps.
Note: To utilize this feature, make sure your computer is running in the network environment.
To share an Excel file
To know the advanced share workbook features
There are three areas that you can change:
1. Track Changes.
Microsoft Excel allows you to store over 32000 days worth of changes to your Excel file, however, there is a catch. All of that information is stored in your file and consequently your file will grow exponentially. Most organisations generally work on a maximum of 30 days (the default). However the value entered simply depends on your workbooks requirements. You can choose the second option - Don't keep change history. This simply ensures no changes are maintained.
2. Update Changes.
This function simply allows you to define how often the spreadsheet changes are updated. The most common element users use is the Update Every 15 minutes. What this does is to force a save and filter through the data to all the users. One point to consider is that if you workbook is relatively large and you are working on a slow computer you may want to increase that time to 30 minutes.
3. Save Changes.
This defines whose changes will override who's. There are two options available:
Which option you choose really depends on the type of workbook you have created.
Another critical issue you need to consider is if somebody disables the Excel Shared Workbook function. If this occurs, when you try to save your workbook you will be required to save it somewhere else or lose your work. This is one of the downsides to the Share Workbook function.
Can't find what you're looking for? Try Google Search!
Back to Top
>> Next Topic : How to Create the Excel Drop Down List Menu?
<< Previous Topic : Copying Excel Worksheet from one Workbook to Another