How to use Excel chat in LAN

What can you do on your local area network? Do you have to play games? You out, in the LAN as long as there is Excel can chat Oh! You don't know!

Now most units have set up a local area network, although there are many can chat on the LAN tools, but one use inconvenient, and secondly unsafe (easy to be found by the boss). To this end, black and white network of small series suggest that you use Excel to chat.

So exactly how to use the LAN skillfully chat with Excel?

★ First Step: Open Excel2003, create a new workbook document, name Save (such as "work record. xls").

★ Step Two: Execute tools → shared workbook, open the Shared Workbook dialog box (see Figure 1), select the Allow multiple users to edit simultaneously, and Allow workbook merge option to confirm the return.

★ Step Three: Save the workbook document in a shared folder on a computer on the local area network.

★ Fourth Step: The local Area network users open the above workbook at the same time, we agreed that the input of the cell location (such as a user in a column input, b column input time; b users in C column input content, D column input time ...).

★ Step Fifth: Select the appropriate cell (such as A1), enter the chat content into it, and then select B1 cell, press Ctrl Shift; Enter the system current time by combining keys.

★ Sixth Step: Click on the Toolbar "Save" button, the above input to save, the other side just click the "Save" button, you can see the above input content.

★ Seventh Step: If the boss comes, just switch to other worksheets (such as Sheet2) (you can enter some work-related content in advance), you can switch to "working status." It's both convenient and safe!

Small Tips

Improve efficiency, multiple people at the same time input an Excel file this application mainly uses the Excel "allows many users simultaneously to edit, simultaneously allows the workbook to merge" The function, in the actual work, may use for many people to enter an Excel form together, the Excel will automatically maintain the information unceasingly to update. For example: There are a, B, C, D four users to work together to complete the 2005.xls file entry, first open the file, and click on the operation of the above check "allow multiple users to edit simultaneously, while allowing workbook merge", and finally click "file → Save as", save it in E computer D disk. The next four users will be able to enter the file at the same time.