I came across this thread when trying to nut out an Excel issue on Vista. It turns out that there are a number of interesting nasties associated with certain file types when using the new Vista Preview Pane (in Windows Explorer), not seen in XP or even in Vista when the Preview Pane is not displayed.
My Excel spreadsheets are actually mini applications with embedded VBA. When I click once on the application/XLS (yes, they started life as an XLS), Excel.EXE gets called to generate the preview. If you double-click, the app opens normally and executes, until you save/exit (big red X).
At this time the underlying Windows Explorer window is locked with a "ping" sound on every click attempt. The only way to exit is Alt-Ctrl-Del and use Task Manager to kill the explorer window.
When you next enter the Excel, it also dies again, but this time resets the spreadsheet, so the third use it is clean...so long as you don't use the Preview Pane.
As workarounds:
- Turn off Preview Pane (Organize, Layout, Preview Pane)
- Don't click once before opening the file/app which generates the preview, just double click with another file selected
- Open Excel as an application, and use the Recent Documents list
- Double click from an email attachment or the desktop (these both work as there is no preview pane option)
I guess there are two other points:
- Rename the XLS to XLSM - as curiously there is no application linked to XLSM as a preview generator
- Somehow, we need to find out whether there is a code limitation which causes this to happen. I have tried trivial macros and cannot recreate the problem, but any XLS "application" dies in the same way, virtually every time.
Oh, the final option would be for MS to write a fix for this.
I've written this in the interests of it being probably related to the previous (old) thread, as I can't see that the issue has been addressed since then.
CT