Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workbook Problem (2007 SP1)

    One of my main spreadsheets that I use everyday just started to have issues with Excel 2007. I still have Excel 2003 installed on one of my computers and I'm not having any issues that I can detect. I've had Excel 2007 for about 4-5 months and I just started have problems within the last 10 days.

    When I open the workbook on my desktop, it crashes Excel. When I open the same workbook on my laptop, it opens, but I get a low on memory message.

    Using 2003, I've tried to clean up some of the sheets by taking out a few things that I no longer use. There wasn't too much that was extraneous.

    The workbook is 713 KB. It uses this MSN MS add-in http://www.microsoft.com/downloads/details...&displaylang=EN

    I also publish pieces of it to a website using auto republish. All of this worked for a while, but now it doesn't. Any suggestions about how I can figure out what's going on would be much appreciated.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Workbook Problem (2007 SP1)

    You might try opening the file, saving as a webpage, close the file.
    Then open the HTML file and save as an XL book.

    This sometimes will eliminate some of the corruption...

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Problem (2007 SP1)

    Steve - Thank you. Saving as html and reopening didn't solve the problem, but it did isolate where the issues were. The formatting of several of the sheets was probably corrupted. They came back with a very strange format that I wasn't able to change. When I removed all the formats and reapplied things seemed to be ok.

Posting Permissions

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