| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save data in shared spreadsheet?
I have a shared excel spreadsheet (users of both Office03 and Office07) and
two users are in the spreadsheet at the same time. Unfortunatley, we are losing data because it is only saving the 'first' save and not the second. In otherwords, if I save it and then user2 saves it, the rows that are overlapping were saved first by first user are the ones that will be saved....not good. Is there a work around other than copy and paste??? I hope I have epxlained myself right.... Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I save data in shared spreadsheet?
Read this:
http://excel.tips.net/Pages/T002998_..._Workbook.html Maybe that will give you some ideas. Basically, shared workbooks have very limited functionality, as you have discovered. MS Access performs great in multi-user environments such as yours. Excel does not work good with multiple people pounding away at the same file at the same time. Good luck, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Teresa" wrote: I have a shared excel spreadsheet (users of both Office03 and Office07) and two users are in the spreadsheet at the same time. Unfortunatley, we are losing data because it is only saving the 'first' save and not the second. In otherwords, if I save it and then user2 saves it, the rows that are overlapping were saved first by first user are the ones that will be saved....not good. Is there a work around other than copy and paste??? I hope I have epxlained myself right.... Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I save data in shared spreadsheet?
Thank you Ryan..... I guess I will come up with another solution. Great
article by the way. "ryguy7272" wrote: Read this: http://excel.tips.net/Pages/T002998_..._Workbook.html Maybe that will give you some ideas. Basically, shared workbooks have very limited functionality, as you have discovered. MS Access performs great in multi-user environments such as yours. Excel does not work good with multiple people pounding away at the same file at the same time. Good luck, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Teresa" wrote: I have a shared excel spreadsheet (users of both Office03 and Office07) and two users are in the spreadsheet at the same time. Unfortunatley, we are losing data because it is only saving the 'first' save and not the second. In otherwords, if I save it and then user2 saves it, the rows that are overlapping were saved first by first user are the ones that will be saved....not good. Is there a work around other than copy and paste??? I hope I have epxlained myself right.... Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook Won't Save | Excel Discussion (Misc queries) | |||
| link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
| shared spreadsheet on a shared drive | Excel Discussion (Misc queries) | |||
| Cannot save shared workbook | Excel Worksheet Functions | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
Linear Mode
