Error refreshing exploration saved in earlier version of Microsoft Excel
This workbook may have been created with an older version of Microsoft Excel that has a set maximum number of rows or columns. Rows or
columns that go beyond the maximum limits are truncated.
Although you are no longer using that version, the application is working within the limits of the older version of Excel. You might encounter this situation when you are expanding items or when you are refreshing items that have grown in size since the workbook was created.
To correct the problem, you must save the workbook with the .xlsx extension. Opening the workbook that contains the exploration in a more recent version of Excel does not convert it to the new format. Saving the workbook with the .xlsx extension converts the workbook to the new format.