Excel 2010 Show Formulas Save Bug - Driving Me Nuts!
We have a problem in Excel whereby if a user shows the formulas used in a spreadsheet, then saves, when they open the file again it has reverted back to showing the data in the cells and not the formulas.
This is an intermittent problem. Users need to be able to save spreadsheets showing the formulas used so it's a right pain when it happens!
Upon Googling, it looks like other people have reported it as an issue but I can't find a fix. One user is reporting that it happens to him if he has text in a cell with a line break somewhere in the sheet.
Office 2010 is fully patched.
Has anyone come across this problem and worked out a fix?
Running a repair of Office has no effect.