PDA

View Full Version : Bump Whenever Excel Crashes


Pages : 1 [2]

Brad Gile
07-22-2011, 06:30 PM
I overwrote some data that I can't get back. My system is crashing (not my computer, my mind)

Reminds me of a catastrophe that occurred when I was an actuarial student in the early 70s. We were using a PDP-11 computer that had a disk full of important data, and we had a new guy running a program. When he started up, he was asked, "Do you want to Initialize?". Oh, he thinks, do I want to begin? Sure! Well, that command initialized the disk - wiped the sucker clean! That poor guy spent 3 full weeks reentering data. :(

No, fortunately, I wasn't the new guy. :)

ADoubleDot
07-22-2011, 06:36 PM
:lol: that makes me feel better. I only deleted the one file and was able to back into its recreation

Rick_G
07-24-2011, 10:57 AM
:shake:

Opening a workbook? Come on!
Me too - DOH!

Brad Gile
07-24-2011, 04:23 PM
:lol: that makes me feel better. I only deleted the one file and was able to back into its recreation

I failed to add that the poor guy had to do punch cards first to feed data into the PDP-11. The punch machines were made in the 1950s. Any time we wanted to use the mainframe, we had to send down punch cards. If new cards were needed, WE had to create them on those ugly machines! :)

yoyo
07-25-2011, 03:57 PM
you mother humping son of a whore

ADoubleDot
07-26-2011, 11:02 AM
:swear: i hate when it just disappears and doesn't even give you that hope that autorecover might have gotten something.

E
07-28-2011, 02:03 PM
Not a crash, but funny nonetheless. . . I wanted to unmerge all cells on a sheet but accidentally merged the entire sheet into a single cell. Never done that before.

limabeanactuary
07-29-2011, 07:31 AM
Not a crash, but funny nonetheless. . . I wanted to unmerge all cells on a sheet but accidentally merged the entire sheet into a single cell. Never done that before.

so... how big was it?

Aeitra
08-01-2011, 12:23 PM
/sigh, copy pasted a survey set (450,000+ samples with 8 variables)
It was trying really hard for four minutes, then shut everything off.

I should really just bring my home computer to do this.

E
08-01-2011, 12:49 PM
so... how big was it?

Words cannot describe such things in terms understood by human users. How big is an atom? The universe? The hyperbolic license I take here?

Rick_G
08-01-2011, 02:31 PM
My wife sometimes gets an "Excel out of memory - cannot continue" error when she presses "Control-S" to save a small workbook file to her hard drive. She "only" has 8 GB of RAM, so she always asks me why Excel does not have enough memory. :swear:

ADoubleDot
08-01-2011, 02:42 PM
My wife sometimes gets an "Excel out of memory - cannot continue" error when she presses "Control-S" to save a small workbook file to her hard drive. She "only" has 8 GB of RAM, so she always asks me why Excel does not have enough memory. :swear:
XP?

Rick_G
08-01-2011, 03:37 PM
My wife sometimes gets an "Excel out of memory - cannot continue" error when she presses "Control-S" to save a small workbook file to her hard drive. She "only" has 8 GB of RAM, so she always asks me why Excel does not have enough memory. :swear:
XP?
Windows 7 Professional 64 bit, with Intel SSD for drive C. Data files are stored on a 500 GB 7200 RPM SATA drive. She has only used about 40 GB so far - mostly from our two cameras - photos and movies.

ADoubleDot
08-01-2011, 03:54 PM
That is puzzling.

E
08-01-2011, 04:57 PM
My wife sometimes gets an "Excel out of memory - cannot continue" error when she presses "Control-S" to save a small workbook file to her hard drive. She "only" has 8 GB of RAM, so she always asks me why Excel does not have enough memory. :swear:

Funny. My wife is always asking me why I don't have enough memory.

Doctor Who
08-04-2011, 05:19 PM
:shake2:

Shame on you Bill Gates.

It was just the autofilter!

Brad Gile
08-04-2011, 06:56 PM
Funny. My wife is always asking me why I don't have enough memory.

:rimshot:
:tup:

ADoubleDot
08-05-2011, 02:40 PM
Alas, my work is gone

Que lastima

Rick_G
08-05-2011, 03:14 PM
Try some TuMbLr humor (thefuuuucomics.tumblr.com/) for relief

limabeanactuary
08-05-2011, 03:14 PM
Sooooo, how's it going, ADD?

ADoubleDot
08-05-2011, 03:33 PM
Sooooo, how's it going, ADD?
anyone know where steve ballmer lives?

ADoubleDot
08-05-2011, 03:33 PM
i just wanna talk, i swear

limabeanactuary
08-10-2011, 03:10 PM
trunkmonkey-loving piece of shipoopi!!!! :swear:

limabeanactuary
08-10-2011, 03:11 PM
and now it's crashing upon "recovery"

limabeanactuary
08-10-2011, 03:20 PM
:taz: SMASH!!!!!

limabeanactuary
08-11-2011, 10:06 AM
I CANNOT BELIEVE THIS CRAP

Oh wait, I totally can

bro

Aeitra
08-11-2011, 10:14 AM
I CANNOT BELIEVE THIS CRAP

Oh wait, I totally can

bro



D= /pat, itll all get better soon. As soon as you destroy the computer

limabeanactuary
08-11-2011, 10:27 AM
We're =supposed= to be getting Win7/Office 2010 this month.

I won't be surprised if I manage to crash that as well.

yoyo
08-11-2011, 10:31 AM
I CANNOT BELIEVE THIS CRAP

Oh wait, I totally can

bro

:clap:
bro

ADoubleDot
08-11-2011, 12:12 PM
We're =supposed= to be getting Win7/Office 2010 this month.

I won't be surprised if I manage to crash that as well.
worse, imo

limabeanactuary
08-11-2011, 04:25 PM
Yes, I've crashed Excel 2010 on my own laptop.

Doing official work, even (b/c my office doesn't have it and I love some of the nifty-keen new stuff)

ShakeNBakes
08-11-2011, 04:38 PM
SPARKLINES!!! (still haven't found a legit use for them, but man are they fun)

limabeanactuary
08-11-2011, 04:46 PM
SPARKLINES!!! (still haven't found a legit use for them, but man are they fun)

I have.

ShakeNBakes
08-11-2011, 04:49 PM
:jealous:

vividox
08-16-2011, 11:51 AM
:bump:

Okay, WTF? I'm trying to fill a formula down a column. It'll copy to the 21,845th row, then stop. If I try to copy it down the rest of my 33k some odd rows, Excel crashes. It's done it three times now.

Nobody22
08-16-2011, 03:55 PM
:bump:
Just working on a kick-butt spreadsheet. But I made sure to save often... TAKE THAT EXCEL!

limabeanactuary
08-16-2011, 04:09 PM
Just wanted to note that I finished building the spreadsheet that I kept crashing while building.

Now I'm waiting to get Excel 2010 tomorrow morning at work so I can actually do something with all that data.

limabeanactuary
08-16-2011, 04:31 PM
Son of a dirty trunkmonkey, it knew I was talking about it.

Gedankenexperiment
08-24-2011, 12:52 PM
Excel: "Continue without undo?"
Me: "Oh yeah good point, I should probably save first. Cancel."
Excel: "Cancel? Pfffwa, what are you afraid of. Lets just see what happens!!!!!"

*crash

limabeanactuary
08-31-2011, 03:32 PM
=heavy sigh=

campbell
09-22-2011, 02:05 PM
FRICKIN FRACKIN SASSAFRASSIN

campbell
09-22-2011, 02:12 PM
I wish I were on unix so I could kill -9 it, stopping the process is just not as satisfying.

AndrewC
09-22-2011, 02:45 PM
http://technet.microsoft.com/en-us/sysinternals/bb896683

campbell
09-22-2011, 04:18 PM
Look, I just want to say I killed the damn thing.

"I pskilled it" just doesn't pack a punch.

JMO
09-23-2011, 07:27 AM
I remember a co-worker who kept a folder in his desk. Folder title, "To Be Executed." Inside was a picture of the marketing guy who ran him ragged.

AndrewC
09-23-2011, 08:12 AM
Look, I just want to say I killed the damn thing.

"I pskilled it" just doesn't pack a punch.

Rename it.

limabeanactuary
09-23-2011, 09:17 AM
Rename it.

I would still know it wasn't the correct name.... :(

Chuck
09-23-2011, 10:28 AM
Maybe this has been covered here, but would it kill MS to maybe have Excel wait 5 or 10 minutes after you exit, or maybe until the next time you open Excel, before it erases the auto recover backups?

It sure would be a lot more useful and make up for having to wait for the durn things to save seemingly every few minutes. How many times do you exit and immediately realize you hit No to save accidentally?

Gedankenexperiment
10-11-2011, 09:46 AM
"Errors detected when trying to save." :swear: There goes not 1 but 2 updates to the model.

Gedankenexperiment
10-11-2011, 10:37 AM
Started copying and pasting the formulas from the last-saved broken version to a working file, 3 versions back, forgot that the last saved broken version contained links to a worksheet I had since deleted. So when I tried to find and replace away all the pasted workbook links, I get the same popup message, one million times in a row.

Why is there no way to kill the find and replace? Blah.

ADoubleDot
10-11-2011, 10:42 AM
stapler on esc is the guidance in the sticky

JMO
10-11-2011, 10:59 AM
Holding the esc key down doesn't work, so I dispute the stapler method. You have to keep hitting it.

I totally agree with gedankenguy - there ought to be a way to just kill it.

campbell
10-11-2011, 02:25 PM
Started copying and pasting the formulas from the last-saved broken version to a working file, 3 versions back, forgot that the last saved broken version contained links to a worksheet I had since deleted. So when I tried to find and replace away all the pasted workbook links, I get the same popup message, one million times in a row.

Why is there no way to kill the find and replace? Blah.

I generally just go kill the process.

That's probably less than ideal.

yoyo
10-11-2011, 03:24 PM
I generally just go kill the process.

That's probably less than ideal.yeah, but coupled with a forceful "F U!" and vigorous sign language, it can be pretty satisfying.

JMO
11-17-2011, 08:41 AM
Microsoft Excel . . . Not Responding

JMO
11-17-2011, 09:31 AM
Update - I waited it out.
What I had done was select a column and then hit enter to move to the next cell. Forgetting that I needed to clear the clipboard. So it copied what was in my clipboard down the entire column.
[Aside - why does Excel still keep the funtionality of hitting enter to paste from clipboard? :swear:
None of the other M$Office apps work that way.]

So when the excel app decided to start responding, I went in and hit undo. Now I'm waiting again.

campbell
11-17-2011, 10:09 AM
I have never had that happen to me.

JMO
11-17-2011, 12:14 PM
I have never had that happen to me.
You have to patiently not do anything to the excel and wait an hour or two.

When my undo came to an end, I saved my results. (That was another hour.)

Just don't hit excape or cancel. That seems to kill it for sure.

MountainHawk
11-17-2011, 12:17 PM
You have to patiently not do anything to the excel and wait an hour or two.

When my undo came to an end, I saved my results. (That was another hour.)

Just don't hit excape or cancel. That seems to kill it for sure.
2 hours to get back to where I started? No thanks, CTRL-ALT-DEL and start from the autosave version at most 15 minutes ago.

JMO
11-17-2011, 12:22 PM
I've never been successful with autosave in Excel. Works OK for me in Word, though.

Doctor Who
11-17-2011, 04:36 PM
Just had it crash on me twice.

:bump:
:bump:

BlindedByScience
11-17-2011, 05:14 PM
Just had it crash on me twice.

:bump:
:bump:

Also. Two Times in the last hour. Weak.

RDslippers
11-20-2011, 09:34 PM
This is for all those times... those times!

:bump:

JMO
12-12-2011, 12:24 PM
:bump:
I was trying to edit some text data in a chart. Excel 2010. Autorecover worked, so I guess I shouldn't complain.

JMO
01-03-2012, 01:55 PM
Crashed my computer. Mouse did not respond, and likewise no response to ctrl-alt-del
I finally had to hold down the switch on my docking station until the computer turned off.

Autorecover saved me a few minutes work, but not everything I had done.

It's possible I shouldn't blame Excel. I was <bad girl! slap hands!> working on a spreadsheet with links to multiple other sheets when it happened,

Chocolate Muffins And Pie
02-11-2012, 12:21 PM
I should have been bumping this thread three times a day for the last several years.

What annoys me in 2007 is where you try to close a frozen instance and excel says "attempting to close". Just close damn it!

yoyo
03-06-2012, 10:00 AM
Yay!

just what i need when doing final prep for today's board meeting

Doctor Who
04-03-2012, 11:50 AM
:bump:

First Excel 2010 crash.

IMP
04-10-2012, 05:22 PM
:swear:

@#$%^&*()#$_@%()_$*(()!@#^)

sigh

:cry:

yoyo
06-08-2012, 10:59 AM
sonofamotherhumpingbasterd

1695814
06-08-2012, 11:12 AM
:bump:

First Excel 2010 crash.I had installed 2010 on my work computer, but the thing crashed incessessently incestantly incessently all the time, so I uninstalled it & am now using 2007 which loads horribly slowly & I hate hate hate the ribbon but it doesn't seem to crash as much.

JMO
06-08-2012, 11:20 AM
"incessantly"
your welcome.

Butters Stotch
06-08-2012, 12:39 PM
this thread made me realize that my excel hasn't crashed in a long long long time. (2010)

:knockonwood: :saltoverrightshoulder: :eyeofnewt:

yoyo
06-08-2012, 12:55 PM
this thread made me realize that my excel hasn't crashed in a long long long time. (2010)

:knockonwood: :saltoverrightshoulder: :eyeofnewt:shut down and go home now

Butters Stotch
06-08-2012, 01:04 PM
shut down and go home now
plz forward this to my boss. see you fellas on Monday!

Gedankenexperiment
06-08-2012, 03:11 PM
this thread made me realize that my excel hasn't crashed in a long long long time. (2010)

:knockonwood: :saltoverrightshoulder: :eyeofnewt:
Ditto... I'm working on our super-massive-nightmare workbook next week though. I plan on holding my breath through the entire day.

Hojo
06-08-2012, 03:14 PM
"incessantly"
your welcome.

*you're

You're welcome.

Gedankenexperiment
06-08-2012, 03:15 PM
I had installed 2010 on my work computer, but the thing crashed incessessently incestantly incessently all the time, so I uninstalled it & am now using 2007 which loads horribly slowly & I hate hate hate the ribbon but it doesn't seem to crash as much.
Were you on 64 bit?

Our IT upgraded everything to 2010, but she managed to miss the 64 bit thing since Windows just assumes that you don't want it. You can check by going to File->Help.

JMO
06-08-2012, 03:19 PM
*you're

You're welcome.
New to the AO, are you?

Gedankenexperiment
06-08-2012, 03:29 PM
New to the AO, are you?
*New to the AO, you're?

Gedankenexperiment
06-18-2012, 11:56 AM
Ditto... I'm working on our super-massive-nightmare workbook next week though. I plan on holding my breath through the entire day.
It's working it's working! 1.5 gigs are being loaded as we speak. On to new horizons of coding inefficiency.

Moore's law, I'm going to bring you down... :pity:

campbell
06-18-2012, 12:01 PM
It's working it's working! 1.5 gigs are being loaded as we speak. On to new horizons of coding inefficiency.

Moore's law, I'm going to bring you down... :pity:

Whoa, I'm going to need to change the survey on my spreadsheet webinar....

How fast does it load?

Gedankenexperiment
06-18-2012, 12:24 PM
Whoa, I'm going to need to change the survey on my spreadsheet webinar....

How fast does it load?

Oh the workbook is only a couple hundred megs in size-- I'm talking about my ram, which used to top off at a gig and change. I've got a lot more to add, and this computer only has 4 gigs, so we'll see...

campbell
06-18-2012, 01:33 PM
=phew=

I was worried you had a spreadsheet larger than mine.

E
07-05-2012, 11:36 AM
The more I use Excel 2010, the more I feel like the extra rows and columns are just a mirage. I mean yeah, they're there, but in my experience, the performance of Excel rapidly degrades if you create sheets with 100s of thousands of rows.

I have several workbooks that crash even if I try to copy and paste more than a couple hundred thousand rows.

I'm starting to rely more on Access for processing large quantities of data, even though Excel should be able to handle it in theory.

FWIW, I'm on quad core box with 8 GB RAM that's less than a year old.

ADoubleDot
07-05-2012, 11:41 AM
i agree with you about the extra rows and columns being a mirage. but copying and pasting a 100,000 rows isn't the correct test. there is more than just Excel involved in a read write to memory of several gigs of data.

starting to rely on Access.... :impossibletotelliftrolling:

E
07-05-2012, 11:46 AM
i agree with you about the extra rows and columns being a mirage. but copying and pasting a 100,000 rows isn't the correct test. there is more than just Excel involved in a read write to memory of several gigs of data.


True. I guess I'm speaking in more general terms about the impracticality of using large spreadsheets. Doing routine tasks like copying and pasting is difficult -- whether it's the fault of Excel or fault of the system.

ADoubleDot
07-05-2012, 11:52 AM
its not clear to me why moving that much data from spot to another would ever be a "routine task".

a few suggestions on doing it:
1) right click the sheet with the data and choose "copy or move". In the drop down menu, you can copy the sheet to another workbook or create a new workbook with a copy of the sheet. This works much better than copy paste.

2) use the VBA immediate window and do a sheet1.range1.value2 = destSheet.range2.value2 which seems to work for large sets as well.

E
07-05-2012, 11:59 AM
its not clear to me why moving that much data from spot to another would ever be a "routine task".

a few suggestions on doing it:
1) right click the sheet with the data and choose "copy or move". In the drop down menu, you can copy the sheet to another workbook or create a new workbook with a copy of the sheet. This works much better than copy paste.

2) use the VBA immediate window and do a sheet1.range1.value2 = destSheet.range2.value2 which seems to work for large sets as well.

I'm currently working in an environment where many oddities are routine tasks. Automation can't happen until we add more staff.

Apply within.

MountainHawk
07-05-2012, 12:08 PM
I'm currently working in an environment where many oddities are routine tasks. Automation can't happen until we add more staff.

Apply within.
I have a spreadsheet with 975K rows and 8 columns on the data tab, and it works fine. I have a pivottable off that dataset, and then some calculations off it.

Gedankenexperiment
07-05-2012, 12:11 PM
The more I use Excel 2010, the more I feel like the extra rows and columns are just a mirage. I mean yeah, they're there, but in my experience, the performance of Excel rapidly degrades if you create sheets with 100s of thousands of rows.

I have several workbooks that crash even if I try to copy and paste more than a couple hundred thousand rows.

I'm starting to rely more on Access for processing large quantities of data, even though Excel should be able to handle it in theory.

FWIW, I'm on quad core box with 8 GB RAM that's less than a year old.
But is your excel 32 bit or 64 bit? I have an i5 with 4 gigs of ram and can paste 40 million cells before crashing.

The new excel is definitely not perfect, I still have to be conservative about processing time, but I'd prefer an abacus to Access.

E
07-05-2012, 12:12 PM
Is your excel 32 bit or 64 bit?

I have 5 gigs of ram and can paste onto 50 million cells without crashing.

64

I have the same problem whether I'm working on a local desktop or a Windows 2008 server. Both machines are less than a year old and trimmed out pretty well.

JMO
07-05-2012, 12:57 PM
I'm currently working in an environment where many oddities are routine tasks. Automation can't happen until we add more staff.
Desk sign: We were too busy mopping to turn off the faucet.

ADoubleDot
07-05-2012, 01:08 PM
Desk sign: We were too busy mopping to turn off the faucet.
:lol:

Truman Burbank
07-10-2012, 01:07 PM
:bump: :furious: that is all

campbell
07-15-2012, 07:13 PM
ugh. it's my own fault, too

i'm going to have to kill the process

i don't know why this macro is taking so long to run.... i had run it before, with screenupdating ON, so I decided "hey, let me turn screenupdating OFF and maybe it will run faster!"

no, what has happened is that it won't terminate at all

it's not a bug! it's a feature!

1695814
07-16-2012, 05:57 PM
sunuva...
I only hope I saved recently...
:shake: :swear: :roll:

Rick_G
07-17-2012, 09:00 AM
I made numerous changes to several linked sheets, then pressed save. Excel happily informs me "the changes were NOT saved".

Repeat, rinse, recycle .... then reboot Windows.

campbell
08-06-2012, 04:34 PM
sonofabitch

Piranha
08-07-2012, 10:18 AM
No.

NO.

NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO !

Gedankenexperiment
08-07-2012, 04:37 PM
Trace dependencies!
:yellowcard:
Trace dependencies!
:redcard:

whisper
08-09-2012, 05:03 PM
Not a crash - but god - does Microsoft have to make it's programs so epic in their stupidity?

Stop helping me by changing what I'm telling you to do to what you think I want!

Doctor Who
08-10-2012, 02:58 PM
:bump:

chicken_po_boy
08-17-2012, 10:30 AM
Opened a file that I use every day. Grrrrr...

ADoubleDot
08-17-2012, 12:53 PM
Not a crash - but god - does Microsoft have to make it's programs so epic in their stupidity?

Stop helping me by changing what I'm telling you to do to what you think I want!
autocorrect is not for excel. luckily, you can turn it off in the options.

erosewater
08-17-2012, 02:21 PM
If you use the desktop toolbar on your taskbar (right click taskbar, select toolbars, selct desktop) to open an excel document when excel is already open it freezes excel for like 15-20 seconds. So annoying

ADoubleDot
08-17-2012, 02:41 PM
If I hit myself in the face with a hammer it hurts. So annoying

ifyp imo

BG5150
08-21-2012, 08:49 AM
Just deleting a row. That's it.

Just a tracking spreadsheet for some of my tasks. No formulas. No macros. no VB.

"Excel has stopped working. Microsoft is searching for a solution to the problem..."

Rick_G
08-21-2012, 09:03 AM
Just deleting a row. That's it.

Just a tracking spreadsheet for some of my tasks. No formulas. No macros. no VB.

"Excel has stopped working. Microsoft is searching for a solution to the problem..."
I have been getting the same message about 75% of the time when I exit from Excel. Probably means the registry is corrupt - time to restore Windows from my January backup.

Gedankenexperiment
08-23-2012, 09:44 AM
The file I made yesterday does not open today. :-?

ADoubleDot
08-28-2012, 03:14 PM
autorecover does the opposite of its job for the 52146543153164321125431234th time

MountainHawk
08-28-2012, 03:18 PM
autorecover does the opposite of its job for the 52146543153164321125431234th time
If autorecover crashed once per second, it would take 2*10^18 years for it to fail this many times. As the Universe is only 1.4*10^10 years old, this is approximately 100,000,000 times longer than the universe has existed, so I call BS.

Doctor Who
08-28-2012, 03:30 PM
If autorecover crashed once per second, it would take 2*10^18 years for it to fail this many times. As the Universe is only 1.4*10^10 years old, this is approximately 100,000,000 times longer than the universe has existed, so I call BS.

ADD has a small army of computers he hacked into.

ADoubleDot
08-28-2012, 03:37 PM
If autorecover crashed once per second, it would take 2*10^18 years for it to fail this many times. As the Universe is only 1.4*10^10 years old, this is approximately 100,000,000 times longer than the universe has existed, so I call BS.
your facts and logic are really getting in the way of my rant here.

Gedankenexperiment
08-29-2012, 09:41 AM
your facts and logic are really getting in the way of my rant here.

The only way to win is not to play.

ADoubleDot
08-29-2012, 10:15 AM
Excel follows the rules of thermodynamics: You can't win. You can't break even. You can't quit the game.

ADoubleDot
09-04-2012, 12:03 PM
So my employer "upgraded" my machine.

Old Machine: XP, 4GB memory, dual core 2.6 GHz processor

New Machine: W7, 4GB memory, quad core 3.1 GHz i5

But now, excel crashes at the drop of a hat. I tried to delete a column of data around 30,000 rows deep and it crashed. It crashes anytime I autorecover. It crashes if the calculation takes more than 15 seconds or so. Its unbearable. I can't get anything done.

Anyone know the cause for this?

MountainHawk
09-04-2012, 12:25 PM
Probably not enough memory.

yoyo
09-04-2012, 12:50 PM
first, please shut down your applications and restart your computer.

remind tptb that you are an actuarial and need 8gb ram min, imo

ADoubleDot
09-04-2012, 02:27 PM
lame.

yoyo
09-04-2012, 02:37 PM
i know you are, but what am i?

Rick_G
09-04-2012, 04:45 PM
So my employer "upgraded" my machine.

Old Machine: XP, 4GB memory, dual core 2.6 GHz processor

New Machine: W7, 4GB memory, quad core 3.1 GHz i5

But now, excel crashes at the drop of a hat. I tried to delete a column of data around 30,000 rows deep and it crashed. It crashes anytime I autorecover. It crashes if the calculation takes more than 15 seconds or so. Its unbearable. I can't get anything done.

Anyone know the cause for this?
I assume your Excel version has not changed.

This sounds like something is corrupt in the registry. When I have an experience like this, I hop back in time, and restore the prior quarter's Acronis True Image backup file.

yoyo
09-04-2012, 05:17 PM
have IT delete and then restore excel.exe file. it has worked for me, but ymmv

twig93
09-07-2012, 06:52 PM
If autorecover crashed once per second, it would take 2*10^18 years for it to fail this many times. As the Universe is only 1.4*10^10 years old, this is approximately 100,000,000 times longer than the universe has existed, so I call BS.
:rofl:

JMO
09-11-2012, 09:34 AM
:bump:
Format Painter???

ADoubleDot
09-13-2012, 05:12 PM
:bump:

yoyo
10-02-2012, 04:43 PM
quarter end is a perfect time for excel crash :swear:

SirVLCIV
10-02-2012, 04:51 PM
Anyone ever get an auto-crash on an ActiveWorkbook.Save statement in VBA? That's all the line says, and I have isolated that that is the cause of the crash. Comment it out, and everything works.

Next few statements call Outlook and create an e-mail, so not sure if it's just a timing issue?

Gedankenexperiment
10-02-2012, 05:34 PM
Anyone ever get an auto-crash on an ActiveWorkbook.Save statement in VBA? That's all the line says, and I have isolated that that is the cause of the crash. Comment it out, and everything works.

Next few statements call Outlook and create an e-mail, so not sure if it's just a timing issue?

Comment them out and see if the save works.

wat?
10-12-2012, 11:05 PM
http://www.bradwestness.com/wp-content/uploads/2011/11/Augh.jpg

Rick_G
10-13-2012, 08:33 AM
Anyone ever get an auto-crash on an ActiveWorkbook.Save statement in VBA? That's all the line says, and I have isolated that that is the cause of the crash. Comment it out, and everything works.
I have an Excel workbook that randomly crashes as you described (about 25% of the time). It uses a VBA form with a "Save on Cancel" button.

I learned to NOT use that button. I just close the VBA form, then save the Excel file manually. It still crashes about 5% of the time (sigh)

NoName
10-28-2012, 02:24 AM
Excel crashed tonight on me (technically, I guess it hung rather than crashed, but I waited a few minutes and nothing happened). But wait, the story has a happy ending - for what I believe was the first time ever out of a zillion crashes, the autorecover had actually saved a version since the last time I had saved it! I have heard stories of this happening (well, actually I haven't) but I never thought it would happen to me!

ADoubleDot
10-28-2012, 06:32 PM
Quick! Buy a lottery ticket!

SirVLCIV
11-06-2012, 04:08 PM
5 times so far. Every time I've lost a good half hour of work. Bah I need to save more often.

This is not complicated stuff, either.

yoyo
11-06-2012, 04:24 PM
5 times so far. Every time I've lost a good half hour of work. Bah I need to save more often.

This is not complicated stuff, either.so far today?

SirVLCIV
11-06-2012, 08:06 PM
so far today?

Yes. All after noon. ARAHGHAHGHG

One more.

yoyo
11-07-2012, 09:15 AM
Yes. All after noon. ARAHGHAHGHG

One more.you jinxed me, you sonofabitch! :swear:

wat?
11-08-2012, 06:36 PM
http://www.bradwestness.com/wp-content/uploads/2011/11/Augh.jpg

.

yoyo
01-25-2013, 02:23 PM
:swear:

Schedule P workbook

yoyo
01-29-2013, 02:30 PM
:swear:

SirVLCIV
01-29-2013, 05:25 PM
Half hour of difficult work, bah-bye. :argh:

Time to head out for the day.

SirVLCIV
02-11-2013, 10:44 AM
:bump:

DIE EXCEL DIE

Klaymen
02-20-2013, 12:36 PM
3 hours of work lost An entire day lost, due to Citrix. The Excel spreadsheet is involved with 350,000 rows x 50 columns and tons of pivot tables. I saved the spreadsheet more than once during that time, but STILL lost my work. :(

Klaymen
02-20-2013, 12:40 PM
Excel follows Murphy's Law: You can't win. You can't break even. You can't quit the game.
IFYQ

Klaymen
02-20-2013, 12:42 PM
autorecover does the opposite of its job for the 52146543153164321125431234th time

Also, the probability that a randomly selected number with 26 digits has all of those digits between 1-6 is 0.6^26 occurs is 1 in 586,230. I call BS as well.

whisper
02-27-2013, 09:54 PM
The message was epic:

Method '~' of object '~' failed

ADoubleDot
02-27-2013, 10:02 PM
IFYQ
Sorry for being a week late, but you broke my post. That is not Murphy's Law.

ADoubleDot
02-27-2013, 10:04 PM
Also, the probability that a randomly selected number with 26 digits has all of those digits between 1-6 is 0.6^26 occurs is 1 in 586,230. I call BS as well.
Who said it was random? That was the count. Now its 293470234409574095703458763

yoyo
03-28-2013, 04:22 PM
sonofamotherhumpingwhore

campbell
05-17-2013, 04:18 PM
i cannot believe you, you ****ing piece of shit

:swear:

A simultaneous crash of Word and Excel

well done indeed

yoyo
05-18-2013, 09:58 AM
my, my.such salty language from such delicate flower...

Rick_G
05-18-2013, 11:00 AM
my, my.such salty language from such delicate flower...
I see that you have met Mary Pat in person :tup: