excel networking

Hello everyone.

If there is a more appropriate forum for what i am looking for please feel free to

point me in that direction.

Having used dBase 4 ver 2 for many years for my small company customer and jobcard

recording i need to get a bit more up to date and am trying to use Excel as a substitute.

I have 5 computers interconnected with a windows network. currently windows 7

I am trying to network excel over these computers.

Now the questions.

Is it possible to use excel multi-user over a network and are there any special setup

procedures that need to be applied

July 4th, 2015 1:06pm

Hi ntambomvu,

Based on your description, did you mean you wanted to let multiple users to use the same Excel file via network and recorded the data?

As the owner of the workbook, you can prepare it to be shared by entering and formatting the data that needs to be present. When you are finished, click Share Workbook in the Changes group on the Review tab, select your options, and then save the workbook on a network share (not a Web server) that is available to the intended users.  Alternatively, you can click Protect and Share Workbook in the Changes group on the Review tab to prevent other users from turning off Change Tracking in the workbook.

Each time that you save the shared workbook, you are prompted with the changes that other users have saved since the last time that you saved the shared workbook. If you want to keep the shared workbook open to monitor progress, Excel can update you with the changes automatically, at timed intervals that you specify, with or without saving the workbook yourself.

When you save changes to a shared workbook, another person who is editing the workbook might have saved changes to the same cells. In this case, the changes conflict, and you are prompted with a conflict resolution dialog box so that you can choose which changes to keep.

Please refer to these links about sharing workbook:
https://support.office.com/en-us/article/Overview-of-sharing-and-collaborating-on-Excel-data-3c4fb64f-bf46-42a4-9f6a-73cc6367d378?CTT=1&CorrelationId=1381898b-0f7a-4392-b259-5490e0618518&ui=en-US&rs=en-US&ad=US#_Toc261279697

https://support.office.com/en-us/article/Use-a-shared-workbook-to-collaborate-49b833c0-873b-48d8-8bf2-c1c59a628534?CTT=5&origin=HA010342753&CorrelationId=37fb24a1-fdd5-4d5f-8a81-b916eb1a5e3e&ui=en-US&rs=en-US&ad=US#BMeditworkbook

If my understanding is incorrect, please be a bit more precise to explain your requirement so that I can provide more accurate solutions to this problem.

Im glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
July 6th, 2015 2:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics