2
2
I have tried:
- Clearing out all the recent files opened with Excel by going to Office button -> Advanced -> Display Category -> Changing the "Show this number of Recent Documents" to 0, and then back to 17, effectively clearing the list
- Going into the registry and clearing out the "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\File MRU" keys
- Restarting the machine
- Running the Windows Disk Cleanup utility
The Excel recent files list remains empty now and will not populate. The recent list I am referring to is the one when you click the Office Button and on the right pane it lists the recent files.
The version of office is 2007 running on Windows 7 Professional x86.
EDIT It seems as if some files when opened by opening excel first and then opening them through excel work. The way people here usually open an excel file is that they open it through a link provided by one of our applications. I am going to check the parameters used to open these excel files.
The program launches excel with a /e switch: "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e
Although this isn't causing the issue on my machine. The machine in question isn't mine.
EDIT 2 The issue is only occuring on Windows 7 machines as I just tested it out on Windows XP.
Windows 7 launches excel with different parameters than Windows XP
Windows 7: "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" /automation -Embedding
Windows XP: "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e
I am fairly certain this is the factor causing this to happen. I am going to contact the software vendor about this issue, although I will keep this question open to any suggestions.
qroberts
Posted 2011-11-18T14:59:09.500
Reputation: 4 609
you mention you cleared the "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\File MRU" keys did you mean excel ? – James Hopkins – 2011-11-18T15:33:36.433
Yes, I meant to type Excel, sorry about the confusion. – qroberts – 2011-11-18T15:34:00.857
is that registry key being re-populated when you open a new document ? – James Hopkins – 2011-11-18T15:35:00.643
It is repopulated whenever there are items being added to the list. I have edited the question above. The issue only happens when excel is being launched with those parameters mentioned above. – qroberts – 2011-11-18T15:38:54.723
http://support.microsoft.com/kb/826922 This post explains what /automation does. Disables Autorun Macros so could be the issue. Can you test without the /automation -embedding switches? – Yeodave – 2011-11-18T15:44:07.177
I cannot launch excel from the application we use using custom parameters. I will read up on that KB. EDIT: I have contacted the software vendor and I will await their reply. – qroberts – 2011-11-18T15:47:36.370