Hi,
I have an excel template in my .NET project which i am downloading through my code. I have written certain macros inside the excel file and there are in all 8-9 worksheets in the excel file, in which only the first worksheet is kept visible and all other worksheets are kept hidden. On downloading the template, i am populating some master data from my database in these hidden worksheets. The problem i am facing is that the size of the downloaded template becomes aroung 6.65 MB. I have tried reducing my macro code/unnecessary variables and also by removing unnecessary worksheets, but the size of the downloaded file remains almost same. I want to reduce the size of the downloaded template. I am attaching the downloaded template from my project, with this post. Please have a look.
Thanx