why my excel constantly crashes?

Clarifications

When told it is the spreadsheet, why does that not sound plausable?

Does Excel crash with other spreadsheets?
Have you tried going to 'Help' -- Detect and Repair'?
have you tried opening the file in Open Office, and saving it back as an Excel file (in a different directory of course)?
If so, did it make a change?

First, what OS are you running?

How much RAM does your system have? The number one reason for a crash is running out of resources.

Is it with the same file or will all files? It could be a corrupt file if it is just the one.

A file in the program may have become corrupt and the way to fix is to uninstall and reinstall.

Ask "IT" to look at your file. If it is the file causing the crash, it will cause a crash if they try to open it on another system.

Good luck and let us know how this goes.

jd

Does it have links to other Excel sheets?
Or does it link to a Word or Access file?

External links can often cause Excel to "crash", "hang" or "lock-up" due to the need to make connections between the two files.

The more external links you have, the more likely it is to crash.

http://www.appspro.com/Utilities/CodeCleaner.htm

Please post back if you have any more problems or questions.

This was from an older Excel version... than I copy just the tabs to a new workbook in Excel 2003 version. It just started doing that no too long ago. I have pivot tables, images (PDF) and just one link to another spread sheet (this link is picture of the other spread sheet).

I have not try it yet. I will try that.
An interesting observation. If have the workbook opened and click on SAVE and quit Excel it asks again it I want to save.

An interesting observation is if have the workbook opened and click on SAVE and quit Excel it asks again if I want to save.

I found something... I have many Text Box all over my tabs. This morning I started trying to work specific in things that were inerted... such Pivot tables, links, text box, etc.
Everytime I pass the mouse a text box my Excel crashes... than I try it in different tabs... it happened the same.

I don't know of a way around selecting text boxes without a mouse (and that's surprising because I'm a keyboard mover)

So, you may need to try to remove other elements first (carefully avoiding going over a text box).

Make a copy of the file first!

Then try removing "heavy" things like pictures and links.

Save

Close and Re-open

Now try selecting a text box.

If that doesn't work try this:

Right Click on the sheet tab (at the bottom) and Select "Move or Copy"

Mark the Checkbox "Create a copy" toward the bottom of the dialog box that appears

Then in the drop down menu at the top of that dialog box select "(new book)"

Save that new book, close the original file, and now see if you can work in the new file.

is very large for a single worksheet. This sheet is far too complex. It's taking a ton of memory just to open the sheet. That's why it's crashing everytime you go to a text box.

Unfortunately I think your best option is to start a new sheet. You can probably copy text over to the new sheet (carefully making sure not to hit a text box).

But in your new sheet eliminate as many embedded pictures and text boxes that you can.

Try not to link to external files, but if necessary, to other sheets within the same workbook.

Don't put everything on one sheet, create more than one worksheet within the workbook and you can keep elements separated.

Just to give you an idea, I have a 28 page Excel file with 3 worksheets in it and it's only 113 KB. Of course, there aren't any pictures in it so your file will be bigger, but by eliminating pictures and text boxes it will help cut down your file size alot.

Most of the 'crash' issues I've run into involved a faulty third-party plug-in.
... any 3D graphing, barcode or font enhancing plug-ins?

If you're not sure, scroll through Add/Remove Programs to help jog your memory.

If you find any, uninstall them first to see if they are the culprit.

A plug-in by Topaz Systems was the source of a similar issue I encountered many months ago. Uninstalling it and then installing a more recent version solved that one.

Another case involved a barcode plug-in. The same resolution applied.

Good Luck.

I fixed it by taking any format on the text box. I have to copy the tabs with those text box and individualy i let the Excel crashes and recover the file. All the text box were substitued by comments by Excel.

Thanks all for the help.