Spreadsheet Performance
Hi all,
Thought I would ask the question before I spent to much time on what might
not be an issue.
I have a workbook containing four sheets of data (each with around 4000 rows
and 27 columns), this is used as data for around 50 graphs on 5 other sheets.
I have used SUMPRODUCT with named ranges for the calculations, which are done
on a separate sheet. The speed of the recalculation of the workbook is around
30 seconds. Is this considered slow?
If so are pivot tables faster?
Regrads
John
|