Log In
Register
Home
May 2, 2014
Offline
I've noticed recently - and another user has noticed the same thing - that the file size seems to be much smaller ? Has there been an upgrade that has helped that?
July 16, 2010
Offline
Hi Anne,
What version of Excel do you have?
There have been performance improvements to Excel, but I'm not aware of anything that will make the file size smaller.
Mynda
Trusted Members
Moderators
November 1, 2018
Offline
Switching from the old BIFF8 (.xls/.xlt/.xla) format to any of the newer compressed formats (.xlsx/.xlsm/xlsb/.xlst/.xlam) would reduce the file size, but that change came out a long time ago now, so I'd have expected it to be noticed before now. 😉 You might also notice some further reduction if you switched to .xlsb from another format.
May 2, 2014
Offline
@Mynda I have Office 365 - version 1808 but another Excel colleague has 1901 and he really noticed the improvements. @Velouria - I thought of that as well but nope, these were .xlsm files. I had noticed it with another file - that had a fair bit of PQ stuff in it and it used to be humongous and then it went down to less than 1 MB. Will check out that link...strange..good though! I thought there might be something I had missed...ah, the mysteries of Excel :-0
July 16, 2010
Offline
Mmm, I just did a test and the file size reduced by about 16%. I've emailed Microsoft and I'll let you know what they say.
Trusted Members
Moderators
November 1, 2018
Offline
If they’re files using PQ or data models, perhaps they’ve made improvements to the Vertipaq storage methods. Be interesting to see what Mynda hears from MS, assuming not subject to NDA of course.
1 Guest(s)
