Problem with some content error when outputting to Excel Range

[lrhodig]

I've seen a number of posts asking about the "We found a problem with some content in "xxx.xlsx". Do you want us to try to recover as much as we can?", but haven't found a solution yet.

For my particular use case, I am outputting to a number of excel ranges and preserving the formatting. These particular ranges are formatted as tables, used as data sources for the Excel Data Model, then Pivot Tables are being built off that data model. It seems random that sometimes this works with no issues, and other times I get this error message:

 

In the past, I had ran into the issue where a particular string value starts with the "=" character. I put in a multi-field tool with the logic Replace([_CurrentField_],"=","") and applied that to all text fields, but I'm still seeing the same issue.

[Raj_007]

Hi, did anyone notice this - i got this same message - still going through but could not find much info