Large Excel Workbooks Open Slow Or Fail To Open In Office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1548750%22%20slang%3D%22en-US%22%3ELarge%20Excel%20Workbooks%20Open%20Slow%20Or%20Fail%20To%20Open%20In%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20many%20macro%20enabled%20Excel%20workbooks%20that%20I%20have%20developed%20over%20the%20years.%20These%20workbooks%20all%20open%20quickly%20and%20the%20macros%20work%20with%20no%20problems%20in%20Excel%20from%20Office%202010.%20However%20any%20workbook%20with%20a%20file%20size%20greater%20than%201.3%20MB%20is%20a%20problem%20in%20Office%20365.%20A%20file%20greater%20than%203%20MB%20is%20probably%20not%20going%20to%20open%20at%20all%20or%20take%20so%20long%20that%20it%20eventually%20is%20listed%20as%20corrupt.%20The%20results%20are%20the%20same%20on%20three%20very%20different%20computers.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20re-saved%20the%20test%20files%20as%20*.xlsb.%20When%20the%20file%20size%20shrinks%20significantly%20the%20file%20opens%20and%20runs%20as%20expected.%20Still%20as%20the%20xlsb%20file%20size%20gets%20above%201.3%20MB%2C%20the%20opening%20slows%20down%20and%20the%20chance%20the%20file%20will%20show%20as%20corrupt%20increases.%20I%20have%20tested%20this%20repeatedly%20by%20creating%20test%20workbooks%20with%20small%20worksheets%20and%20VBA%20modules.%20I%20gradually%20increase%20the%20workbook%20size%20by%20copying%20the%20known%20good%20sheets.%20I%20save%20after%20each%20iteration%20and%20watch%20the%20file%20size%20for%20any%20sign%20ballooning%20that%20would%20indicate%20corruption.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWith%20this%20and%20other%20tests%2C%20the%20results%20are%20consistent%20across%20all%20my%20test%20platforms.%20There%20is%20a%20problem%20in%20Office%20365%20with%20opening%20and%20running%20large%20macro%20enabled%20workbooks.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHas%20anyone%20else%20experienced%20this%20problem%3F%20Has%20Microsoft%20offered%20any%20help%20or%20a%20solution%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

I have many macro enabled Excel workbooks that I have developed over the years. These workbooks all open quickly and the macros work with no problems in Excel from Office 2010. However any workbook with a file size greater than 1.3 MB is a problem in Office 365. A file greater than 3 MB is probably not going to open at all or take so long that it eventually is listed as corrupt. The results are the same on three very different computers.

 

I have re-saved the test files as *.xlsb. When the file size shrinks significantly the file opens and runs as expected. Still as the xlsb file size gets above 1.3 MB, the opening slows down and the chance the file will show as corrupt increases. I have tested this repeatedly by creating test workbooks with small worksheets and VBA modules. I gradually increase the workbook size by copying the known good sheets. I save after each iteration and watch the file size for any sign ballooning that would indicate corruption.

 

With this and other tests, the results are consistent across all my test platforms. There is a problem in Office 365 with opening and running large macro enabled workbooks.

 

Has anyone else experienced this problem? Has Microsoft offered any help or a solution?

0 Replies