My company is in the process of changing to Office 365, and one of my users has run into an Excel issue that I can't seem to overcome.
User exports a report to Excel from our accounting software. The spreadsheet contains several columns that has numbers set as text. The user's solution to this is to multiply the spreadsheet by 1 and convert the cells and text to numbers. This is a Microsoft
solution, although, I had never seen it used before.
The problem is that once the file is saved and reopened Excel reports that the workbook is corrupt and needs to be repaired. The repaired book has removed all of the letters from the spreadsheet.
Is replicated with several different reports and multiple computers
Does not occur with Office 2013 Pro Plus or 2016 Pro Plus (even on systems that crash with 365)
No error messages in Event Viewer
All Windows, driver, and Office updates have been applied
Office has been reinstalled
Excel cache and all temp folders have been cleaned out
The first option in the link to use the text to columns function, but one of the columns uses a merged cell so it won't work for the entire spreadsheet.
Thank you for your time,