If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sharing Workbooks
I have a pretty elaborate workbook set up that is keeping
track of my inventory, sales, production, etc.... My problem is that I share this workbook w/ 2 of my co- workers. If one person is modifying the workbook, myself and the other person can't be. We are only allowed to "Read Only." I was going to divide out the different sheets into workbooks that have the information that each person uses, but b/c the sheets are linked together, I still have the issue of sharing information and updating. Does anyone have any suggestions on how we can edit the same workbook, or have different workbooks that automatically update once a change in made in one of the linked workbooks? Or should I just give up??? Thank you. Tim |
#2
|
|||
|
|||
Sharing Workbooks
I could be way off here, but I would do a little tinkering with workbook
protection. Bear with me for a minute. Click tools, protection, then click "protect and share workbook". I think it will allow several users to have a sheet open at the same time, but will give the owner/creator of the file the right to accept or not accept the changes made by another user. It just might also get you past your read only problem. I would suggest trying it with a useless workbook first before using it on your good one. Like I said, I can't be sure if it will work but it is worth a try if you haven't tried it already. "Tim Hagedorn" wrote in message ... I have a pretty elaborate workbook set up that is keeping track of my inventory, sales, production, etc.... My problem is that I share this workbook w/ 2 of my co- workers. If one person is modifying the workbook, myself and the other person can't be. We are only allowed to "Read Only." I was going to divide out the different sheets into workbooks that have the information that each person uses, but b/c the sheets are linked together, I still have the issue of sharing information and updating. Does anyone have any suggestions on how we can edit the same workbook, or have different workbooks that automatically update once a change in made in one of the linked workbooks? Or should I just give up??? Thank you. Tim |
#3
|
|||
|
|||
Sharing Workbooks
You can do this by selecting TOOLS, SHARE WORKBOOK, and
tick box where it asks if it can be edited by more than one user. -----Original Message----- I have a pretty elaborate workbook set up that is keeping track of my inventory, sales, production, etc.... My problem is that I share this workbook w/ 2 of my co- workers. If one person is modifying the workbook, myself and the other person can't be. We are only allowed to "Read Only." I was going to divide out the different sheets into workbooks that have the information that each person uses, but b/c the sheets are linked together, I still have the issue of sharing information and updating. Does anyone have any suggestions on how we can edit the same workbook, or have different workbooks that automatically update once a change in made in one of the linked workbooks? Or should I just give up??? Thank you. Tim . |
Thread Tools | |
Display Modes | |
|
|