File Size Possible Issue (Downsizing ideas?)

[dwilliamson1024]

I have an Excel file (I don't consider it to be too big (88,000 KB) that also references one other data dump file so sometimes caches an extra 42,000 KB.

When end-users are using the file and actually in the file, everything runs very quickly; however, I am starting to get complaints on how long it takes to actually open the file up. Anyone run into this?

Any ideas?

Would it help if I separated out the raw data and only displayed the charts and metrics? Then it would only really reference the data if someone adjusts a pivot or something. Would this speed up the opening process, or will it only slow down the file to maneuver around in it after the fact? Thoughts?

 

[deletedalien]

What he said ^^^^^

 

[dwilliamson1024]

Got the file from 87 MB to 26.8 MB

Had a lot of code to change for the update macros to open an external file and flip between the two, etc., but all is done in just an afternoon.

And gave me an excuse to play with more code and not do other work stuff.

Thanks.