Hi All,
I have been working on a workbook which contains around 150 worksheets to store monthly project reports. These are compiled using a number of UserForms and Dashboard entries.
After making some additions (about 12 sheets) and some vba code changes I saved the file / wb and the file went from around 1.5 MB to around 65 MB. Can anyone tell me why this might be and if it is possible to reduce this file size how to do it???
The file is accessed over a network connected through a VPN so is very clunky when opening and saving.
Any help is very much appreciated.
Rgds
P
I have been working on a workbook which contains around 150 worksheets to store monthly project reports. These are compiled using a number of UserForms and Dashboard entries.
After making some additions (about 12 sheets) and some vba code changes I saved the file / wb and the file went from around 1.5 MB to around 65 MB. Can anyone tell me why this might be and if it is possible to reduce this file size how to do it???
The file is accessed over a network connected through a VPN so is very clunky when opening and saving.
Any help is very much appreciated.
Rgds
P