Hi All, I have a customer who is trying to edit forms from an Access database.
The process tries to open a pivot tabel in Excel, generating the following error message :-
There isn't enough memory to complete the Automation object operation on the Worksheet object
I don't believe that this is a memory error as the customer has 4Gb in the machine, and there are over 640Mb free. O/S is Windows 7, and the version of Office is 2010, but it was upgraded from 2007 a month or 2 back. Problem only seems to have appeared since the upgrade (though my customer can't be absolutely sertain that's the case...)
Any help gratefully received...