Hey all,

I got a worksheet where i do some financial backtests using daily data
for the last 10 years for 10 different countries with about 20 diff.
variables.

I got 10 Data Sheets: One sheet for every country-data containing 20
colums + 3000 rows
1 Sheet containing all the formulas to basically calculate my backtest
(array- formulae etc..., vba-functions, etc).
5 other sheets containing charts etc.

Thats way i got a filesize of close to 90MB

Could you think of any method to improve file size and speed (saving
takes up to 2min).
Should i outsource the country data in a sperate worksheets; spliting
them from the actual calculations? Should I read it in a vba array.
Anything else?

Your help is very much appreciated.

Chris