Log in

View Full Version : Shared document increases drastically when saved


04091985
Aug 11, 2008, 05:42 AM
Hi,

I have an excel document 2003 shared in server . A group of team access those file simultaneously and they have permission to edit and save in the server itself that is they don't have access to copy and save. They have to connect to the server and open the shared file in the server itself edit and save it. While saving them the file size of excel document increases to 200 or 300 mb when u cut the data and paste it to your system it will be merely 2 to 3 mb file. Do anyone have the idea or solution for this cause because systems are getting hanged if the file size is increased.:(

chuckhole
Aug 11, 2008, 06:31 AM
Do you have delete permissions turned off?

ScottGem
Aug 11, 2008, 06:32 AM
Most likely, with simultaneousl access Excel has to manage the changes to the data as well as the data. That's why its growing so large.

04091985
Aug 11, 2008, 07:21 AM
No just after installin 2007 office in one of the PC this problem is happenning

ScottGem
Aug 11, 2008, 07:22 AM
Well 2007 does add overhead.

chuckhole
Aug 11, 2008, 02:58 PM
Install the MS Office Compatibility Pack for Office 2007 on your Office 2003 installations. Then take a copy of this file, paste it to a new Office 2007 document and work on it as a Office 2007 document. As much as I detest the new Ribbons of Office 2007, the file formats are much more efficient than the older formats. However, if you have an Office 2007 machine constantly converting up and then saving down to the old format, it is likely causing this file bloating. Test and see.

Also, make sure that delete permissions are not denied on this file. Cleanup has to be performed before the file is saved. It is kind of like deleting the old and replacing it with the new, not just appending to the old file.