Excel goes mad

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I use Windows XP Service Pack 2 with Excel Version 10.0.2614.0 and I'm having
problems.
I open a saved file but after I've been working on it for a while it
suddenly goes mad on me. It freezes, certain lines double and rows are in the
wrong place, the top disappears and shows more of it's contents doubled and
some items vanish completely.
Sometimes I get a message saying there's not enough space so it can't show
all the contents but I don't know which space is short.
I did manage to solve this problem once but I needed to System Restore and I
can't remember what I did last time.
Can any one help?
 
Just a thought - are you using a Combo Box, and if so does the problem
only occur after you access it?
Brian
 
I believe this is the common display problem that Excel has when it runs out
of system memory.

The two things you can do are:

1) Increase your computer RAM (and/or it's virtual memory).

2) Decrease the size of your spreadsheet.

The easiest of the two by far is the second option.

Make sure you don't have any excess data in your workbook.

Go to each worksheet and tap the key "End" then key "Home". This finds the
last active cell in the worksheet. Make sure this isn't some wacky cell way
off your data. If it is, then erase all the rows/columns from this cell to
your data. This will free up the amount of memory your worksheet takes.

g-

___________________________________

Need holiday money. Got any jobs, big or small, drop me a line! Thanks!
 
I've had this problem and by the sounds of it many people have, but
when i reported it to MS I was told it was an "unusual issue". I too
was told check RAM, video drivers, etc. What fixed the problem was
closing excel go to C:\Documents and Settings\User\Application Data
\Microsoft\Excel and deleting the files in there.
They were corrupted and when you start Excel again it allows it to do
a clean startup.

What i find interesting is since MS said this was an "unusual
problem" i see postings on the internet almost every day with people
having the exact same problem. they must find the definition for
"interesting" the same way they calculate time remaining.
 
Back
Top