Start a new topic

Fix Excel pivot reports that make Excel crash

Some users have reported that when the generate a Pivot report from Infoplus, that when they open it in Excel, it causes Excel to crash.

Opening the same xlsx file in Google Sheets, the pivot table was there, but with no rows (only a column - which you could imagine would be the thing that would crash Excel.

2 people like this idea
1 Comment

I had this issue when specifically using the Order Line Report to generate a Pivot Table.

My fix was to remove the address and Possibly the Date columns from the Smart Filter entirely (didn't seem to matter if they were not in the reported columns of the report edit screen).

Login or Signup to post a comment