Pages

Thursday, May 29, 2008

Office 2007 opens slowly fixes

Some people have observed Office 2007 products taking longer than normal to open. Specifically Excel, PowerPoint and Word. The other issue is that attachments in Outlook 2007 can take a long time to open. Below are several things you can do to improve opening times.

Add-ins can make Office 2007 open very slowly.

Adobe Acrobat PDFMaker - The first thing to check for is Adobe Acrobat add-in PDFMaker. You can do a search on the c drive for “pdfmaker.dot, pdfmaker.xla, pdfmaker.ppa”. Search instructions based on what version of Windows you are running:

Windows XP, Windows Server 2003, and Microsoft Windows 2000:
1. Click Start, and then click Search.
2. Click All files and folders.
3. In the All or part of the file name box type: pdfmaker.dot, pdfmaker.xla, pdfmaker.ppa
4. Press ENTER.
5. Right-click the file, and then click Delete.

Windows Vista
1. Click Start , type pdfmaker.dot (for Microsoft Office Word), pdfmaker.xla (for Microsoft Office Excel), or pdfmaker.ppa (for
Microsoft Office PowerPoint), and then press ENTER.
2. Right-click the file, and then click Delete.

Outlook 2007 Add-Ins - Uninstall any unnecessary 3rd party ad-ins.

1. Open Outlook and go to Tools->Trust Center
2. Navigate to Add-Ins in the left column
3. Select COM Add-ins in the Manage drop down and click Go
4. Uncheck any unnecessary add-in like Norton or Symantec product and Click OK

Modify the Way Windows Opens and Shares Data

1. Launch Windows Explorer (explorer.exe) by double clicking My Computer.
2. Navigate to Tools->Folder options.
3. Click File Types tab
4. Select list item XLS (Microsoft Office Excel 97-2003 Worksheet) and click on Advanced. (hint, you can quickly type xls))
5. Select Open and click Edit
6. In the “Application used to perform action” box, scroll to the end. Add a space and then “%1” . Make sure to include the double quotes.
Example for Excel would be "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
7. Uncheck Use DDE.
8. Click OK
9. Repeat steps for Read Only and then repeat steps 4 – 8 for the following file types:
xlsx
doc
docx
ppt
pptx

Or put the following in a text file and save as .bat. Double click the .bat file for it to automatically populate the registry for you.
# doc
[HKEY_CLASSES_ROOT\Word.Document.8\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\WINWORD.EXE\" \"%1\""
# docx
[HKEY_CLASSES_ROOT\Word.Document.12\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\WINWORD.EXE\" \"%1\""
#xls
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e \"%1\""
# xlsx
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e \"%1\""
#ppt
[HKEY_CLASSES_ROOT\PowerPoint.Addin.8\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\POWERPNT.EXE\" \"%1\""
#pptx
[HKEY_CLASSES_ROOT\PowerPoint.Addin.12\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office12\\POWERPNT.EXE\" \"%1\""

The next time you open Office 2007 it should be faster. If not, unregister the products and reregister them. To do this Navigate to Start->Run and type each line in separately. Note that each time done it will open the product.
Excel /unregserver
Winword /unregserver
POWERPNT /unregserver
Excel /regserver
Winword /regserver
POWERPNT /regserver

Last but least, install Microsoft add-in, Lookup Wizard, to Excel 2007.

More can be read at
http://support.microsoft.com/kb/302596
http://kb.adobe.com/selfservice/viewContent.do?externalId=328399&sliceId=2
http://www.m3rlin.org/wordpress/slow-opening-excel-2003-files-in-excel-2007/
http://help.lockergnome.com/office/Excel-extremely-slow-opening-ftopict950153.html

http://excel2007-slow-open-file.blogspot.com/

No comments: