Home |
Search |
Today's Posts |
#1
|
|||
|
|||
shared excel file
Hi,
I know that it is possible but i don't know process to do it. I have several users (5) who should have access to the same XLS file (under Excel 2002). They would like to open it at the same time, and to have the possibility to save the modifications. However, if user A and B opened the XLS file, if B modify the file without saving (still open) and A update it and save it. B should be able to be inform of new version and save his update. at the end, XLS has both updates. how can i do this ? thanks a lot, Maileen |
#2
|
|||
|
|||
There's an option that allows you to share a workbook.
Tools|Shareworkbook There's an advanced tab under that dialog with lots of options. But be aware that there are lots of things you can't do in a shared workbook. But this is documented in Excel's help. Look for: Features that are unavailable in shared workbooks for a big list. You may want to consider using another application (Access? or another database) that is made for simultaneous editing. Maileen wrote: Hi, I know that it is possible but i don't know process to do it. I have several users (5) who should have access to the same XLS file (under Excel 2002). They would like to open it at the same time, and to have the possibility to save the modifications. However, if user A and B opened the XLS file, if B modify the file without saving (still open) and A update it and save it. B should be able to be inform of new version and save his update. at the end, XLS has both updates. how can i do this ? thanks a lot, Maileen -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Double-clicking .xls file opens Excel but doesn't open the file | Excel Discussion (Misc queries) | |||
Empty Excel File -- Data Lost? | Excel Worksheet Functions | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |