A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't open an excel file (have 2007, Vista) without saving first



 
 
Thread Tools Display Modes
  #11  
Old April 6th, 2009, 04:58 PM posted to microsoft.public.excel.misc
Roger
external usenet poster
 
Posts: 438
Default Can't open an excel file (have 2007, Vista) without saving fir

Followed your instructions but now I get three sequencial error messages
after dbl clicking file gas_elec.xls
1. "C:\Documents.xls' could not be found. Check spelling of the file name,
and verify that the file location is correct.
CLICK OK
2. 'and.xls' could not be found. Check spelling of the file name, and verify
that the file location is correct.
CLICK OK
3. 'Settings\roger\desktop\finance\gas_elec.xls' could not be found. Check
spelling of the file name, and verify that the file location is correct.
CLICK OK
The file now opens!
I have tested three other files with same result.

"Tinytall" wrote:

Here is what fixed it for me. This is different than any of the above steps.
I got this direct from Microsoft Tech Support.

Edit .xls file type
1. Click on Start Control Panel.
2. Double click on Folder Options and select File Types tab.
3. Select XLS file type extension and click on Advanced.
4. Highlight Open under actions and click Edit.
In the dialog box that appears you need to make two adjustments:
Application to perform action:
At the end of the line after /e append a space character followed by "%1"
(including the quotes)
DDE Application Not Running:
Insert new text: [Open("%1")] (including the brackets)

I hope this helps.

Eric


"nw" wrote:

I am having the exact problem described. It began 1-2 weeks ago and only
effects Excel. Running XP Pro with Excel 2003. Still looking for a solution.

"Tinytall" wrote:

I have the same issue (in XP Pro) where opening an Excel file (.xls or .xlsx)
from a directory or from an email will not open the file. It simply shells
out Excel without opening the file contents. I need to save the attachment,
open Excel, then click open, navigate to the saved file and it then will
open. I have unchecked the previously suggested checkmark in Excel Options,
Advanced, General, Ignore Applications that use Dynamic Data Exchange (DDE).

I've even tried other suggested methods such as Start | Run | Excel
/unregserver and Start | Run| Excel /regserver with no luck.

I'm getting tired of saving attachments to open them, so if anyone has found
another issue, please post.

Thanks in advance.

"JimC" wrote:

It used to work fine and now doesn't. if i save the file and open through
Excel, works fine but just trying to double click attachment or outlook
message, gives and error message

  #12  
Old March 4th, 2010, 06:28 PM posted to microsoft.public.excel.misc
Dorci
external usenet poster
 
Posts: 60
Default Can't open an excel file (have 2007, Vista) without saving fir

Thanks Tinytall, that worked for me!

"Tinytall" wrote:

Here is what fixed it for me. This is different than any of the above steps.
I got this direct from Microsoft Tech Support.

Edit .xls file type
1. Click on Start Control Panel.
2. Double click on Folder Options and select File Types tab.
3. Select XLS file type extension and click on Advanced.
4. Highlight Open under actions and click Edit.
In the dialog box that appears you need to make two adjustments:
Application to perform action:
At the end of the line after /e append a space character followed by "%1"
(including the quotes)
DDE Application Not Running:
Insert new text: [Open("%1")] (including the brackets)

I hope this helps.

Eric


"nw" wrote:

I am having the exact problem described. It began 1-2 weeks ago and only
effects Excel. Running XP Pro with Excel 2003. Still looking for a solution.

"Tinytall" wrote:

I have the same issue (in XP Pro) where opening an Excel file (.xls or .xlsx)
from a directory or from an email will not open the file. It simply shells
out Excel without opening the file contents. I need to save the attachment,
open Excel, then click open, navigate to the saved file and it then will
open. I have unchecked the previously suggested checkmark in Excel Options,
Advanced, General, Ignore Applications that use Dynamic Data Exchange (DDE).

I've even tried other suggested methods such as Start | Run | Excel
/unregserver and Start | Run| Excel /regserver with no luck.

I'm getting tired of saving attachments to open them, so if anyone has found
another issue, please post.

Thanks in advance.

"JimC" wrote:

It used to work fine and now doesn't. if i save the file and open through
Excel, works fine but just trying to double click attachment or outlook
message, gives and error message

  #13  
Old May 30th, 2010, 08:51 AM posted to microsoft.public.excel.misc
nota4n1
external usenet poster
 
Posts: 1
Default Can't open an excel file (have 2007, Vista) without saving fir

TinyTall,
I have been through this forum looking for the magic answer. Tried them all,
but noticed you reference to the "%1" in the perform action. The %1 was in
the perform action but without the quotes("%1"). Adding the quotes to the
existing %1 in the perform action and not adding anything to the DE
Application not running, solved the problem.




"Dorci" wrote:

Thanks Tinytall, that worked for me!

"Tinytall" wrote:

Here is what fixed it for me. This is different than any of the above steps.
I got this direct from Microsoft Tech Support.

Edit .xls file type
1. Click on Start Control Panel.
2. Double click on Folder Options and select File Types tab.
3. Select XLS file type extension and click on Advanced.
4. Highlight Open under actions and click Edit.
In the dialog box that appears you need to make two adjustments:
Application to perform action:
At the end of the line after /e append a space character followed by "%1"
(including the quotes)
DDE Application Not Running:
Insert new text: [Open("%1")] (including the brackets)

I hope this helps.

Eric


"nw" wrote:

I am having the exact problem described. It began 1-2 weeks ago and only
effects Excel. Running XP Pro with Excel 2003. Still looking for a solution.

"Tinytall" wrote:

I have the same issue (in XP Pro) where opening an Excel file (.xls or .xlsx)
from a directory or from an email will not open the file. It simply shells
out Excel without opening the file contents. I need to save the attachment,
open Excel, then click open, navigate to the saved file and it then will
open. I have unchecked the previously suggested checkmark in Excel Options,
Advanced, General, Ignore Applications that use Dynamic Data Exchange (DDE).

I've even tried other suggested methods such as Start | Run | Excel
/unregserver and Start | Run| Excel /regserver with no luck.

I'm getting tired of saving attachments to open them, so if anyone has found
another issue, please post.

Thanks in advance.

"JimC" wrote:

It used to work fine and now doesn't. if i save the file and open through
Excel, works fine but just trying to double click attachment or outlook
message, gives and error message

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.