1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Excel "Unable to Read File"

Discussion in 'Business Applications' started by amaul, Apr 30, 2001.

Thread Status:
Not open for further replies.
Advertisement
  1. amaul

    amaul Thread Starter

    Joined:
    Jun 7, 2000
    Messages:
    211
    Am I sorry for not making a backup.

    The XLS File is 1.231 MB in size. It has 15 worksheets.
    Awhile back when I was opening the file, I received a window message stating "The workbook you are opening contains macros. Some macros may contain viruses." along with three buttons, Disable Macros (default), Enable Macros, & Do Not Open.
    A problem here first-of-all is that the file never had macros. Even checking the file after opening (going into the Macro menus) revealed that the file had no macros. But the file worked otherwise and I never gave it much thought.
    I do have the entire system (every file) periodically scanned for viruses. I update my Norton AV monthly.
    NOW, when I try opening this very important file, I still get the macro window message, but immediately afterwards it bluntly states "Unable to Read File".

    I really need the stuff in this file, in each worksheet. I opening the file with a text editor and all the data still seems to be there.
    Your assistance & insite would be very much appreciated on how I can address this problem.

    System Info follows:
    I have MS Excel version 97 SR-2
    Microsoft Windows 98 4.10.2222 A
    Clean install using Full OEM CD /T:C:\WININST0.400 /SrcDir=F:\WIN98 /IZ /IS /IQ /IT /II /NR /II /C /U:xxxxxxxxxxxxxxxxx
    GenuineIntel Pentium(r) Processor
    80MB RAM
    64% system resources free
    Windows-managed swap file on drive C (180MB free)
    Available space on drive C: 180MB of 1218MB (FAT32)
    Available space on drive D: 725MB of 2043MB (FAT32)
     
  2. EAFiedler

    EAFiedler Moderator

    Joined:
    Apr 25, 2000
    Messages:
    14,002
    Hi amaul

    Try opening the Excel file in Word,
    Shift, Right click on the Excel file, select Open with, select Winword, make sure the checkmark for "Always use this program to open this type of file" is removed.
    Copy and paste the workbook to a new Excel file.

    Let us know if this works for you or not.
     
  3. amaul

    amaul Thread Starter

    Joined:
    Jun 7, 2000
    Messages:
    211
    I tried importing the troubled XLS file into Word, and saw that it would take quite awhile (probably days) before getting it all back into its proper format, pages, cells, etc.

    Actually, Microsoft's Online Technical Support helped out (amazing, eh, and I didn't have to pay extra) by fixing/recovering the troubled file. What email they sent to me appears below -- there are some links provided which may be useful to your readers:

    -------- Original Message --------
    Subject: SRZ010501000016:MS Excel "Unable to Read File"

    Hi Andy,

    Thank you for choosing Online Support for your Microsoft Technical Support offering. My name is Charles and I will be assisting you with this Service Request.

    In the case log you've indicated that when you are trying to open a specific workbook in Excel, you receive the message that states the workbook contains some macros, and then another error message says that "Unable to Read File". We shall be working to resolve this specific issue through the course of the case. If I have misunderstood your concern please let me know.

    According to your description, I believe that the workbook that you experience the problem in has already crashed. If possible, please send that workbook and all linked workbooks to me. I'll try my best to recover the workbook for you. However since the Excel file damage is mostly caused by hard disk error or the computer hanging up, I cannot guarantee that I can recover all the information.

    Here, I would like to provide the following article in our Knowledge Base on how to repair an Excel damaged file. You also can use these methods to try to recover the workbook on your side.

    XL: Summary of Methods to Recover Data from Corrupted Files
    http://support.microsoft.com/support/kb/articles/q142/1/17.asp
    <http://support.microsoft.com/support/kb/articles/q142/1/17.asp>

    Also, the following article describes how to prevent Excel file from damaged.

    XL: How to Prevent File Corruption
    http://support.microsoft.com/support/kb/articles/q149/2/35.asp
    <http://support.microsoft.com/support/kb/articles/q149/2/35.asp>

    If anything is unclear, feel free to let me know. It is my pleasure to be of assistance, and I am looking forward to your reply.

    Best Regards,
    Charles Li
    Microsoft Certified Systems Engineer
    Office Online Support
     
  4. Dave Hall

    Dave Hall

    Joined:
    Dec 2, 2004
    Messages:
    3
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/43030