As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
We have a report that produces Excel out put that runs perfect in Development and QA. When we promoted it to UAT we started getting an Excel Error message: Excel found unreadable content in file xxx Do you want to recover contents of workbook. When we click yes excel destroys all Alpha fields and creates blank or empty cells. We tried switching to Excel 2000 EXL2K and this works. So we are thinking the problem could be related to how we set up the UAT server. Everything we have checked though appears to be the same. We have reloaded the data. Any thoughts on what we maybe missing would be appreciated. Thank youThis message has been edited. Last edited by: DGraff1,
We had this same issue. It was resolved by changing the default CODE_PAGE setting on the WF 8.0.07 Reporting Server Console from "437 - US English" to "137 - US English/Western European (Latin1)" and within the WF 8.0.07 Client Administration Console, changing the Code Page selections from "User Defined" and "437" to "137 - US English/Western European".