123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Education >> View Article

Microsoft Excel Shortcuts: How To Setup A Shared Workbook

Profile Picture
By Author: Chris Le Roy
Total Articles: 95
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Microsoft Excel 2003 has become the spreadsheet of choice for over 80% of corporate businesses around the world. One of the clear advantages of using Microsoft Excel 2003 over other spreadsheeting programs is the ability to have multiple people entering information into the same spreadsheet. This function in Microsoft Excel is called Shared Workbooks and we will go through how to setup this capability in this article.

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. First open the file that you want to share, then once the workbook is open, go to the Tools menu and choose Share Workbook from the drop down menu.

The Share Workbook dialog box will now appear. To enable sharing, you simply click once on the Allow Sharing check box, so that it has a tick. Once you do this other people will now be able to use your Excel workbook whilst you are working on it.

However, there are some other parameters ...
... that can be set at the same time. For other options, simply choose the Advanced tab. There are three core parameters that you need to be aware of. The first is the length of time you will store the history in your file.

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 and that is the default, however the value entered simply depends on your workbooks requirements. You can choose the second option which says, Don't Keep Change History. This simply ensures no changes are maintained.

A second option that is available is the Update Changes option. 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.

The last area of concern is the Save Changes function. This defines whose changes will override who's. There are two options available which say, Ask me Which Changes Win and The Changes Being Saved Win. Which option you choose really depends on the type of workbook you have created.

The final issue you need to consider is if somebody disables the Share 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.

Total Views: 205Word Count: 520See All articles From Author

Add Comment

Education Articles

1. Best Servicenow Training In Ameerpet | Hyderabad
Author: krishna

2. Mern Stack Online Training | Best Mern Stack Course
Author: Hari

3. Salesforce Crm Online Training | Salesforce Crm Training
Author: himaram

4. Oracle Fusion Financials Online Training At Rainbow Training Institute
Author: Rainbow Training Institute

5. Microsoft Fabric Certification Course | Microsoft Azure Fabric
Author: visualpath

6. Microsoft Dynamics Ax Training Online | Microsoft Ax Training
Author: Pravin

7. Aws Data Engineering Training Institute In Hyderabad
Author: SIVA

8. Top Skills Employers Seek In International Business Management Professionals
Author: jann

9. Unlock The Power Of Integration With Oracle Integration Cloud Training At Rainbow Training Institute
Author: Rainbow Training Institute

10. Emerging Trends In Salesforce Devops For 2025 And Beyond:
Author: Eshwar

11. How Digital Evidence Is Secured And Managed By Iso 27037 Consultants?
Author: Danis

12. Patient Reported Outcomes Clinical Research – A New Era 2024
Author: Aakash jha

13. Transform Your Home: 7 Must-have Dyslexia Support Resources Every Parent Should Get!
Author: Bradly Franklin

14. The Key To Your Pet’s Health And Happiness
Author: Sumit

15. How To Streamline Administrative Processes In Schools: A Comprehensive Guide
Author: Revamp

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: