Can't you do your calculations in wherever it is you pull your data from? and just summarise in Excel? Or have a look at power pivot? Have a look at xlsb as well, the file format substantially reduces the file size