If removing the formulae gets your workbook to a manageable size you might
consider an intermediate step of keeping your data in Excel and just using
pivot Tables for your reports instead of sumifs and lookups.
This assumes that your data will not grow too large (how many years do you
want to hold?).
Put your data in Access (all the data in one table with years as one of
hte
fields - or whatever would put the data on separate sheets included as
part
of each record identity.
Link to the data base from Excel using a pivot table (data=Pivot Table
Report).
regds
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm