Shared Workbooks in Excel 2003

Source: Internet
Author: User
Tags ranges reference

The company's monthly sales statistics work is the most headache for office staff, usually by the sales department of the sales to the Excel worksheet, and then back to the office, the worksheets are copied to a workbook, and finally centralized processing. Due to the company's request at a monthly meeting to take out the last month's sales statistics, but the sales department in the last day of the month after work to upload this month's sales, in fact, the office only one night time to collect, statistics. Given that the office staff had a hard time making the tables in one night, the company announced that the head of each point-of-sale would go to the head office to assist in the statistics at the end of the month. However, the statistical summary of the form can only be carried out by one person, many people are also standing to see. In fact, we can use the shared workbook features in Excel 2003 to work together.

On the Tools menu, click the Share Workbook command, then select the Edit tab, select the Allow multiple users to edit at the same time workbook merge check box, and on the Advanced tab, you can set the automatic update interval, change conflict resolution between users, and personal view properties. In general, the individual parameters in the Advanced tab can use the system defaults directly, and then click OK. When prompted, save the workbook. On the File menu, click Save As, and then save the shared workbook in a shared folder. Then the individual worksheets are named after each department, such as "one branch", "two stores" and so on.

Cico prompt the filename in the title bar will give you a "shared" word, which means that the shared workbook is successfully set up.

When you do an operation, you require that the worksheet for each branch be edited only by the owner of the store, and that others have only read permission. Click tools → protect → allow users to edit ranges, click the New button in the open window, and go to the New Zone dialog box (figure). Enter the user name in the title box of the new Range form, click the button to the right of the reference cell input box, and press CTRL + A to make the whole table range reference "=1:65536" into the input box. Enter the password in the area Password box, press OK to eject the confirmation window, re-enter the password, go back to the Allow users to edit the Range dialog box, and then click OK. Different worksheets correspond to different users, and repeat these steps to set the edit area and password for the other worksheets.

If you want to specify different users for different parts of the same worksheet, such as some rows or columns, just click the New button in the Allow users to edit Range dialog box, and then select the appropriate area by following the steps above.

Click the tools → protect → protect sheet menu command, open the Protect Sheet dialog box, enter a password in the password to Unprotect sheet box, and then click OK.

If you do not do this, any user can open the Allow users to Edit Ranges dialog box to cancel or change the editing area that you have just set up. If you have more than one worksheet in the workbook that you want to set up the editing area for, we need to set it separately to protect each worksheet. In addition, this step must be done before you set up workbook sharing.

Each branch when submitting data, cancel the protection of the worksheet (select the tools → protection → unprotect sheet menu command), enter a password to edit in the worksheet that has permission, and view content only for other unlicensed areas.

At this point, each department can enter the data by entering the shared folder, opening the Excel file named shared, and entering the worksheet named after the department. Each worksheet is completely transparent, and one department can view the latest rectification progress in other departments. You can check who is currently editing the shared workbook and use Automatic Updates to keep change monitoring. For a shared workbook that is in use, if the Shared Workbook dialog box appears (the Share Workbook command on the Tools menu), the Edit tab lists all the users who currently have the workbook open. Use the update area of the Advanced tab to get regular updates (you can choose the frequency of updates, if you want).

Cico prompts to see only changes that have been saved by the user, and Excel does not display changes that have not been saved by the user. After the workbook is shared, some settings in Excel cannot be changed.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.