"PivotTable was changed during Refresh Data operation"

[Dave]

Hello,

Every time I open a certain workbook, I get a series of dialogs saying
"PivotTable was changed during Refresh Data operation" and requiring
that I click "OK" to continue. Moreover, our *clients* get the same
dialog, and we don't want to waste our clients' time.

Is there any way to prevent this dialog from appearing?

The workbook template was created in Excel and data is inserted into it
using a third-party Java library. The dialogs appear when the resulting
modified workbook is opened on Mac or Windows.

Also, on Macs, a series of half a dozen or so "Converting Metafile"
dialogs also appear, although they clear themselves, so I am not as
concerned about them.

Dave

 

[Jim Gordon MVP]

Hi Dave,

I don't think it's possible to suppress the pivot table dialog box. It's
there to alert users that the pivot table may have new data since the
last time they saw the table.

The "converting metafile" dialogs occur when content that is windows
only goes through a converter so that it can be displayed on a Mac.

-Jim Gordon
Mac MVP