+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395

    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 12:58 PM.

  2. #2

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. IE8 Settings driving me nuts
    By plexer in forum Windows Server 2008 R2
    Replies: 10
    Last Post: 29th November 2012, 11:19 AM
  2. Laptops are driving me nuts!!!!!!
    By steve_nfi in forum Netbooks, PDA and Phones
    Replies: 6
    Last Post: 22nd March 2011, 08:18 AM
  3. BBC and Shockwave driving me nuts! Help please!
    By elsiegee40 in forum Windows
    Replies: 2
    Last Post: 8th September 2009, 05:09 PM
  4. HP Wireless driving me nuts
    By plexer in forum Wireless Networks
    Replies: 6
    Last Post: 8th December 2006, 09:54 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •