Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Cannot access Excel read-only file

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 2 posts
I have almost the same exact problem as a previous post, but haven't seen a solution. I have an Excel document that suddenly today won't open. I get a "Cannot access read-only document abc.xls" message when trying to open it. I then get a "cannot access abc.xls" message. I can't 'save as' or 'send to'. I had been using this file almost daily (yesterday was the last day) and have never saved this file as "read-only". I do not have this file backed up and is my only copy and of course, it has a very important project on it.

The initial file was created in Excel 2007 and I ran the conversion to work in Excel 2002. I have several 'read-only' files in the same folder, but this one was never 'read only' until I got this crazy message.

I've seen others with this problem, but cannot find a good solution.
Thank you for any help!
  • 0




    The hippie freak computer geek

  • Member
  • PipPipPipPipPip
  • 2,496 posts
Hello, and welcome to Geeks To Go.
When there are changes to your computer that you did not make, or files that you can no longer access, it is probable that your machine is infected.
I suggest you go to the Malware Forum and run all the steps located in the START HERE. These self-help tools will help you clean up 70% of problems on your own. If you are still having problems after doing the steps, then please post a HiJackThis Log in THAT forum. If you are unable to run and/or post a HJT log, then post that in your initial post in the topic you create in that forum.

If you are still having problems after being given a clean bill of health from the malware expert, then please return to THIS thread and we will pursue other options to help you solve your current problem(s).
  • 0



    New Member

  • Member
  • Pip
  • 1 posts
I have the same problem, but I don't think it is to do with any malware. I re-installed windows on my work PC and since then I cannot open the excel file. I think because of temporary files.
I tried emailing it to another account, and it gives the following error:
"Unable to open the temporary file c:\documents & Settings\username\Folder\abc.xls Check your 'Temporary Directory' Setting."
And prior to this it gave an error about C:\TEMP\TMP\moz_mapi .....
As I deleted / reinstalled windows and the temp files are gone, is there anything I can do to try and get my .xls file to work?
  • 0



    New Member

  • Member
  • Pip
  • 1 posts
There are a lot of things that can be done to retrieve data from corrupt "read only" "can't access" excel files. My system's error message is in Japanese and the Japanese help article from Microsoft goes into quite a lot of detal. Here are the Japanese pages (the first with specific reference to excel files, the second to general read acces problems). But I can't find the English versions of the help pages.

I read Japanese so I can tell you want is in them.
1) Use different versions of Excel, or use Word. I also tried OOO.org's Calc.
2) Attempt to reference the contents of the file from another workbook. You can do this using the gui or using text
2.1) Using text
Create a new excel file in the same directory as the problem file. And add this to the top left cell (A1)
changing "workbookname" to the name of the problem file, and "sheetname" to the name of the desired sheet in that file (Sheet1 is the default for the first sheet).
If that accesses data the drag the bottom right corner of A1 in your new file to reference all the data you require.
Using the GUI to do the same thing
create two new excel files.
Copy A1 in one file and paste to A1 in the, using the choose paste format tool, choosing the type of paste to be "paste link".
Then change the link you have just pasted using the update link (or similar) item in the edit menu. Updating the link you have just pasted (between two empty files) will allow you to browse to the problem file. And do as above, dragging the bottom corner to reference more data.
This is doing the same thing as 2.1) just using the browse function to set the reference.

3) Do a check disk (My computer>browse to drive>properties>tools>check disk> scan and automatically repair (reboot). Try to access the fault file again, and also search for files ending in .chk and rename them to excel files .xls and see if they contain your data.

All the above did not work for me. It is as if the file is really seriously corrupted. But then I tried one of the many Excel file recover programs and the first one I tried shows all the data in the preview window. I am in no way affiliated. This one costs 27 USD, personal to 45 USD institutional/business.
I guess I should buy it. But my feeling is that the program is doing something really simple (just ignoring a "this file is in use" type flag) so their should be a free solution.
But anway, I guess the company deserves some kudos. You can preview the file visually, but not export, using the demo version. One problem with the program is it would not let me close it down. I had to use Ctrl ALT Delete and forced shut down.

My semi-solution was Recuva. I had recuva already installed. I use it to retrieve jpg's when I accidentally delete them from SD cards. I highly recommended it. It is free software, and managed to recover much of the data though not as much as Recovery Toolbox's software above. It was as if Recuva did not manage to get the final version of the software, some of the more recently input data was lost)
So I would try recuva prior to purchasing the above. Recuva has an option for scanning for undeleted files. I did not need to set that - it found my undeleted but corrupted excel file anyway. Only the sheet name appears garbled.

Addendum....I checked the box which allowed Recuva to search for undeleted files and it found the undeleted file but it could NOT recover it. The file was in a sense recovered, in that a copy was created in the destination folder of my choice, but it had the same read only can't access problem as the original file. What I achieved with Recuva was therefore, to recover the last version that I had saved prior to the crash. Only the more sophisticated, dedicated excel recovery program seems able to get the data from that.

Edited by timtak, 25 October 2010 - 07:22 PM.

  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP