> I have an Excel system with about 10 sheets and loads of VBA modules
> and classes.

> It resides on a network at my company's headquarters.

> When I copy the file from my desktop to the server using Windows
> Explorer drag and drop it takes about 6 seconds.

> However if I open the Excel file from the server from my PC and save
> it using Excel the save time is 90 seconds.

> Is this normal? My users are complaining about the time it takes to
> save after editing. It also means that they are not saving often and
> are risking losing changes. Any thoughts?

> If the length of my save is normal then what should I do to reduce
> the
> size of my file for a quicker save? How much does VBA code add to the
> file size or should I be looking at the size of each worksheet?

> Cheers
> Chrisso

> With Application
> Calculation = xlManual
> MaxChange = 0.001
> CalculateBeforeSave = False
> End With

> When you simply drag and drop Excel does not need to make any
> calculations, however when the workbook is opened/closed calculations
> may take place, try setting calculation to manual in the beforesave
> event or beforeclose event, like this:

> With Application
> Calculation = xlManual
> MaxChange = 0.001
> CalculateBeforeSave = False
> End With don't forget to turn it back on in the open event!

> Chrisso;628211 Wrote:
>> Hi All

>> I have an Excel system with about 10 sheets and loads of VBA modules
>> and classes.

>> It resides on a network at my company's headquarters.

>> When I copy the file from my desktop to the server using Windows
>> Explorer drag and drop it takes about 6 seconds.

>> However if I open the Excel file from the server from my PC and save
>> it using Excel the save time is 90 seconds.

>> Is this normal? My users are complaining about the time it takes to
>> save after editing. It also means that they are not saving often and
>> are risking losing changes. Any thoughts?

>> If the length of my save is normal then what should I do to reduce
>> the
>> size of my file for a quicker save? How much does VBA code add to the
>> file size or should I be looking at the size of each worksheet?

>> Cheers
>> Chrisso

> --
> Simon Lloyd

> Regards,
> Simon Lloyd
> 'Microsoft Office Help' (http://www.thecodecage.com)
> ------------------------------------------------------------------------
> Simon Lloyd's Profile: 1
> View this thread:
> http://www.thecodecage.com/forumz/showthread.php?t=174829

> [url="http://www.thecodecage.com"]Microsoft Office Help[/url]

> With Application
> .Calculation = xlManual
> .MaxChange = 0.001
> .CalculateBeforeSave = False
> End With don't forget to turn it back on in the open event!

> Chrisso;628211 Wrote:

> > Hi All

> > I have an Excel system with about 10 sheets and loads of VBA modules
> > and classes.

> > It resides on a network at my company's headquarters.

> > When I copy the file from my desktop to the server using Windows
> > Explorer drag and drop it takes about 6 seconds.

> > However if I open the Excel file from the server from my PC and save
> > it using Excel the save time is 90 seconds.

> > Is this normal? My users are complaining about the time it takes to
> > save after editing. It also means that they are not saving often and
> > are risking losing changes. Any thoughts?

> > If the length of my save is normal then what should I do to reduce
> > the
> > size of my file for a quicker save? How much does VBA code add to the
> > file size or should I be looking at the size of each worksheet?

> > Cheers
> > Chrisso

> --
> Simon Lloyd

> Regards,
> Simon Lloyd
> 'Microsoft Office Help' (http://www.thecodecage.com)
> ------------------------------------------------------------------------
> Simon Lloyd's Profile: 1
> View this thread:http://www.thecodecage.com/forumz/showthread.php?t=174829

> [url="http://www.thecodecage.com"]Microsoft Office Help[/url]- Hide quoted text -

> - Show quoted text -