Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Partially corrupt spreadsheet (2000 SR2)

    Hi,

    I have a very large spreadsheet that I inherited from someone who's not here anymore. It usually works OK but sometimes when we save it something goes wrong and we lose a lot of work.

    On one occasion Excel created one of it's hex named files that can usually be renamed & recovered, however when I tried to do this it opened as a csv file and revealed a lot of data that shouldn't be there. It's now apparent that this spreadsheet had a lot of links to Access data in the past. I'm hoping this old data/links is part of the problem & I'd like to clean up the spreadsheet.

    Unfortunately this is a large spreadsheet (30Mb), loads of macros buttons, very complicated graphs, password protected sheets etc. so it's not just a case of cut & paste from one spreadsheet to a clean one.

    I'd thought about saving the whole spreadsheet as a previous Excel version in the hope it would strip all the Access stuff out, has anyone got any experience of that? or any ideas of how to clean up a large spreadsheet quickly?

    Any help is much appreciated.

    Thanks
    Jim MacLeod

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Partially corrupt spreadsheet (2000 SR2)

    Saving in an older Excel format probably won't work. Try some of the options in Jan Karel Pieterse's article Corrupt Files.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Partially corrupt spreadsheet (2000 SR2)

    Thanks for that, I had a try of the .xls -> .htm -> .xls suggestion but can't get the .htm version to open in excel (probably to complex).

    One of my problems is that, due to the intermittent nature of the saving problem, I won't know when I've fixed it. That's why I think my only option is to create a "clean" version of the spreadsheet.

    BTW I have no "add-ins" running, AUTOSAVE was causing a problem earlier on so I turned them all off.

    Thanks
    Jim

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Partially corrupt spreadsheet (2000 SR2)

    Hi Jim,

    If this is a vital spreadsheet to your company, I would suggest hiring an expert to get this job done. (I would know one, but lounge rules forbid me to advertise <img src=/S/smile.gif border=0 alt=smile width=15 height=15>).

    If you do want to do this yourself, I'd suggest to start with removing all password protection first. Then save as html and back.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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