Fixing Excel Crashes on Pivot Table Refreshes



These things worked for me, in a limited test.

a) delete the sheet from the workbook that contains the pivot table and
replace it with a known good sheet from another workbook.

b) ensure that there are no blank rows or rows with NULL values in the
data going into the Pivot table.

c) Tell clients that they should use analysis services for this sort of
thing, not Excel!


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