Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing an Excel file among 3-5 users
I've read and read and cannot agree with the simplified comments made by
folks saying that you should just "turn on" Review , Sharework book to allow others to open a file while you have it open so they can update it as well. this occurs for me now as an Excel 2007 user and occured for me in the past when I used Excel 2003. When the second person opens the file for editing, they receive the Warning - it is locked for xxxxx, and asks if you want to Open Read ONly or Be Notified when it is ready. WHICH DO YOU DO if you are needing to update your part of the spreadsheet while the original person still has their files open? Believe me I have tried both and I am missing something. When I chose NOTIFY, the file opens anyway, I make my changes/additions in my cells...... then what do I do if I am done and ready for it to be submitted back to the Master file? ?(My originator still has it open!!) I am clicking on SAVE and it warns me that it can't be saved because it is locked my another user. DUHHH!!! So it suggests a new file name "Copy of Original name.xlsx" so I can save it else where. I DON'T WANT TO SAVE IT ELSEWHERE! I want it to be merged back in with the original when it gets closed. Do i have do keep my Spreadsheet open? And wait till I am notified that it the originator is finished so that now I can move to Read-Write mode? I tried that. I moves to Read-Write mode and Warns me "Hey. your recent changes are about to be lost, if you accept the master file.".. Help. I am missing something aren't i? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing macros with other users | Excel Discussion (Misc queries) | |||
Sharing a worksheet among multi. Users over Network. | New Users to Excel | |||
sharing workbook for multiple users | Excel Worksheet Functions | |||
sharing a workbook and incorporating changes from multiple users | Excel Worksheet Functions | |||
When Sharing settings dont appear the same for all users | Excel Discussion (Misc queries) |