Got "file could not be accessed" error while opening an .xls file through IE

P

Pey

I was creating a text data file named ne.xls under
public_html directory so that any user can use IE to
access the file and view it as excel file. For some
reason, I am getting the "file could not be accessed"
error message if I access the file through Internet
Explore (IE). And there is no error if I directly open up
the file through excel program.

I am sure the file is in the right directory, has read and
write permission, has no special characters in the
filename, the full path is less than 218 characters. And
I am sure it has something to do with the data contents.

For example, error will show up if the file has the
following content, (note: tab delimited):
NE_Name NE_Type NE_Version

In addition, I noticed the worksheet got named as ".xls]NE
[1]"
Thanks.

-Peyhwa
 
D

Dave Peterson

First, I wouldn't save a text file with a .xls extension.

Is the text file comma delimited? If yes, save as .csv.

And this part is a complete guess, but that [1] stuff looks like MSIE made a
second copy of the file in its cache and opened that.

When I opened a text file named ne.xls on my local drive via File|Open (in
MSIE), I got a worksheet named NE.

==
If you try this using a different pc and it works correctly on that pc, then you
may want to reregister excel on your pc.

Just a guess....

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults

If that doesn't work, try one more guess:

Inside excel:
Tools|Options|General|Ignore other applications (uncheck it)
I was creating a text data file named ne.xls under
public_html directory so that any user can use IE to
access the file and view it as excel file. For some
reason, I am getting the "file could not be accessed"
error message if I access the file through Internet
Explore (IE). And there is no error if I directly open up
the file through excel program.

I am sure the file is in the right directory, has read and
write permission, has no special characters in the
filename, the full path is less than 218 characters. And
I am sure it has something to do with the data contents.

For example, error will show up if the file has the
following content, (note: tab delimited):
NE_Name NE_Type NE_Version

In addition, I noticed the worksheet got named as ".xls]NE
[1]"
Thanks.

-Peyhwa
Click to expand...
 
P

Pey

Dave,

The file is tab delimited, and I think the problem is
content-sensative. Please create your own NE.xls file and
put in the contents as
NE_Name[tab]NE_Type[tab]NE_Version
I have it recreated in all environment I have here.

I have also tried your suggestion about re-register and
uncheck the option. Neither works.

Any clue?! Thanks.

-Pey

-----Original Message-----
First, I wouldn't save a text file with a .xls extension.

Is the text file comma delimited? If yes, save as .csv.

And this part is a complete guess, but that [1] stuff looks like MSIE made a
second copy of the file in its cache and opened that.

When I opened a text file named ne.xls on my local drive via File|Open (in
MSIE), I got a worksheet named NE.

==
If you try this using a different pc and it works correctly on that pc, then you
may want to reregister excel on your pc.

Just a guess....

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults

If that doesn't work, try one more guess:

Inside excel:
Tools|Options|General|Ignore other applications (uncheck it)
I was creating a text data file named ne.xls under
public_html directory so that any user can use IE to
access the file and view it as excel file. For some
reason, I am getting the "file could not be accessed"
error message if I access the file through Internet
Explore (IE). And there is no error if I directly open up
the file through excel program.

I am sure the file is in the right directory, has read and
write permission, has no special characters in the
filename, the full path is less than 218 characters. And
I am sure it has something to do with the data contents.

For example, error will show up if the file has the
following content, (note: tab delimited):
NE_Name NE_Type NE_Version

In addition, I noticed the worksheet got named as ".xls] NE
[1]"
Thanks.

-Peyhwa
Click to expand...

--

Dave Peterson
[email protected]
.
Click to expand...
 
D

Dave Peterson

I created it the data you wanted and I saved it with a name of ne.xls (but tab
delimited).

If I did a File|Open, I'd get the text to columns wizard.

If I double clicked on it in windows explorer, xl would just open it.

If I did File|Open in MSIE, xl would open and the file would open within xl.

If I toggled the open in same window in windows explorer, then the workbook
would open directly in MSIE (still via File|Open within MSIE).

And in all cases, the worksheet was named NE.

This was in xl2002, win98, MSIE 6.? and no network.

(I think I'm out of suggestions. Sorry.)

Dave,

The file is tab delimited, and I think the problem is
content-sensative. Please create your own NE.xls file and
put in the contents as
NE_Name[tab]NE_Type[tab]NE_Version
I have it recreated in all environment I have here.

I have also tried your suggestion about re-register and
uncheck the option. Neither works.

Any clue?! Thanks.

-Pey
-----Original Message-----
First, I wouldn't save a text file with a .xls extension.

Is the text file comma delimited? If yes, save as .csv.

And this part is a complete guess, but that [1] stuff looks like MSIE made a
second copy of the file in its cache and opened that.

When I opened a text file named ne.xls on my local drive via File|Open (in
MSIE), I got a worksheet named NE.

==
If you try this using a different pc and it works correctly on that pc, then you
may want to reregister excel on your pc.

Just a guess....

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults

If that doesn't work, try one more guess:

Inside excel:
Tools|Options|General|Ignore other applications (uncheck it)
I was creating a text data file named ne.xls under
public_html directory so that any user can use IE to
access the file and view it as excel file. For some
reason, I am getting the "file could not be accessed"
error message if I access the file through Internet
Explore (IE). And there is no error if I directly open up
the file through excel program.

I am sure the file is in the right directory, has read and
write permission, has no special characters in the
filename, the full path is less than 218 characters. And
I am sure it has something to do with the data contents.

For example, error will show up if the file has the
following content, (note: tab delimited):
NE_Name NE_Type NE_Version

In addition, I noticed the worksheet got named as ".xls] NE
[1]"
Thanks.

-Peyhwa
Click to expand...

--

Dave Peterson
[email protected]
.
Click to expand...
Click to expand...
 
Top