Export Data - Summarized Data not exporting in excel

[RMR]

Is anyone else having issues exporting data as "Summarized Data" and getting an error in Excel when opening? It used to open as a table and now it does not and I get the following message below. It started last week.

[v-xiaoyan-msft]

Hi @RMR ,

This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform. Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

Best regards.
Community Support Team_ Caitlyn

[RMR]

Thank you for the response. It seems all that is needed is to click on the dropdown and select (Excel 150,000-row max). The defualt is set to the live connection capable of exporting up to 500,000 rows. I wish that wasn't the defualt but, I will get used to using the dropdown! 

Thank you again!

[v-xiaoyan-msft]

Glad that you have solved it . Now this thread will be closed.