Page 1 of 2 12 LastLast
Results 1 to 15 of 29
  1. #1
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel file corruption

    Hi all
    this is a weird one. I have an excel file on a network, it is viewed and saved by people using a mixture of Office 2000 and Office 97. The file is corrupt, I think, it has the following characteristics.
    1. It is sized at 782kb, so I know it's not empty.
    2. When I try to open it with Excel in Office 2000 it does not open, even though the file name shows in the title bar, the work area is blank, with nothing showing but background.
    3. The file contains macro's for pivot table use.
    4. It makes no difference whether I enable or disable macro's during the opening. Still blank.
    5. I can view the file with quickview.
    6. I cannot open the file using Word, or import it into Word.
    7. I have tried downloading and running the Microsoft Cleaner.xla from their web site - but no joy.
    8. The network drive has been thoroughly virus checked with the latest updates, including checking again today, and is clean.
    I know the data is in there, I can see it on quickview, but how the fffflaming hell can I open it? Any clues out there in the big wide Woody World?

    I have not attached the file as it contains macros.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Is it possible that all columns or rows are hidden.

    Press F5 (or Ctrl-G) and enter <big>A:IV</big> in the reference box, then Format, Column, Autofit selection.

    Andrew C

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Window | Unhide....
    It's not hiding there ?

  4. #4
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Andrew

    Good shout, however no good for me. Excel will not admit to having the file open (no grid showing or anything), so I cannot get to any of the file commands to do anything to the spreadsheet!

  5. #5
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Leif

    sorry - no go. If I look at the Windows Menu it is not there as an entry. (Even though the title bar does have the name of the spreadsheet showing at the top). Many thanks for the suggestion anyway.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    I assume you have also tried Leif's suggestion.

    Try Window, New Window and see if that wakes something up.

    Andrew

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Is it showing in the VB editor window?

  8. #8
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Andrew

    thanks again. I did try Leif's idea, but no joy. I also tried new window, still no joy.

  9. #9
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Leif

    the file isn't. The only thing showing in the VB editor is the CLEANER.XLA file I installed as an add in to try to clear the problem. I think Excel is trying to open the file, finding it unacceptable, and then closing the damn thing again.

  10. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    A couple of thoughts.

    1- Have you tried opening it using the Excel viewer? I am not that familiar with the viewer, but if you can open it there, you might be able to copy the data out and paste it into a new workbook.

    2- If you go to the VBA editor, do the worksheets show up in the project explorer? If so, you might be able to use VBA code to copy the data from the worksheets into a new workbook.
    Legare Coleman

  11. #11
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Legare

    Although I can open this with quickview it doesn't offer me a cut and paste.

    Sadly they do not show up in the project explorer either.

    ...but thanks for the ideas

  12. #12
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Phil,

    Straw clutching time.

    You could try opening it in IE5.

    There may be an Excel viewer available from Microsoft. I know they have a Word viewer.

    Or attach it to an email, and let the mail viewer display it (a non-MS mail might be preferable).
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  13. #13
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Hi Phil,

    This is a shot in the dark, but are any of the row or column headers showing? In my version, if I select all cells (the square to the left of A1 and above row 1) then select Format/Row (or Column)/Hide everything is hidden except the row/column headers which are shown in white on dark gray.

    A similar thing has happened to me and it took me quite some time to figure out what the user had done.

    HTH,
    Mike

  14. #14
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Geoff

    many thanks for the reply, however I'm pretty much allout of straws now. I had already tried to open it with IE5, all that did was fire up excel. I already have the excel viewer from Microsoft, and that fails in the same way as Excel. Quickview works, but will not let me cut and paste. My email package will accept the file as an attachment, but to open it the Excel viewer is kicked up, and I'm back to square 1!

    Thanks anyway.

  15. #15
    Lounger
    Join Date
    Aug 2005
    Location
    Newbury, Berkshire, England
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file corruption

    Mike

    sadly I have now grid at all, so I can't select anything. Excel seems to tryto open the file but can't. I get left with nothing but an empty space where the spreadsheet would normally be! The only other thing I was thinking of was opening it in a non Microsoft package, but I don't have anything like Lotus etc. Woordpad and notebook open it fine, but I can't make head or tail of the data, apart from being able to recognise some of the text in amongst the control character jumble!

    Thanks for the suggestions.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •