Why Table to Excel tool does not work properly in ArcGIS Pro?

[Amadeus111]

I have been using a Python/ArcPy code use to generate many Excel files (.xlsx) from shapefiles. After the last Pro update end users start complaining that they get message when they try to open those Excel files. 

First, I thought it was something wrong from my end, code, server etc. but when I do the process manually. I got the same error. 

When I  try to open ESRI generated Excel file I get the message below

Then I click Yes and get this message

It seems nothing get lost but it is frustrating popping multiple windows and make users think they did something wrong or something wrong with the file itself.

Is there way to fix our own or we need ESRI to fix that?

Thanks!

[DanPatterson · Accepted solution]

BUG-000132901

In ArcGIS Pro 2.6, Table to Excel with an output format of .xlsx results in a corrupt Excel table.

Fixed apparently in the 2.6.1 patch, available now

Release notes for ArcGIS Pro 2.6—ArcGIS Pro | Documentation 

[Amadeus111]

I was able to update to 2.6.1 this morning and it solved my problem.