Avatar of PhilBattrick
PhilBattrick
 asked on

Pivot table error in Access/Excel

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...

Thanks, Phil.
Microsoft AccessMicrosoft Excel

Avatar of undefined
Last Comment
Tracy

8/22/2022 - Mon
ukerandi

Then compact  and repair the database, and try again.
ASKER CERTIFIED SOLUTION
ukerandi

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Tracy

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Your help has saved me hundreds of hours of internet surfing.
fblack61