Office 2010 Options Malfunction

anaron
anaron used Ask the Experts™
on
Transitioned from Office 2007 to Office 2010. Big mistaken and a waste of money! 2010 is full of unsolvable issues. In the last couple days, I cannot get any Office option changes to take. No problem a few days ago. I click on OK to save the changes and I get a message: "The server drafts location you entered for offline editing is not valid or you do not have permission to access that location. Specify a location on your local computer". Have no idea where that came from! I am a standalone computer and everything I do with my worksheets and docs is on one of my 4 harddrives. For two days now, I have researched and attempted numerous solutions, none of which fixed it. I have uninstalled and reinstalled half a dozen times to no avail. It is really going to be irritating when I find some little ole simple setting that solves the whole issue! Anyone have any suggestions because I am about ready to send 2010 to the scrap heap. Oh! I also started getting constant requests to update Excel worksheets links at the same time. The sheets are updating but I cannot get rid of the message popping up everytime I open a linkable sheet. Could stop that if I could get the options to take a change.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008
Commented:
That sounds frustrating! For what it's worth, I'm running all versions from 97 to 2010 concurrently on one box and 2010 is the most solid of all.

I suspect there are lingering files/registry entries from earlier installations.

On rare occasions Excel can become unstable and start exhibiting unwanted behavior, crashing, or not even starting. Below are several steps to take to try and get Excel back to a stable state. Try to reproduce the problem after each step and, if resolved, there is no need to continue to the next step.

Step 1 - Install Updates

Go to http://office.microsoft.com/en-us/default.aspx, click on "Check for Updates", and follow the instructions.

Step 2 - Repair the Excel Installation

This option is only available in Excel 2000 and later. To repair the Excel installation, start Excel and choose the menu command Help->Detect and Repair. The product CD may be required. In Excel 2007 and later, click the Microsoft Office Button, and then click Excel Options. In the Navigation Pane, click Resources. Click Diagnose, click Continue, and then click Start Diagnostics.

Step 3 - Remove/Reset the Tool Bar Configuration File

Reset the toolbar settings file by deleting the Tool Bar Configuration File while Excel is not running. This file is usually located in the folder

   C:\Documents and Settings\Your Login Name\Application Data\Microsoft\Excel

and is named "Excel*.xlb".

Step 4 - Reset the Registry Entries

Instruct Excel to reset the Excel registry entries. Do this by opening the Start menu and selecting Run. Enter "Excel.exe /UnRegServer" and click OK, wait for the process to finish, then enter "Excel.exe /RegServer" and click OK. The full path to Excel may have to be entered for the command to work.

To get the command to work the full path to the Excel application may be required. If so, the path usually looks like:

   C:\Program Files\Microsoft Office\OFFICE\Excel.exe

or

   C:\Program Files\Microsoft Office\OFFICExx\Excel.exe

where xx is the Excel version: 10 for 2002 and 11 for 2003. So the commands for Excel 2003 are:

   "C:\Program Files\Microsoft Office\OFFICE11\Excel.exe" /UnRegServer
   "C:\Program Files\Microsoft Office\OFFICE11\Excel.exe" /RegServer

This option does not work for Excel 2007. Using the instructions in step 2 resets the registry entries.

Step 5 - Clear the Option Settings

Run RegEdit (Start->Run, enter "regedit", and press ENTER) and navigate to HKEY_CURRENT_USER\Software\Microsoft\x.0\Options where x is 9 for Excel 2000, 10 for Excel 2002 or XP, and 11 for Excel 2003. Delete all entries except for "(Default)".

Step 6 - Remove Custom Add-Ins

Remove any custom add-ins from the XLStart folder and the folder that is specified in the "At startup, open all files in" box on the General tab in the Options dialog box. A custom add-in is any Excel workbook created by the user and saved as an Add-In in an Excel startup folder.

Step 7 - Reinstall/Remove Third Party Add-Ins

This step involves looking for and removing third party add-ins until all add-ins have been dealt with and either removed or determined to not be the cause of the problem. Adobe Acrobat and Norton Anti-Virus are known to have conflicts with Excel. Upgrading to the latest version of these programs usually solves most problems.

The easiest way to remove an add-in is to, from within Excel, choose the menu command Tools->Add-Ins. In the Add-Ins available box, clear the check box next to the add-in to unload and click OK. To remove the add-in from the menu, restart Excel.

To completely remove an add-in use the add-in manufacturer's uninstaller. Uninstallers are found in the Add or Remove Programs control panel.

Without an uninstaller, completely removing an add-in from a computer is possible but not easy. First look in all known XLSTART folders. The most common locations of these folders are:

   C:\Program Files\Microsoft Office\Office11\Xlstart
   C:\Program Files\Microsoft Office\Office10\Xlstart
   C:\Program Files\Microsoft Office\Office\Xlstart
   C:\Documents and Settings\User Name\Application Data\Microsoft\Excel\XLSTART
   C:\Winnt\Profiles\User name\Application Data\Microsoft\Excel\Xlstart
   The folder that is specified in the "At startup, open all files in" box on the General tab in the Options dialog box.

Look for any file that might be the add-in. After quitting Excel, move the targeted file to another location (do not delete it until sure it is the desired add-in.) Start Excel and confirm that the add-in is removed. If not, return the moved add-in to the original XLSTART folder and try again with another.

Some add-ins are not stored in XLSTART folders and are loaded into Excel using Registry entries. If the correct Registry entry can be found then it can be used to locate and delete the add-in. The Registry entry should also be removed but only after making a backup of the Registry and confirming that the add-in identified is the correct add-in. The most common Registry locations where add-ins are located are:

   HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Add-in Manager
   HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options (add-ins are listed in the OPEN and OPENn entries)
   HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Add-in Manager
   HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options (add-ins are listed in the OPEN and OPENn entries)

Step 8 - Completely Remove and Reinstall Excel/Office

This is the most drastic measure and, if done correctly, is the last possible step short of tossing the box out the window. The idea behind completely removing an Office/Excel installation is to purge any and all files and registry entries that might be causing the problem. The normal Office/Excel uninstaller function is not designed to do this. Each version of Office/Excel has different procedures for complete removal. These are listed by version below.

Office 2003 and later
There is no official documented technique for completely removing Office 2003 and later. Open the Add or Remove Programs control panel, locate Microsoft Office, and click Remove. Additional steps follow below to manually purge Office remnants.

Office 2002/Office XP
There is no official documented technique for completely removing Office 2002/Office XP. Open the Add or Remove Programs control panel, locate Microsoft Office, and click Remove. Additional steps follow below to manually purge Office remnants.

Office 2000
Run this cleanup utility: http://support.microsoft.com/kb/239938/en-us.
Run this cleanup utility: http://support.microsoft.com/default.aspx?scid=KB;EN-US;q247674&ID=KB;EN-US;q247674

Office 97
Follow these instructions: http://support.microsoft.com/default.aspx?scid=kb;en-us;254250.
Run this cleanup utility: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q176823.

After completing the above instructions for the specific version of Office, do the following:

Run any or all of the "Fix It" solutions on this page: http://support.microsoft.com/kb/290301

Run this cleanup utility to clean up Windows Installer remains for Office: http://support.microsoft.com/default.aspx?scid=kb;en-us;290301&Product=offxp

Open the Registry (click Start and select Run, enter RegEdit and click OK) and navigate to HKEY_LOCAL_MACHINE->Software->Microsoft and delete the "Office" node.

Open Windows File Explorer, navigate to C:\Program Files and delete the "Microsoft Office" folder.

Download, install, and run CCCleaner (http://www.ccleaner.com). Caution: This utility clears the browser cache so, if that is NOT desired, make sure that option is off or all saved website cookies will be removed. Cookies contain login status, preferences, etc. Select Cleaner and click Run Cleaner. Select Issues and click Scan for Issues. If any issues are listed make sure they are all checked and click Fix selected issues. Save a copy of the registry if desired. Click Fix All Selected Issues when the first confirmation prompt is displayed. Repeat scanning and fixing issues until no new issues are found.

Reinstall Office.

Kevin

Author

Commented:
Have done all that Kevin except a couple of things that did not help either.
However, I have solved the problem using a suggestion from another site. I uninstalled for the umteenth time then I ran msicuu2.exe. I backed everything up before hand because some have reported major problems running the installer cleanup on Win7. Reinstalled and so far no issues. I appreciate your assistance and this site.
Just wondering.... why do you have everything in bold. Gives the effect of shouting ;-)
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Bold is just instinctive for me as I am legally blind so it is easier for me to read. This print is harder but I apologize and will cease further use of bold print.
Top Expert 2008

Commented:
anaron,

In my instructions, if you would have clicked this link:

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

in step 8, you would have seen this text:

"This article previously contained a link to the Windows Installer Cleanup utility (MSICUU2.exe). If you were directed to this article to solve a problem installing a product other than Microsoft Office, please contact your software manufacturer for installation support on the product. Or, see the following Microsoft Knowledge Base article for steps to troubleshoot uninstallation issues with products that use Windows Installer: 2438651 How to troubleshoot problems that may occur when you install, uninstall, or upgrade a program on a Windows-based computer

"While the Windows Installer Cleanup utility resolved some installation problems, it sometimes damaged other components installed on the computer. Because of this, the tool has been removed from the Microsoft Download Center. The Fix it Solutions in this article provide the ability to fully remove Office 2003, 2007 and 2010 suites without damaging other Windows components."

What you have done is followed risky advice and potentially harmed other areas of your Windows installation. The "Fix It" solution presented on the page I included above resolves the issues encountered with running MSICUU2.exe but has the same desired outcome.

Kevin

Author

Commented:
Kevin, just to clarify, I am not a novice. Have been dealing with computer since 1969 when I left college. As to your suggestions, everything was followed and completed except for step 3 and step 5 including 290301. I have used Fix It on numerous occasions and to be honest, the results have been fairly dismal compared to other avenues and certainly did nothing on this issue.  There would be no advances in the computer industry should risky advice be ignored. I could have considered your advice risky as I do not know who you are or what you are about but I didn't and I won't because I am not risking any potential harm to my computer. What I am is a backup fanatic who wants to know where, when, why and how. Currently have at least a dozen backups of various degrees of progress on this issue. I can go back and replicate any and everything that has been done. As to exactly what Msicuu2 does, I do not know but I have used it and it's previous version for years and with good results. The one issue that will eat on me is why took care of the issue and what did it do? May never find that out but it won't be from lack of trying. However, you did  expend your time and knowledge on this issue so I will award points and withdraw the cancelation.

Author

Commented:
I request that this cancelation be withdrawn and points will be issued.

Author

Commented:
I appreciate Kevin's assistance and dedication. Without people such as this the site would not be what it is. Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial