I saved a copy of important excel files back in 2004. When I tried to open
what I was looking for, I was unsuccessful. A window popped up and said
âxyz.xls file cannot be accessed. The file may be read-only (which it shows in
properties) or you may be trying to access a read-only location, or the server
the doc is stored on may not be respondingâ. I know itâs possible to take
ownership of a hard drive in order to change read-only status, however I forgot
how, plus I donât know if its possible to do it with a CD. Can you help?
Besides accessing files that may have been written to CD as a backup, this
is a common trap people fall into when moving files from machine to
machine.
There are many programs that will refuse to open files that are marked
read-only. The problem is that files can appear as âread-onlyâ for several
different reasons.
Iâll look at those reasons, as well as the most common scenario where
people run into this problem. And of course Iâll outline what you can
do.
Become a Patron of Ask Leo! and go ad-free!
Files can appear read-only for one several reasons, the most common
being:
-
The file is marked read-only. Individual files can be
marked as being read-only â typically as a means to protect them from being
overwritten. -
The file is on a media that is read-only. CD-Râs are
write-once media. Once a CD-R has been burned, it cannot be written to â it can
only be read. Hence the files on it are marked as âread-onlyâ. -
The file is in use. Less frequently, another program might
have the file open in such a way that anyone can read it, but the file is
locked for writing. In some cases this can be reported as the file being
âread-onlyâ.
Letâs look at what we can do about each of those.
If a file is marked as read-only on the disk, itâs fairly easy to reset that
attribute.
Fire up Windows Explorer, and locate the file in question. Here Iâve located
âc:\documents and settings\leon\my documents\safeontheinternet.pdfâ:
Now, right click on the file you want to change, and click on
Properties. You should see a dialog much like this one:
Note the Attribute setting âRead Onlyâ â uncheck it if itâs checked, and
press OK. If no error appears, the setting has been removed.
CD-R, the read-only status is copied with it.â
If the file is on a read-only media like a CD-R or a read-only network
share, you cannot change the read-only status. In this situation, or if you
just want to avoid changing the read-only status of the file as we just did,
the next best solution is to make a copy of the file onto your local hard
disk.
So, using Windows Explorer, the command prompt, or whatever means you use to
copy files, copy the file or files from the read-only media to a folder on your
hard disk.
Important! When you copy a file from a read-only media such
as a CD-R, the read-only status is copied with it. That means you still
canât write to the file until you take the steps above to reset the
read-only attribute on the file on your hard disk.
This causes people no end of confusion.
Finally, if the file is in use, you again, can either make a copy of it, or
determine whoâs
using the file and close that program.
While the question asks specifically about Excel, in fact the most common
scenario where this whole read-only problem comes up is when email folders are
copied to CD-R for backup or for moving to a different machine.
must reset the read-only attribute if you want to be able to
write to them.
Mail programs, particularly Outlook and Outlook Express, expect â and
require â that they be able to write to the files containing email. If these
files are marked read-only then the program will either fail to open them, or
worse, tell you that they donât exist.
And remember â copying the files to your local hard disk isnât enough. I see
people frequently stymied because theyâve copied their files locally thinking
that was enough, and they still canât open their mail.
After copying files from CD-R you still must reset the
read-only attribute if you want to be able to write to them.
And naturally that holds true for the Excel file we started with. Copy the
file to your hard disk, reset the read-only attribute, and you should be good
to go.
I am not sure if excel does this but files can be âin useâ if there is a locked file present. If a program crashed and did not clean up its locked file (.ldb in Access) the program thinks that the file is being used. Simply deleting the lock file can also solve the problem.
Again, I donât know if this happens in excel
For unlocking of locked files, I recommend Unlocker (http://ccollomb.free.fr/unlocker/), it makes this annoying job very easy.
Additionally, if you have a file or directory you canât open at all (e.g. when no user has the right to access the file⊠I had that problem before), you could try to use a Knoppix-DVD to boot the system and access the files (e.g. copying it to an external medium).
very inormative thabk you
Hi Leo!
this is raghvendr shastri. i am very thankfull for you to send me these tips. please tell me how can i read your old articals?
Thank you(âAmesegnalehuâ) Leo, how do I access(read) your old articles?
Hi Leo!You are a master since l solved my clientâs outlook xpre. problem.I once burnt her mails into cd,but unfortunetily was unable to restore them.Through this article l hope that Iâll manage it.how could I be able to get in touch with you?Thumbâs upâŠâŠ
I was pleasantly surprised when I got all my old emails back thanks to your tips. Is there any way for me to get back that *.iaf file too? Iâm pretty hazy on what my account settings used to be.
When backing up Quicken files onto CD-R or CD-RW, I try to restore per Quicken. The files are visible, but will not open âCannot open the data file because it is read-onlyâ. The âPropertiesâ method above does not help. I restore backup according to both Quicken & also using RecordNow burning program methods.
i have just installed windows xp but didnt remove my old xp now i can only boot in 1 windows the new one it works fine but when i try to open my old docs file in previous windows it sais i cant open file how do i open it
Hi Have a Problem. my computer fried recently total mother board failure. I brought out the old 300mhz pIII and put my Hard drive from the old computer in an external HD Box and was hoping to be able to access the Drive. I can write and read the drive but I can not get into my documents under what used to be the the old administrator Name. I can look at anything on the drive except the documents under the old Amin name. This is where all my stuff is and I cant figure out how to get at it. I have tried copying â your not authorized to accessâ, Ive tried setting the logon name to be identicle to what used to be on the old computer. Ive tried to make the files available for sharing. nothing works so far. How can I get at these files? on my old drive.
Thanks so much
Leo,
When I attempt to open an excel document by clicking on the documentâs icon. This in turn opens excel as expected. However, that is all that happens. Clicking on any excel document icon only opens excel and NOT the document. I have to open an excel document directly from excel in order for it to open. How can I fix this without having to reinstall Excel? Or am I left with no other choice?
Everytime I go in to Englewood, FL pet shelters,
I get taken back to the screen with all the icons. Canât seem to open any of the files that are attached to that subject. Please help.
Leo,
I just wanted to thank you for so many posts. And am loving this website. I like the idea of a Tip Jar as well. I give so much free advice as a oonsultant that I sometimes feel very undervalued. Should you assist me with such a problem I will be sure to utilize the tip jar. Also I will incorporate the same in my website. BTW what host do you recommend? And why on earth do ISPâs turn of Front Page extensions? COX (www.cox net) just turned them off and left me in the lurch TOTALLY⊠I have to move my website. Yuck Love the simplicity of yours. I see you put the tech in places where it matters. Love the podcasts! All the best for 2007! Bill Zimmermann San Diego
Monogram Systems
Setting up your own tip ar is easy. Heck, just do a view-source on http://buyleoalatte.com and thatâs all there is.
Hosts: http://ask-leo.com/how_can_i_find_a_good_web_host.html
Frontpage extensions are evil :-). I never use them â they result in non-standard web pages, and often very convoluted HTML. I strongly recommend that you find alternate ways of doing whatever it was you were relying on FrontPage extensions for.
I faced exactly the same problem with excel files while opening from a CD-R. However even when I try to copy the file(s) to my hard drive it gives error message â Cannot copy :Cannot copy from source or disk. I tried with other type of files like pdf, doc and they too are giving the same problem.
When you copy a file from a CD-R, the âread onlyâ attribute is copied with it. Clear that in Windows Explorer, and you should be able to edit the file.
Hi Leo,
Iâm having problems opening my excel file. Everytime I open my excel file, it launches the installation of microsoft office xp professional with frontpage. Now I canât open my excel file at all. Do I need to install microsoft office professional with frontpage? My excel was working fine previosly.
the file on desktop cannot be opened on clicking, it just opens a blank windowâŠ. but if I then go to Open folder/files and then to desktop file..it is accessble. So what do you suggest me to open my files just by a double click?
I copied a bunch of excel and word files from a window ME op system to a cd rom. Now, when I try to open up the cd on a windows XP system some files open and some donât. The oneâs that donât have an error message that I am not permitted to access the file. Any ideas? Is there a way I can work around this problem? Thanks
ââBEGIN PGP SIGNED MESSAGEââ
Hash: SHA1
I believe you want this article:
http://ask-leo.com/why_cant_i_open_a_certain_file_thats_on_a_cd.html
Leo
ââBEGIN PGP SIGNATUREââ
Version: GnuPG v1.4.6 (MingW32)
iD8DBQFFzQ71CMEe9B/8oqERApkBAJ48zSunEgD6BkFt6uupOTghThMYeACdGGYJ
VrPzb+kZ4JFA7bjYG/gk3VI=
=2Dw5
ââEND PGP SIGNATUREââ
Hi Leo,
I use Windows XP Media Center Edition, Internet Explorer 7 and Outlook Express 6. A week ago I copied all Outlook Express messages from the Store folder to a backup folder on my C: drive. I then WinZipped all the messages and burned them to a CD-RW.
Two days ago I unzipped and extracted all .dbx folders from the CD-RW back to my C: drive backup folder. In Windows Explorer I can clearly see all the .dbx folders in my backup folder. I checked their properties: they are not read-only files. I used the correct Outlook Express import routine but the import wizard tells me it can find no messages. I then opened the Store folder in Windows Explorer and dragged a few .dbx files from my backup folder to the Store folder. However, when I open Outlook Express the dragged .dbx files do not show up. I then tried changing the âOpen with âŠâ properties of one .dbx folder, going through the first three listed programs: Internet Explorer, Word, Excel. No luck. Tnen I navigated through âOpen with âŠâ and selected Outlook Express. The icon of all the .dbx folders changed in each case, but none of this helped to open the backup .dbx folders in Outlook Express. Then I opened the Outlook Express program folder and selected oeimport.dll. Now my Store folder displays all the .dbx folders with the pretty red-and-blue icon, but I still canât open the restored .dbx folders in OE although they do appear in the Store folder with the all the rest. I canât think of anything else. Can you tell me if I should change the âOpen with âŠâ properties to some other .exe or .dll program, or is that of no use? Any other ideas? Thanks a lot.
Fred Hirschler
Hi Leo,
I downloaded some photographs onto a CD-R 700mb disc a few weeks ago. Im now looking for the disc but I didnt mark it, I have a CD-R disc that is full and I think Its the one I need. However it will not open up so I can look whats on it. It doesnât tell me anything if Its a read only file or whatever It just fails to open. I have tried opening it with different systems and nothing, can you suggest anything.
Regards
Barry Brown.
Hi. I read your article on this error message â*.xls cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.â. But when I copied my file to a hard drive and unchecked the read-only mark, I still get the same message. This was an Excel file I had on an SD card on my Treo phone and modified it using a computer at work that runs XPsp2. Now I canât open it on my phone or on the work computer. Help⊠please⊠Iâve tried downloading excel recovery programs and nothing seems to help. But the file shows it has 195Kb so there must be something thereâŠ
Hi. Iâve followed all the instructions for importing my Outlook Express files from my old laptop to my new one but am still having trouble. The files are on a CD-R. I copied them to my hard drive, then un marked âread-onlyâ under properties. It allows me to do that but then it just changes itself back. Can you help at all?
I just got a new machine and upgraded to Vista and Microsoft Office 2007. I send out these Excel files to my buddies and none of them can open the files. What do they need to do? Thanks.
ââBEGIN PGP SIGNED MESSAGEââ
Hash: SHA1
If they donât have excel ⊠get excel or openoffice.
If they do have excel, then perhaps you need to save the documents in
backwards compatible file format before sending. That might be easiest.
This article also outlines the same issue for Word:
http://ask-leo.com/whats_a_docx_file_and_how_did_i_get_one.html
Leo
ââBEGIN PGP SIGNATUREââ
Version: GnuPG v1.4.7 (MingW32)
iD8DBQFG1vxvCMEe9B/8oqERAkIAAJ9nhAyIMgbVqRyyYh4UlcgGex7gPQCfTryC
M6QbobnqILrH6C2eU2ZB9lU=
=0S3y
ââEND PGP SIGNATUREââ
Hi LeoâŠIâve followed your instructions for copying my folders from my Outlook Express file on my old computer to a CD without any trouble, have saved them to the hard drive on my new computer, have unchecked the Read-only box in properties but I still canât read my messages in Outlook ExpressâŠthey were all in dbx files so I changed them to Excel files but still cannot read them. What am I doing wrong please? Also how do I change them back to dbx files please?
Thank youâŠJoan
Hi Leoâ I read the article above. But all 1900 of my documents transferred off of the CD into âMy Documentsâ in âRead-Onlyâ status. By the why I used CD-RW discs when I did the transfer. The steps I followed are below. Is there a way I change all of my documents at one time so that I can un-do the âread onlyâ status?
Thanks,
Val
1. I put the CD in the new machine.
2 I clicked on âExploreâ from the Start Menu so I could get to âMy Computerâ
3. I clicked on âMy Computerâ which opened up the window for my âD-Driveâ (my CD drive).
4. I did Control-A and selected all of the documents in the âDâ folder.
5. I right-clicked inside of that folder (canât remember if the cursor was on a Document icon or on the space in between the docs).
6 After I right -clicked, I scrolled down to âSend Toâ and selected âMy Documentsâ
7. When I went into My Documents, all of my documents were there. However when you open any of the documents, in parentheses at the top next to the name of the file it says âRead-Onlyâ.
I am running Windows 2000.
I have some files saved on a jump/flash/thumb drive (whatever you want to call it)âŠthey worked fine until yesterday. I tried opening excel and word files and I keep getting the error âthe file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.â How can I fix this?
I have some files saved on a jump/flash/thumb drive (whatever you want to call it)âŠthey worked fine until yesterday. I tried opening excel and word files and I keep getting the error âthe file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.â How can I fix this? When I open the files properties none of them have the read-only box checked.
Hi,
Thanks for all this. However, what if 1) itâs a rewritable disc 2) the system wonât allow me to uncheck âread only?â This is an internal drive; all worked well until today; now all discs are, Stalinistically, âread only,â no matter what I try?
The disc drive is broken?
Thanks for further thoughts.
Hi I have a excel file in the share drive , several users use it, suddenly every one is getting this error message this error message â*.xls cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding, , I tried your method but when I tried to find /Handle it dont display any files, I need to know who is the culprit as this is very important file, I have restored the back up copy and tried to delete the old file, still gives me the same error,My file in on a shared drive, how do I apply the .exe on my share drive ?? i dint get this part, I am not that strong technically, but at the same time I have to fix this ASAP, Any help??
why my vista business edition cant open a âapplication.exe fileâ.once my cursor point just to the .exe file folder my system hangs.just pointing no action being done yet.i noticed that exe file in vista home edtion,the icon is different compare to my business edt.how can i solve this.the file is a game file around 500mb.counter strike source.exe.kindly email me.
Hi Leo,
I have read the comments above but been unable to find the answer to my problem.
I did a wipe of my computer last week but before that I had been backing up (or thought I had) my pst file for Outlook 2003.
Now when I try to reload my backed up pst file it always asks for a password but I never gave it one. Going into the properties of the new pst file that Outlook made when it reloaded it gives the option of changing the password but I canât as I donât have the original password. How do I set it up so that I can create the first password or find out what the original was.
Thanks
Malcolm
iam not able to explore files in cd nor can i burn any data to my cd.i hav windows vista .everytime
i insert a cd i get only options for preparing a blank disc even when there are files in cd.please
help
After I transferred the Outlook Express, every file comes up as âDBXâ and canât be opened. What can I do about this?
Una
Why canât open properties in âMy Computerâ
I have some files saved on a jump/flash/thumb drive (whatever you want to call it)âŠthey worked fine until yesterday. I tried opening excel and word files and I keep getting the error âthe file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.â How can I fix this? When I open the files properties none of them have the read-only box checked.-i got my problem same as danielleâŠplease help meâŠits my important fileâŠ
15-Dec-2008
hi, i saved several word files in my documents and was able to open them , but now i cant open them as it says they are not supported. Not sure what to do.
I have a new computer hooked up to a small network at work that can access shared files on a snap server 2200. However, after I open shared documents once, I cannot re-open them from that computer (âfileâ cannot be accessed. This file may be read-only, or you may be trying to access a read-only location. Or, the serverâŠnot responding.). After I logout and log back in again, I can only open the file, but again only once! No other computer has this problem and no one else has opened the shared file. I think something on this new computer is accessing files twice to make them seem read-only when they shouldnât be. Any suggestions?
Problem as:ââlocal travelling.xlsâ cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.â Iâd tried your method, but problem still. i have no idea. Could you help me to look if i send it to you? Many thks in advance.
Have downloade a file tom tom 2.5 And canât open it any ideas TomTomHOME2winlatest description WinLatest.exe hope you can help
I followed your instructions for moving OE6 to a new machine. I copied the OE6 to my Documents on the new machine and unchecked the read only but every time I close the wizard the folder reverts to read only. ???
Hi,
I think I have the same problem as above, but not quite. I made backup CDs of my computer 5yrs ago. I can see all the files with corresponding creation dates and size on the CDs, they have the read only checked, but I canât open or copy/extract any of them from the CDs. Do you have any advice. Iâve been wondering what to do for years now. Thanks for your time!
08-Feb-2009
I want to move just mail folders from one PC to another both are using Outlook express 6. I have copied files across and tried to import them but no luck (attribute read only is off). When pointing to the folder to import a mess comes back âno messages can be found âŠâ I set some of the DBX file to associate with Outlook Express but still no luck â any hints ? Thanks
I have exactly the same problem as Phil on March 11, 2009, i.e. transfer of mail folders Outlook express ^. Are files read only in express, as I cannot seem to change the properties to enable them to be exported?!
thanks
I am running the java window to extract bookmarked pages from a PDF file. This works perfectly on my system, but on my clientâs network I get the following message:
RaiseError: The file may be read-only, or another user may have it open. Please save the document with a different name or in a different folder.
Doc.extractPages:7:Console undefined:Exec
===> The file may be read-only, or another user may have it open. Please save the document with a different name or in a different folder.
I have saved it as another name and checked the read-only, but still get the message. Any clues would be helpful.
Thanks,
Michael
Wow, Leo! You saved me hours upon hours of work! Thanks for this article!
ALL THE COMMENTS AND THE SOLUTION ARE GOOD, BUT SOMETIMES IF IT DOESNT WORK EITHER. THERE CAN BE PROBLEM OF OFFICE AND ALSO DESTINATION OF THAT FILE. TRY JUST TO DRAG THE FILE YOU WANT TO OPEN FROM CD ON DESKTOP AND OPEN. IT WORKS :)
Hi, Iâve been having a problem with this CD of mine. I read your article and tried to do what you said. For example
I went into the file which is a .rar file. I tried to uncheck the read only status and when I applied it came up with âaccess deniedâ I tried to copy the contents into the cd but it comes up with âincorrect parameterâI tried to fix that problem, but there were no solutions.
This CD is from a friend of mine and the majority of the file types are set in .rar. It doesnât let me open it or copy it. Please help.
09-Oct-2009
I have the same problem as AMIT. Iâm remotely accessing a file. It wonât let me open it from its destination, but if I copy it onto the desktop of my home computer, I can then open the file and work with it. The remote disk drive shows up in âMy Computer,â but when I try to access something through the drive through a program, it doesnât appear. Any thoughts / ideas? Thanks, Mel.
Tried all the suggestions but canât open my file. I had it restored from my up to date backup after my computer crashed. Now whatever I do it denies access. I even restored to another location but same result. What to do now as I really need the contents of that file
Iâm trying to open a pdf file from a CD and I keep getting the error message âcould not open [file] because it is either not a supported file type or because the file has been damagedâ. Iâve been trying to find a solution with no luck. I tried the read only thing you described here and nothing.
We are trying to move into the 21st century in our office (!) and currently save files on the old 3âł square disks. I need to be able to save files onto CDs, however, I need to be able to open and modify those files/documents from time to time. I realize I canât do that with a CD-R (recordable) disk, but before I invest in rewritable disks, will this solve my problem?
Hi! I am an on-line student and my school uses a system called Angel. During this past semester I began to have problems accessing/opening many of the links posted by my professors, most of which were to Word Documents. I know it must have stemmed from me changing or removing something on my computer, but I am yet to figure it out. I even tried a System Restore, obviously with no luck. Do you have any suggestions on how I can fix this? I am completely stumped⊠Any advice would be greatly appreciated. Thanks!
02-Jun-2010
I have had recent difficulty opening pdf and msg files. After extensive research I found that having long file names, in sub-nested long file name folders, caused the problem. After shortening/re-naming the folder/sub-folder and then the file name it allowed me to open all files as normal. I believe there is a maximum limit (XP-NTFS) for a length of file name/folder/sub-folder string. (256?)
hi i cant open any files fom any e-mail r ive tryed to open up a bus timetable no luck can you help me please gary