Got a workbook dragging in data from a database on to one worksheet.
Got another worksheet (in the same workbook) doing a pivot table on the data
dragged in on another worksheet.
There are many pivot tables on this data.
Workbook is so big now that I can refresh the pivot table (which has alot of
necessary rows and columns) but the workbook will not save. A memory error
occurs and I am forced to lose all work up until the previous save.

Can you offer any advise?

Thanks,

--
----------------------------
Regards,
Richard Sterling
Senior Software Engineer Tel : +44 (0)1707 392200 ext 4815
Avaya ECS Ltd, United Kingdom