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.
Last edited by tech_guy; 24th April 2013 at 12:58 PM.
I have managed to reproduce the bug – by having a cell somewhere on the sheet with text that contains a line break.
Saving the file does then not keep the show formulas view.
Deleting the text with the line break then restores the ability to save the file with the formulas showing and to reopen it with them still showing.
There are currently 1 users browsing this thread. (0 members and 1 guests)