Office Software Thread, Excel 2010 Show Formulas Save Bug - Driving Me Nuts! in Technical; We have a problem in Excel whereby if a user shows the formulas used in a spreadsheet, then saves, when ...
24th April 2013, 01:26 PM #1
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.
Last edited by tech_guy; 24th April 2013 at 01:58 PM.
24th April 2013, 01:58 PM #2
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.
By plexer in forum Windows Server 2008 R2
Last Post: 29th November 2012, 12:19 PM
By steve_nfi in forum Netbooks, PDA and Phones
Last Post: 22nd March 2011, 09:18 AM
By elsiegee40 in forum Windows
Last Post: 8th September 2009, 06:09 PM
By plexer in forum Wireless Networks
Last Post: 8th December 2006, 10:54 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)