ASK FOR ADVICE ABOUT THE SHARING OF EXCEL IN LAN

Right-click on the folder where the excel file is stored and select it"Property-Shared"(or.)"Sharing and security"), select the second row"Share this folder on the network", OK, as long as you don't check one of them"Allow network users to change my folders"Others can only view it, not modify it.

You can only set up sharing by right-clicking on the folder, or you can move the excel file (the original file displayed as the excel icon) or the folder containing the excel file directly"Share documents"folder.

1. Put your excel in the shared folder, and others can enter your shared folder from the online neighbor and find your excel.

2. Open Excel, click "Tools" in "Allow multiple users at the same time, and allow workbook merging" in "", and then you can also select the time of auto-save in "Advanced" - OK. That's it.

Hope it works for you!

If you're a working group within a LAN, start by creating a folder -- right-click -- Share & Security -- and make sure the folder has a hand-shaped support icon. --Put your (excel) file into the file and OKLE, (this file is a shared file), and other computers in the LAN can see your data.

Right-click on the summary table --- Sharing and Security --- Sharing ---checked) to allow network users to change my files.

All shared files have options, just choose what you need, if not, you can encrypt the excel workbook, you can view it without being modified.

Share: Set to full, don't make it read-only.

That's where the excel server comes in! Find out if there's a free one online!

Tool Share Workbook.

All it takes is one step and you're done!

1. First of all, open the Excel file we need to share.

2. Switch the title menu bar of the excel workbook to the tab of "Review", and click "Share Workbook" in its ribbon.

3. The "Share Workbook" dialog box pops up, check the option "Allow multiple users to merge at the same time, and allow the merger of work and lease sales books at the same time" and click "OK".

4. The "This operation will lead to saving the document" window pops up, click "Yes" to save.

5. At this time, you will find that the word "share" has appeared after the file name, so that the excel sharing is set up.

1.Execute the Share Workbook command in the Tools menu, a dialog box appears, and then click the tab.

2.Select the Allow multiple users at the same time and allow workbook merging check box, and then click the Confirm button.

3.The Save As dialog box appears, and the shared workbook is saved on a network hard drive that is accessible to other users.

4.When you're done, press the "Save" button and you'll see the "Share" logo appear on the file's title bar.

Later, if there are other users on the Internet using the file, execute the Share Workbook command in the Tools menu again, a dialog box appears, and then click the "" tab to see the user using it.

Wouldn't it be more convenient to keep it on a removable disk if you were doing this upstairs? Excel files take up very little space.

You can use 139 mailbox, which has a network USB disk function.

Apply for a free space online and pass the ** up; Or put it in your personal mailbox.

Local excel sharing can't be shared by multiple people, and a large number of people will limit what you have read, which is annoying. Sometimes there is no one at all, and it will be inexplicably locked and annoying.

Solution: Web Excel - Thunderbird**, multi-person real-time unlimited. (The avatar and operation area will also be displayed to prevent confusion).

Step 1: Create a blank excel document on any computer, and then share the new excel document. (I won't introduce too much about how to share).

Step 2: Open the new Excel document and click to review it - share the workbook.

Step 3: Follow the prompts of the system to click the Microsoft Office button in the upper left corner, and then click "Excel Options". In the Excel Options dialog box, click Trust Center, and then click Trust Center Settings.

Then, in the "Personal Information Options" category, remove the checkbox next to the option "Delete personal information from document properties when saving" and click "OK".

The shared file cannot be opened, and the computer-related sharing function needs to be reset.

1.First of all, put the file to be shared into a folder, right-click on the folder - Properties - Commonality, the computer is Windows 7, take this as an example. (Windows XP approaches similarly).

2.Select the "Share" button to open the Shared User Add dialog box, and select the username you want to share. Select the Everyone user, click "Add", and then click the "Share" button.

Return to the previous dialog box and select the Close button.

3.Find the file you want to share in the file that provides sharing, right-click on the property, and open the properties dialog box.

4.Select the "Security" tab, find the username you need to share this file, here I have the Everyone user in my own computer as an example, you can choose according to your actual situation.

5.Select the button to open the permission selection dialog box and select the permission according to your actual situation.

6.Once you've selected the permissions, press the OK button twice in a row.

I agree with the previous statement, but be aware that if two people open the same file at the same time, there is a risk that the data will be overwritten, and it is best to set the permissions to everyone to fully control this document.

excel can't be so realized, if you open it, someone else will definitely save it as, you can save it as a name, such as inventory liu December 17 at ten o'clock Liu do, so it can be temporarily solved.

Let's use financial software when it solves it perfectly.

Excel can do what you said about this problem.

1. In Excel2003, it is "Tools-Shared Workbook", and in Excel2007, it is "Review-Shared Workbook".

2. After clicking on the shared workbook, its options will appear, please select the option "Allow multiple users at the same time, and allow workbook merging at the same time".

3. The document should be in a shared folder on the local area network.

This will allow you to implement the question you asked.

Tools --- share workbooks in the "Allow multiple users to ,...... at the same timePut a checkmark on the front.

The most conservative and simple way is in six steps:

1 Install LAN Protocol:

Right-click on the local connection - properties - find the intneter protocol and select - click install - find nwlink ipx spx --- this protocol - install it.

2 Set up Group Policy:

Start - Run Computer Configuration - Windows Settings - Security Settings - Local Policies - User Rights Assignment - Deny Access to This Computer from the Network - Remove Guest. Start - Run Computer Configuration - Windows Settings - Security Settings - Local Policies - Security Options - Network Access: Security Mode for Local Account - Select Incoming Guest Users.

3 Enable guest:

Start - Settings - Control Panel - User Accounts - Enable Guest Accounts.

4 Set a guest account password

Right-click on My Computer, select Manage - Local Users and Groups - Users - Right-click Guest and select Set Password.

5 Don't use simple file sharing:

Double-click My Computer - Tools - Folder Options - View - and uncheck the box in front of "Use Simple File Sharing (Recommended)".

6 Set up shared files:

Right-click on the file you want to share and set up sharing.

Supplement: It is best to set up a workgroup on all computers in the local area network, and the method is also very simple: right-click on my computer and select Properties-Computer Name-Change-Enter the name, the workgroup workgroup does not need to be changed-OK-Network ID-Next-Next-Select the network without a domain-Next-OK-OK.

This will restart the computer and the problem will be solved.