I have an excel spreadsheet that we use for budget and activity analysis. The data is drawn from queries on an MS Access database into 12 separate worksheets. Macros are then used to define and calculate the data. The results are then summarised at various levels (high level for the Executive Director to line item by month for the Manager) on another 2 worksheets for use by different managers.
Since upgrading from Excel 2003 to 2010, the performance of the report has diminished. Current file size is 32,100 KB. This morning a message box appeared on open: "Excel cannot complete this task with available resources. Choose less data or close other applications." We have no idea what this means as the file was working well in 2003.
Do we need to compact the Excel workbook as we do for Access? If so how is this achieved?