ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can use VSTO to reduce the size of a file? (https://www.excelbanter.com/excel-programming/443150-can-use-vsto-reduce-size-file.html)

LuisE

Can use VSTO to reduce the size of a file?
 
I have a really large spreadsheet that is saved in a sharepoint location but
takes about five minutes to load.

Would it make any difference if I recreate the file using VSTO?

Thanks in advance

Peter T[_5_]

Can use VSTO to reduce the size of a file?
 
Recreating the file might help, particularly if large areas include
unnecessary formatting. However what means you use to do that, manually,
VBA, VSTO etc, wouldn't be directly relevant.

Regards,
Peter T

"LuisE" wrote in message
...
I have a really large spreadsheet that is saved in a sharepoint location
but
takes about five minutes to load.

Would it make any difference if I recreate the file using VSTO?

Thanks in advance




All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com