Increasing Speed of saving workbooks in Excel??

[AnnabelleMarie]

I have an Excel macro that slows down tremendously when I save the changes to a workbook:

Workbooks(fileName).Close saveChanges:=True

If I do not save the changes (saveChanges:=False), the macro runs pretty fast. But of course, I need to save the changes. I'm opening about 100 workbooks, updating a range, and then saving the workbook.

Is there some kind of extra processing that Excel does that I can disable so that it saves faster?

Thanks for any help!

 

[PHV]

I'm opening about 100 workbooks, updating a range, and then saving the workbook
You have about 100 opened workbooks when you save this workbook ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AnnabelleMarie]

No, I'm in a loop, opening a workbook, updating the range, closing the workbook (and saving). So, there is only at most 2 workbooks open at one time: the main workbook and the one I'm working on. Have any ideas on what I can do? Thanks.