Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save takes long time
We use an excelfile on a server with several people at the same time.
Each one of us has to update and save the file frequently. The file stays opened with each one of us. After saving the file we often have to wait up to 10 minutes after the saving is done and we can go on with our work. What can be the cause of these long waiting periods? It's a timecritical process and waiting for 10 minutes is really not an option. Is there anything we can do about it? Thanks in advance for your answer. Jan. Ps. The machines are up to date and the network bandwidth should be more than enough. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save takes long time
what is the documents file size? how many users? do these users have multiple entries in the Share Workbook "Who has this workbook open" view (If so remove) How many days to keep change history? (tab Advanced) have you tried exporting each seperate sheet to a new workbook? etc. etc. -- tdols ------------------------------------------------------------------------ tdols's Profile: http://www.excelforum.com/member.php...o&userid=31565 View this thread: http://www.excelforum.com/showthread...hreadid=512637 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save takes long time
Thank you for your reply. I am sorry that i was a bit unclear on this.
We are about 6 users. Its 1 workbook, 1 sheet in which we al update (cut and paste and change celcontents) The workbook is open with all 6 of us at the same time during the day for several hours. We all get feedback from other coworkers seperately and have to change the sheet content and save it. It can happen that a collegue of mine and i change the content at the same time and maybe save it at the same time but that should be a coincidence. Jan "tdols" wrote: what is the documents file size? how many users? do these users have multiple entries in the Share Workbook "Who has this workbook open" view (If so remove) How many days to keep change history? (tab Advanced) have you tried exporting each seperate sheet to a new workbook? etc. etc. -- tdols ------------------------------------------------------------------------ tdols's Profile: http://www.excelforum.com/member.php...o&userid=31565 View this thread: http://www.excelforum.com/showthread...hreadid=512637 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Save as Current Date / Time | Excel Discussion (Misc queries) | |||
Excel takes along time to calculate | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Excel Workbook opens after a very very long time | Excel Worksheet Functions |