Excel keeps crashing

[Guest]

I dont know if someone could help me out with this issue: 3 of my users here
have this same issue that whenever they open a particular Excel file, it
gives them a Send report error. Weird thing about it is it doesnt happen in
all their Excel files, only happens to some of them. Also tried opening the
very same file/s they are having problems with on my machine and it worked
fine.
Details:
Files are saved in a network folder
Files are under 50MB size
Files have Macros imbedded
Files have links

I have patched Office (SP2), updated Acrobat Reader, and done all the
possible troubleshooting on these machines but still error occurs. Let me
know if you have further questions. Thanks!

 

[Wesley Vogel]

How to recover data from damaged workbooks in Excel 2002 and Excel 2003
http://support.microsoft.com/kb/820741/

Methods for recovering data from damaged Excel 2000 workbooks
http://support.microsoft.com/kb/179871/

--
Hope this helps. Let us know.

Wes
MS-MVP Windows Shell/User

In

 

[Guest]

I have tried your suggestions from the page and none resolved my issue. Error
still occurs on the file. Any other ideas? Thanks.

 

[ANONYMOUS]

How about using your PC to load the file and renaming it by:

File, SAVE AS ...

Give a new name to see if this makes any difference.

Also, If you know anything about CSV file format then it is worth
saving each sheet as CSV format and then to import each sheet one by one
in a new book. This means you will have to copy and paste all macros in
the new book.

Hope this helps.

 

[Guest]

Yes I actually tried that and it works fine. The only thing that I'm worried
about is this file that I saved as may crash again sometime...Do you know why
it's doing that?

Thanks.

 

[ANONYMOUS]

I can only think of Anti-Virus not scanning Macros correctly. Are the
signature files uptodate on those machines. Presumably they are all set
to autoupdate.

Sorry, I don't know. Could be hardware problem!

Regards,

 

[Guest]

Yes the signature files are up to date. Also updated all MS patches in that
system and still crashes Excel.
I would'nt think it's a hardware issue since it starts some of his Excel
spreadsheets - only some of the particular files are crashing Excel. Any
other thoughts? Thanks.

 

[ANONYMOUS]

What is the memory of these systems giving problems? Is your system of
the same spec as the troublesome systems?

I am concerned about the size of these files. "less than 50mb". what
exactly does this mean? Is it 49.5 mb?

There are specialist excel NG that are most suited for your problem.
Try posting there.

hth