I'm having issues in my office, with Office 2007, mainly Excel, when you go through Windows Explorer to open a excel file, it takes forever for the file to open.
I'm having issues in my office, with Office 2007, mainly Excel, when you go through Windows Explorer to open a excel file, it takes forever for the file to open.
Possible solutions:
Remember this is for ONLY when you double-click on a Word or Excel file and it takes a long time to open.
Solution 1.) If you have installed PDF maker, which can get installed when you install scanner software, the Excel add-on can potentially cause Excel to open slowly. This is more common in Office 2007.
- Close Excel and any other window you have open
- Open "My Computer" and browse to C:\Program Files\Microsoft Office\Office12\XLSTART
- When you open Excel, check to see if the time it takes to open the xls/xlsx is shortened.
Solution 2.) This can be fixed by reinstalling Office but there is a faster way to fix this .
- Go to your Control Panel, (click on Start then Click on Control Panel)
- Click on Folder Options, then File Types,
- scroll down to and select (DOC for Word files) or XLS (for Excel files),
- click Advanced and select Open entry,
- click the edit Button.
- deselect "Use DDE"
- append "%1" (include the quote marks) to the end of the application command line,
- Remove /dde if it is at the end of the command line
- Then click on OK three times.
From what I can find, it may be a possible issue with Personal.xlsb - the file where your personal macros are stored. Navigate to here and delete the file (if there is a file)
C:\Documents and Settings\USERID\Application Data\Microsoft\Excel\XLSTART
Excel will create a new file if you record a macro.
When excel files wont open from Windows explorer, the first two things you should do are:
- Tools -> Options -> General and uncheck Ignore Other Applicaitons.
- Close Excel and from Windows use Start -> Run. Type - C:\YourPath\Excel.exe /unregserver
then do the same thing, but type - C:\YourPath\Excel.exe /regserver
Replace YourPath with the actual path to Excel.exe. Neither of these commands will start Excel, but they will rewrite the registry items associated with Excel. I’ve never had to type the path, I’ve just used Excel.exe /regserver, but better safe than sorry.
Sometimes just using /regserver will fix the problem, but there have been occasions when the /unregserver step was needed.
Bookmarks