[ms office - 2010] Excel 2010 Show Formulas Save Bug - Driving Me Nuts!

[tech_guy]

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.

Edited April 24, 2013 by tech_guy

[tech_guy]

UPDATE:

 

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.