Excel very slow to save

  snowman 20:34 29 Jul 2006
Locked

Anybody give a clue as to why excel is taking an age to save. It opens the 5 workbooks via a macro in amatter of seconds and takes at least 30 seconds to save each one. one workbook is 600kb and 1 is 6mb but they alltake the same time to save. Something happened not sure what as they used to be fast at saving although slightly longer than the opening time but nowhere near the time taken now

  ArrGee 20:37 29 Jul 2006

Have you loaded up any new apps recently? (And also gone throught the usual route of checking for mal/spyware?)

  VoG II 20:43 29 Jul 2006

Slow saving is a known issue when you have several workbooks open. The following macro will close them all down and may be a tad quicker:

Sub Auto_Close()
Dim File As Object, FileStatus As String
Application.DisplayAlerts = False
ActiveWorkbook.Close Savechanges:=True
For Each File In Workbooks
File.Activate
If ActiveWindow.Visible Then
FileStatus = Dir(ActiveWorkbook.path & "\" & ActiveWorkbook.Name)
If FileStatus = "" Then
ActiveWorkbook.SaveAs CreateBackup:=True
Else
If ActiveWorkbook.Saved = False Then ActiveWorkbook.Save
End If
End If
Next File
Application.DisplayAlerts = True
Application.Quit
End Sub

  snowman 21:17 29 Jul 2006

Vog the macro does save slightly quicker but ideally i would like it to save the workbooks and not shut them down (an incremental save when i feel the need)

Thanks

  VoG II 21:22 29 Jul 2006

Just put a ' in front of Application.Quit

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017