Workbook Problem (2007 SP1)

Topic

New Reply

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 [/url]

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.

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote