Excel plus File Assocation (Office 2003)

Topic

New Reply

In “My Documents” etc, when I click on a Word document, Word opens and then the file. Similarly if it was a Publisher, Powerpoint file the same would happen. However, when I click on an Excel file, Excel opens but no file. When I check the properties of the Excel file it says ” Opens with: Microsoft Office Excel”. Any ideas what is wrong?

Reply | Quote

Replies

Am having trouble reproducing this on my system. Is this happening for all your Excel files – or just one or two?

Reply | Quote

Hi,
Thanks for replying.
It is happening on all my excel files, even files that I have sitting on my desktop for easy acces. When clicked, excel opens ok but no file. I have tried the Microsoft “Dectect and repair” – no difference.

Best regards.

Reply | Quote

Hi,
Thanks for replying.
It is happening on all my excel files, even files that I have sitting on my desktop for easy acces. When clicked, excel opens ok but no file. I have tried the Microsoft “Dectect and repair” – no difference.

Best regards.

Reply | Quote

Am having trouble reproducing this on my system. Is this happening for all your Excel files – or just one or two?

Reply | Quote

My first instinct would be to make sure that Tools | Options | General | Settings | Ignore other applications is unchecked. However, that is based on Excel 2K, not 2003.

Reply | Quote

Hi and thanks!

Your suggested solution works on 2003 too! Now all I have to do is find out how it got checked in the first instance!

Best regards.

Reply | Quote

The most likely scenario is that a macro you were running did not reset this setting after turning it on, either by poor design or due to crashing. I think that there is another scenario, in which a workbook with this option on will affect all others if it is opened first – similar to the way the application caculate setting is sometimes stumbled into – though I’m not 100% sure about that.

Reply | Quote

You are spot on again – I was developing a rudimentary macro when I pressed incorrect keys and screwed it up.

Many thanks for your help – problem now totally solved!

Reply | Quote

You are spot on again – I was developing a rudimentary macro when I pressed incorrect keys and screwed it up.

Many thanks for your help – problem now totally solved!

Reply | Quote

The most likely scenario is that a macro you were running did not reset this setting after turning it on, either by poor design or due to crashing. I think that there is another scenario, in which a workbook with this option on will affect all others if it is opened first – similar to the way the application caculate setting is sometimes stumbled into – though I’m not 100% sure about that.

Reply | Quote

Hi and thanks!

Your suggested solution works on 2003 too! Now all I have to do is find out how it got checked in the first instance!

Best regards.

Reply | Quote

My first instinct would be to make sure that Tools | Options | General | Settings | Ignore other applications is unchecked. However, that is based on Excel 2K, not 2003.

Reply | Quote