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.

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

 

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.

• Marked as answer by William Zhou CHN Thursday, August 25, 2011 9:05 AM

Yes Done It.

Thanks !!!

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.

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.

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.