TheInformationLab
Excel Export All Error from Tableau. Error " We found a problem with some content in ExportAll. Do you want us to try to recover...."
I am experiencing the following error when opening my excel file exported from the Export All on my Tableau Dashboard.
My colleague found the solution to the problem. Our worksheet names contained special characters( : ) Colon. This a restriction in naming an excel worksheet. So when you try to Export All to excel make sure you name the Tableau Worksheets correctly. See the restrictions below from the Microsoft website.
Important: Worksheet names cannot: Be blank . Contain more than 31 characters. Contain any of the following characters: / \ ? * : [ ] For example, 02/17/2016 would not be a valid worksheet name, but 02-17-2016 would work fine. Begin or end with an apostrophe ('), but they can be used in between text or numbers in a name. Be named "History". This is a reserved word Excel uses internally.