This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Error: “We found a problem with some content in <FILENAME.xlsb>. Do you want to recover as much as we can?" when opening the XLSB file containing multiple worksheets
Excel binary file (XLSB) created from Output Data tool appears to be corrupted and needs to be recovered in Microsoft Excel. When opening the Excel binary file, the following message pops up:
We found a problem with some content in <FILENAME.xlsb>. Do you want to recover as much as we can?
Version: < 2022.1.1
MS Access driver 2010 (32-bit); or
MS Access runtime 2013 (use with Designer version 2021 onwards)
GCSE-303/TPM-497 has been logged to address this.
Avoid naming the worksheet like "C" or "R" alone or with numbers from 1 to 1048576 as this will cause an issue in the Excel file.
The defect GCSE-303/TPM-497 is addressed in Designer version 2022.1.1 and above by checking the worksheet name. If the worksheet name is "C" or "R" alone or with numbers from 1 to 10485676, the following error will be displayed.
Given worksheet name <WORKSHEET_NAME> not as per standard, it corrupts excel file. Please change worksheet name.