none
Reset Excel 2010 to Installation Defaults

    Question

  • I want to reset Excel 2010 to the installation defaults. I have an End user that has somehow configured all new workbooks to flash when opened and I can find the way to remove that feature.
    Tuesday, August 16, 2011 3:50 PM

Answers

  • Hi

     

    Thank you for using Microsoft Office for IT Professionals Forums.

     

    To reset customized user settings for excel 2010 may refer to remove registry keys, before that I still have some suggestions to you.

     

    1.      Disable both Excel Add-ins and COM Add-ins by File>Options>Add-Ins.

    2.      Have a repair in Control Panel>Uninstall a program>Select office 2010>Change>Select Repair.

     

    Finally, if the suggestions above not work, you might try the following.

     

    Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

     

    How to back up and restore the registry in Windows:

    http://support.microsoft.com/kb/322756

     

    Removing the following registry keys may reset customized user settings for your Microsoft Office programs.

     

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel

    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\Excel

     

    When you restart Excel, a repair operation is triggered to set the settings to the default settings.

     

    Please take your time to try the suggestions and let me know the results at your earliest convenience. If anything is unclear or if there is anything I can do for you, please feel free to let me know.

    William Zhou

    --------------------------------------------------------------------------------

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, August 19, 2011 2:16 AM
  • You can reset the customized user settings automatically by using Microsofts Fixit, click the  link Fix this problem to dowload Microsoft Fix it 50274
    Click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

    If that doesnt work Check HERE for more solutions

     

     


    Regards, ~G MCSE, MCDST, MCITP, MCTS, MCP, CCNA
    Wednesday, August 17, 2011 8:30 AM

All replies

  • You can reset the customized user settings automatically by using Microsofts Fixit, click the  link Fix this problem to dowload Microsoft Fix it 50274
    Click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

    If that doesnt work Check HERE for more solutions

     

     


    Regards, ~G MCSE, MCDST, MCITP, MCTS, MCP, CCNA
    Wednesday, August 17, 2011 8:30 AM
  • Hi

     

    Thank you for using Microsoft Office for IT Professionals Forums.

     

    To reset customized user settings for excel 2010 may refer to remove registry keys, before that I still have some suggestions to you.

     

    1.      Disable both Excel Add-ins and COM Add-ins by File>Options>Add-Ins.

    2.      Have a repair in Control Panel>Uninstall a program>Select office 2010>Change>Select Repair.

     

    Finally, if the suggestions above not work, you might try the following.

     

    Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

     

    How to back up and restore the registry in Windows:

    http://support.microsoft.com/kb/322756

     

    Removing the following registry keys may reset customized user settings for your Microsoft Office programs.

     

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel

    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\Excel

     

    When you restart Excel, a repair operation is triggered to set the settings to the default settings.

     

    Please take your time to try the suggestions and let me know the results at your earliest convenience. If anything is unclear or if there is anything I can do for you, please feel free to let me know.

    William Zhou

    --------------------------------------------------------------------------------

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, August 19, 2011 2:16 AM
  • Yes Done It.

    Thanks !!!

    Thursday, November 22, 2012 4:52 AM
  • Thanks William, I had to remove the current user key\software\...\Excel key.  I did not have a local machine\...\Excel key.  This worked fine for me.  I was having a problem where all spreadsheets showed a blank page.  Now they are back to normal.
    Thursday, August 21, 2014 6:20 PM
  • I have this same question but I don't have either one of these registry keys.

    I have one user with an issue in Excel. I am logged in to her profile but running RedEgit under my Admin account.

    The user has no add-ins either so I am attempting the repair step.

    Thursday, October 16, 2014 5:54 PM
  • Thank you for this solution.  It worked for the issue I was having when launching Excel, a network file would automatically open. This file was not on the startup folder, so we were not able to solved the issue until we cleared the registry.
    Monday, July 20, 2015 6:42 PM