Excel goes mad

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 08 Dec 2007 08:36 GMT

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?

Reply to this Message

bc@brianjwc.vispa.com - 08 Dec 2007 10:35 GMT

Just a thought - are you using a Combo Box, and if so does the problem
only occur after you access it?
Brian

Reply to this Message

bc@brianjwc.vispa.com - 08 Dec 2007 10:37 GMT

... or a list box?

Reply to this Message

Alan - 09 Dec 2007 09:28 GMT

> .... or a list box?
> The only boxes I use are borders, the documents I've opened lately are simple lists of items that I need to add to and alter at times.

Thanks for your responce.

Reply to this Message

g- - 14 Dec 2007 05:50 GMT

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!

Reply to this Message

NickName - 15 Dec 2007 06:41 GMT

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.

> I use Windows XP Service Pack 2 with Excel Version 10.0.2614.0 and I'm having
> problems.
[quoted text clipped - 7 lines]
> can't remember what I did last time.
> Can any one help?

Reply to this Message