Excel won't perform refresh on pivot table



I have been sent a 2-sheet pivot table, 179kb in size. When I right-click on
the table and select refresh it says:

"Excel cannot complete this task with available resources. Choose less data
or close other applications. Continue without undo?

When I continue it just produces another error that basically says the same
thing and then gives up.

I've tried this on many Windows 2000 machines, with Office 2002 and also
Office 2003 - all with the same result. They all have 256-512MB RAM, 2Ghz+
CPUs and all the latest updates and SP's.

Any help is greatly appriciated. I can also send the document if anyone
wants it. Thanks.



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question