Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupt front sheets (2003 SP1)

    I have a workbook with 33 worksheets in. The 25th sheet is fine and all sheets beyond that are OK. However, if I try and go to any of the sheets before the 25th sheet the whole of excel freezes. It does not say calculating and just sits there on the egg timer. I have to crash out of Excel at that point.

    If I write a formula that says, for example, =first sheet name!a1, I get the result, but I cannot figure out a way to actually pull all the data including formulae into a new sheet so I can then export the surviving sheets and save me a lot of problems. Any ideas?
    Neil Eustice
    Woody Worshipper

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

    Re: Corrupt front sheets (2003 SP1)


  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt front sheets (2003 SP1)

    Thanks. Have tried all this and the best I can get is to open the html document via IE. If I put it back into Excel, even as an HTML document, the same pages freeze, even with calculating on manual and the macros sorted. I think we are going to have to copy the data from the web pages and then work out the formula again.

    Thanks anyway.

    Neil
    Neil Eustice
    Woody Worshipper

Posting Permissions

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