"cannot be accessed" error opening file on network

G

Guest

Using Office Excel 2003, I get the error message "filename.xls cannot be
accessed. The file may be read-only..." that is in the article 835234, but I
get it when I am trying to OPEN the file from a network location. I've tried
changing the properties on the network file. Any help on how to get the
network copy open?
 
D

Dave Peterson

Debra Dalgleish has a FAQ at:
http://www.contextures.com/xlfaqApp.html#ReadOnly


That says to try this with files stored locally:

Q. All of a sudden a number of my Excel 2000 files have become "read-only".
A. Clear out c:\windows\temp directory on the machine that houses the files,
then reboot.


Since the workbook is on a network share, you may have to reboot the server.
 
G

Guest

Rebooting the server was not an option. I copied the file to my local
machine and followed the instructions. No luck.
I was able to bring in some of the data in the file by using the Open and
Repair option. Unfortunately, only about 1/2 of the records were there.
When I was working with the file before the problem, there were some files
being created with 8 character file names and no extension, if I recall
correctly. The file may have been getting split off and the other records
were possibly contained therein.
We will just rebuild the file since our last copy. thanks for the idea.
 
L

Lady Layla

Your server is unbootable? Scary thought


: Rebooting the server was not an option. I copied the file to my local
: machine and followed the instructions. No luck.
: I was able to bring in some of the data in the file by using the Open and
: Repair option. Unfortunately, only about 1/2 of the records were there.
: When I was working with the file before the problem, there were some files
: being created with 8 character file names and no extension, if I recall
: correctly. The file may have been getting split off and the other records
: were possibly contained therein.
: We will just rebuild the file since our last copy. thanks for the idea.
:
: "Dave Peterson" wrote:
:
: > Debra Dalgleish has a FAQ at:
: > http://www.contextures.com/xlfaqApp.html#ReadOnly
: >
: >
: > That says to try this with files stored locally:
: >
: > Q. All of a sudden a number of my Excel 2000 files have become "read-only".
: > A. Clear out c:\windows\temp directory on the machine that houses the
files,
: > then reboot.
: >
: >
: > Since the workbook is on a network share, you may have to reboot the server.
: >
: >
: >
: >
: > Steve M. wrote:
: > >
: > > Using Office Excel 2003, I get the error message "filename.xls cannot be
: > > accessed. The file may be read-only..." that is in the article 835234,
but I
: > > get it when I am trying to OPEN the file from a network location. I've
tried
: > > changing the properties on the network file. Any help on how to get the
: > > network copy open?
: >
: > --
: >
: > Dave Peterson
: > (e-mail address removed)
: >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top