If you need to open the file to develop, you can reduce its data using the File menu, Reduce Data, Keep possible values. Apart from this, it's quite difficult to say, not knowing more on the data model and charts. First of all, th amount of information counts. So if you are loading several dozens of millions of records, that size is not unsual. The number of sheets and charts also counts. Even the way you have created the script counts (joins use more space than applymaps, for example). You have to take care as well about the number of tables in your data model, and the links between them... If you have embbeded objects such as images (photos, logos, backgrounds) that uses a lot of space if the source files are not optimized.
Keep two different files, one for development and the other for production.
As you said, i'm in the case where the file stores about 3.000.000 records and we have developped about 7 different tabs full of charts and pivot tables.
Maybe I should see if the few images I have introduced, like the logo and the banner can be optimized, even if I guess I won't get much space.
Thenks for the suggestion to work with different files, something I'm already doing.
.png "Miguel_Angel_Baeyens"){kind=avatar}
