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
Photo

EXCEL (win98 office2000) Dopey problem!


  • Please log in to reply

#1
feetybone

feetybone

    New Member

  • Member
  • Pip
  • 2 posts
ARGH ARGH ARGH! Recently I copied a rather large Excel file (spreadsheet) from my desktop to a diskette. I tested the file through the disk before deleting it from my desktop and it worked fine. NOW I try to open it from the disk and I get the following error message:
"[file] 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."
Additional facts are:
1. The file is NOT "read-only".
2. There are 2 other files on the disk which CAN be opened with no problem.
3. The file in question contains macros, but it cannot be opened whether they are enabled or disabled.
4. I cannot copy the file back to the desktop or anywhere else because I get this message: "Cannot copy [file]. The system cannot read from the specified device."

This file was a LOT of work spanning TWO YEARS time. PLEEEEEEEZ HELP!!
  • 0

Advertisements


#2
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
you deleted from your desktop is it in the recycle bin?
  • 0

#3
feetybone

feetybone

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Actually, it was deleted several weeks ago and is long gone from the recycle bin. I think it's basically a problem created from the combo: floppy + excel file + macros = potential disaster.
Thanks for the attempt, but I think my request for assistance will have to fall into the "never mind" category.

And starting from square one I go....
  • 0

#4
DavoDubbya

DavoDubbya

    New Member

  • Member
  • Pip
  • 1 posts
1) Try booting in Safe Mode with Command Prompt. Change to the Drive/Partition where the problem file(s) reside.

2) Run Chkdsk /f plus chkdsk /r

3) Reboot into normal mode.

4) Try to reopen your corrupt file(s)

5) If they still won't open, check to see whether there has been a newly created directory called "000. FOUND" or something similar in the root of the Drive. Go into that.

6) Find and rename the "found fragmentation" file(s) changing them to a ".xls" extension.

7) Try to reopen it (them)

Worked for me. Thank God. After I tried everything else I was about to committ hiri-kiri as this was a completely critical file. Looked like two spreadsheets had been mixed up.

Good luck with yours.
  • 0

#5
lily1

lily1

    New Member

  • Member
  • Pip
  • 3 posts
The EXACT same thing just happened to me. I tried all the other recommendations and none of them worked. This is what I did:
1. Ran a scan disk on my floppy. (Right-click on drive A, Properties, Tools). That took a while. While it did not appear to solve much, IT ALLOWED ME TO MOVE THE SPREADSHEET TO MY DESKTOP!! (simply click and drag)
2. Opened Word. Went to Insert menu and clicked File (Insert File). I selected my spreadsheet. At this point you have the option to select the entire workbook or each spreadsheet one by one. I chose the latter option, since you will see, one of the spreadsheets will refuse to copy - the BAD ONE.
3. Selected the first spreadsheet, hit OK. It got copied as a table in my Word document. I repeated steps 2-3 for all the spreadsheets.
4. Save the Word doc.
5. In the Word doc, click inside the first table, go to Table, Select, Table. The table is now selected. Right click, Copy.
6. Open Excel and click inside the first cell of the first spreadsheet (you will have to insert new spreadsheets as you go). Right-click, Paste. The first spreadsheet is now re-created in Excel. Repeat steps 5-6 for each spreadsheet.
7. Clean up your spreadsheets. This may appear tedious, but after you do it once, you can tell what all needs to be formatted and you will be able to do it all at once for the rest of them (usually, Format, Cells, Unclick Wrap Text, Rows/Colums Autofit and maybe click on the "align" buttons in the Property Bar). Also, some formulas may be gone, but at least the numbers ARE THERE.
I think all this is a small price to pay considering the alternative. Make sure you save a copy somewhere else. This was not caused by a bad diskette or a bad drive, it's rather a problem caused by Excel, so no matter what other media you use, it may happen again, so better safe than sorry.
Good luck!
  • 0

#6
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
why did you put it in word 1st
  • 0

#7
lily1

lily1

    New Member

  • Member
  • Pip
  • 3 posts
Because Excel simply would not let me open it, nor insert the file. Also, I was able to copy it (move it from the floppy) ONLY after I ran the repair scan on the floppy. However, I could tell the content was still there and I was willing to do anything to recover the info. This worked very well.
  • 0

#8
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
Nice one
  • 0

#9
lily1

lily1

    New Member

  • Member
  • Pip
  • 3 posts
Thanks, I guess getting desperate does have some pros: it'll increase your creativity level !
  • 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