Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

Error message

Posted by Lukas Weder on January 08, 2002 1:12 PM

I created a pivot table with an external datasource (MS Access table). When I change the sourcedata (just some numbers) and refresh the pivot table, I get the following error message from excel:

"Pivot Table was changed during refresh operation."

I have just to click "OK" and the Pivot Table is all right... But I really don't like errormessages ;-)

Do you know this message too? Do you have any idea why I get this message?

thanx

Lukas Weder

Re: Error message

Posted by Scott on January 08, 2002 1:55 PM

I believe if there is change in any of the Page information, you will get this message. For instance, if you set it up with "invoice" as a page, and when you refreshed there were more or less invoice numbers than before, you would get this message.

I never tried to shut it off, but I'm sure there's a way.

Re: Error message

Posted by Lukas Weder on January 08, 2002 2:29 PM

Thank you Scott. If I figure it out I'll let you know...

Re: Error message

Posted by faster on January 08, 2002 2:36 PM

This is more of an information only message. Just to
let you know the data has changed. In case you have
printed charts or something based on the data; you need
to reprint them.

Re: Error message

Posted by Chris D on January 09, 2002 11:56 AM

if it actually needs to overwrite any formula or data you have next to or under the pivot, you'll get a different message about "replacing contents of cells"........ but your message is just to say the pivot has changed

watch out for any extra columns or rows though, it can sometimes bugger up anything you have linked to the existing pivot (not a great idea, but sometimes necessary in haste !)

hth
Chris

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.