I am trying to create separate worksheets using individual Excel writers. I have 40 total. The workbench runs fine, but when I go to open the Excel file I get an Excel error stating "We found a problem with some content. Do you want to recover as much as we can". If I click yes, the file will open, but I lose all of my formatting. All 40 sheets are there, but no formatting on any of them. If I disable the writers for 5 of the sheets, I will not get the Excel error and all of my formatting will be on the 35 sheets. I've tried disabling different writers and combinations of writers, so it's not an individual writer issue. If I try to do 36 sheets or more, I get the same error.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.