none
Is there a fast way to save a workbook? RRS feed

  • Question

  • I have an xls workbook which includes about 200 modules and several classes and sheets. After updating a few lines in a module,  I saved the workbook, it took about 5 minutes. I was wondering if there was any settings that I could use to save a workbook faster.

    NR1234

    Thursday, June 7, 2012 3:43 PM

All replies

  • Hi Nr1234,

    Are you saving to a local drive?


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Thursday, June 7, 2012 4:34 PM
  • yes...

    NR1234

    Thursday, June 7, 2012 5:17 PM
  • Check if there is reference to other file in formula.
    Friday, June 8, 2012 5:40 AM
    Answerer
  • It does contain cells pointing to other sheets in the same workbook, also I believe it has formulas added by an Add-in XLA, which located in local drive as well.

    NR1234


    • Edited by NR1234 Friday, June 8, 2012 2:43 PM
    Friday, June 8, 2012 2:42 PM
  • First determine if the time is due to the code or stuff in sheets. Save a copy as an xlsx, remove all but one empty sheet and save a copy (ie the code) as an xlsm. Also try saving as an xlsb (w/out the worksheets).

    200 modules is a lot but not exceptional and though of course it depends on the volume of code I wouldn't normally expect 5 minutes to save. However for a non addin that is a lot, consider separating all the code into an addin and, depending on the scenario, separating say logic, formulas & data entry and data as tables into two workbooks.

    Peter Thornton

    Sunday, June 10, 2012 3:20 PM
    Moderator