Bump Whenever Excel Crashes

[White Castle]

:bump:

:soap:

:rant:


Pretty much anytime I change visual basic while stepping through it.

[geta6]

:bump: it happened yesterday a couple times so im just going to add to this nonsense

[White Castle]

:bump:

[SouthernGeek]

Can we also bump whenever Excel prints out complete and utter garbage instead of whatever you asked for? (laying cells on top of each other, garbling and cutting off text and borders, sizing the font down to .00001 inches, etc.)

If so then:

:bump: :bump: :bump: :bump: :bump: :bump: :bump: :bump: :bump: :bump: :bump:

[SouthernGeek]

How about when you record a single action in VBA, but when you play back the resulting macro it generates a completely unhelpful error for you?

:bump: :bump: :bump:

[JMO]

Can I post my :bump: now, so I won't have to take any time away from the recovery process when the crash occurs?

[campbell]

I was also about to preemptively bump.

I've got some monster spreadsheets that pretty much always crash Excel. Memory problems. Blah.

[campbell]

...okay, let's see if this recalculation is going to do it....

....wow, I'm up to three minutes on the calculation. Think I'll go get some coffee.


....look like about 80% through, still calculating.No crash yet.

[KandaBer]

How to keep an actuary busy:

1. Bump this thread.

2. Repeat.

(Don't mind me, I'll be the one banging my head against the wall)

[campbell]

:rant:

[ADoubleDot]

:rant:

I assume you know more about spreadsheet efficiency than most. What are doing exactly?

I owe this thread hunreds in back-bumps. Here are a few:

:bump: :bump: :bump: :bump: :bump: :bump: :bump: :bump:

[campbell]

Most of my error-preventing knowledge has come from painful experience.

I just got a little more knowledge.

[thing]

"Good judgement comes with experience. Experience comes from bad judgement."

[ADoubleDot]

:bump:

I think it might come back but its been down a while.

[GatesIsAntichrist]

I can post here virtually infinitely (and given M.S. cluelessness, perhaps endlessly).

"Automation error." I can produce it at will and Ingloriously crash every single time in one or more completely legally constructed .XLS.

I believe that the Microsoftonian who designed the error handling and messaging for "automation error" would be subject to million-fold castration in Turkey and several Arabic countries. (Is the implication clear?)

And don't get me started about crashing by corrupt spreadsheets (or even those that don't crash - maybe even worse in some respects). Microsoft's inattentiveness to this viciously subtle assassin is likewise "castratable."

[ADoubleDot]

:bump: :(

[campbell]

GRAH!

:rant:

[geta6]

for this week: :bump: :bump: :bump: :bump: and counting

[MountainGirl]

nice sig line ADD

[SirVLCIV]

I got this crash twice yesterday. Ugh. http://www.pcreview.co.uk/forums/thread-3728376.php

It's been awhile, my old friend. At least I only lost 5 minutes of work THIS time.

[ADoubleDot]

I got this crash twice yesterday. Ugh. http://www.pcreview.co.uk/forums/thread-3728376.php

It's been awhile, my old friend. At least I only lost 5 minutes of work THIS time.

I don't get it. I use that function all the time. What conditions cause it?

[SirVLCIV]

I don't get it. I use that function all the time. What conditions cause it?

I'm never able to reproduce it when I want to, but it occurred when I had four large spreadsheets open at once, and used the VLOOKUP function from one spreadsheet on a range of cells in another spreadsheet. Probably a memory issue?

:shrug: I didn't lose much, and it's not the type of situation I find myself in normally.

[campbell]

You must not have been holding your eyebrows =just=right= when you entered that formula.

[Piranha]

Trying to hide subtotals in a pivot table. Twice in a row, and I'm sure I could easily repeat it with the same data. Once upon a time I'd passionately try to figure out what caused the problem. But the site I'm at is using Excel 2003, so I'll assume it's been fixed by now.

"Thanks Bill!" is our cheer everytime anything in Office or Visual Studio either crashes or does something "on my behalf for my convenience", like Microsoft Word [almost irreversibly] indenting three pages of text because I hit tab.

[KandaBer]

:bump: :bump: :furious:

Can we make this a sticky?

[Brad Gile]

Trying to hide subtotals in a pivot table. Twice in a row, and I'm sure I could easily repeat it with the same data. Once upon a time I'd passionately try to figure out what caused the problem. But the site I'm at is using Excel 2003, so I'll assume it's been fixed by now.

"Thanks Bill!" is our cheer everytime anything in Office or Visual Studio either crashes or does something "on my behalf for my convenience", like Microsoft Word [almost irreversibly] indenting three pages of text because I hit tab.

You have VS at work? CONGRATULATIONS! I'm retired, but at my last company, VS was forbidden even for IT people. We did, however, have the .NET Framework with XP, so I used the VB and C# compilers for my own clandestine use from time to time. :)

[ADoubleDot]

Received this note just as I was about to leave today:

Dear A..,

F-you buddy! Now you have to work this weekend.

Up Yours,
M$ Excel

:bump:

[campbell]

Excel didn't crash per se, but it was interfering with my other stuff as it was autosaving a huge spreadsheet every ten minutes.

You better believe I switched that setting.

[ShakeNBakes]

when you say huge, how big do you mean? I've got a couple spreadsheets I think are quite large, and I've always wondered how they stack up across the biz.

[campbell]

large enough that it takes about a minute to save.

That's very annoying.

[ADoubleDot]

+ or - 250 MB?

[campbell]

Hmmm. Less than. I think it's the recalculation before save that's really hitting me [I have it on manual, recalculate before save]

[SirVLCIV]

large enough that it takes about a minute to save.

That's very annoying.

I have a massive spreadsheet like that. We even turned off calculate before saving and ONLY calculate before preparing PDF reports (every week). Interesting project, but a LOT of work.

[JMO]

Excel didn't crash per se, but it was interfering with my other stuff as it was autosaving a huge spreadsheet every ten minutes.

You better believe I switched that setting.
I have successfully recovered Word documents via autosave. It has never done me any good for Excel, though.

[KandaBer]

:bump: I looked at Excel cross-eyed.

[F-9]

:bump: Let's not calculate formulas, even though Calculation is set to Automatic. :-x

[KandaBer]

:bump: I looked at Excel cross-eyed.

:bump: Forgot to perform the midnight sacrificial rite.

[ADoubleDot]

:bump: Copy/Paste Formulas over a few thousand cells. :(

[KandaBer]

:bump:

Can I pre-bump this thread, so I don't waste time when (inevitably) Excel crashes?

[MountainHawk]

when you say huge, how big do you mean? I've got a couple spreadsheets I think are quite large, and I've always wondered how they stack up across the biz.
My largest spreadsheet is the one that is setup to do our stochastic analysis of reserves. Once the simulation data is done and saved each quarter, it approaches 400MB.

[campbell]

:rant:

Working in VBA.... hadn't saved [or autosaved] in a while

CRAP

[vividox]

:bump:

Kind of perplexed as to why it crashed. I had a few rate pages up in Excel but I wasn't working on them, mostly just viewing them. I'd had them up most of the day and it just randomly crashed.

[ADoubleDot]

:bump: Stupid array functions. I know better but it's so easy sometimes.

[Doctor Who]

:bump: X 4

[Doctor Who]

http://support.microsoft.com/kb/973475

:bump:

[IMP]

:bump:

let's see how much i lost. i think i saved not too long ago at least...

[IMP]

not bad. only lost a file i forgot i had opened that i was working on from this morning that i barely made any changes to. no biggie. at least my current project was recently saved and nothing was lost. whew!

[Cheerio]

:bump: Happy Year End to me!

Not sure whether it's actually going to recover, but I don't think I'll lose much if it doesn't.

[ADoubleDot]

:bump: No idea what just happened but everything was recovered.

[strategygamer]

:bump:
Same thing here Ä. I got everything back.
Excel has a nice habit of crashing and not recovering anything when I haven't saved in a while.

[White Castle]

:bump:

Was messing with pivot table connections in VBA.

[Brilock]

:bump:

Didn't realize named ranges would do it

[E]

Excel didn't crash, but I needed something to bump my frustration with people not closing network spreadsheets after leaving for the day.

[ZugZug]

:bump:

Not sure how, but a file got corrupted. It was just data, nothing going on inside. Ah well.

[Rick_G]

While printing to PDF (using Acrobat 9 Pro) from Word, I loaded an Excel workbook. This crashed Word, Excel and the PDF process. This has not happened again, so it seems to be a typical "one time" Windows event.

[ADoubleDot]

F9 -> :bump:

[vividox]

:bump:

Oh man, that was a major my bad. I had copied and pasted an entire Word document a few minutes earlier, meant to hit CTRL+C in Excel, and accidentally hit CTRL+V instead, so Excel tried to paste an entire Word document as a formula and it crashed. :lol:

[ADoubleDot]

:bump:

Actually I kicked the power chord for my computer out of the wall. But I had to :bump: something, I'm so pissed. A whole morning of SAS process time wasted.

[MountainHawk]

About to run simulation number 24,994 of 25,000 .... nah, let's crash instead!

(To be fair, this was the first time I had tried running 25K instead of 15K, and when it died, it was using 700MB of ram, so it might have been a tad too much data. ;-) )

[IMP]

been a few weeks since excel has crashed on me....so instead, access has been crashing, adobe acrobet has been crashing, etc etc

[SirVLCIV]

:bump:
Same thing here Ä. I got everything back.
Excel has a nice habit of crashing and not recovering anything when I haven't saved in a while.

I've started being an uber-save-fanatic. Every 5 minutes. Save. Change a formula. Save. Calculate that massive spreadsheet (15 minute calculate time!!! Yikes! (was initially instantaneous, but after loading 17 weeks of data... yeah)). Save.

[Laurelinda]

Gosh I should have been bumping this thread a long time ago.

[E]

:bump:

No explanation.

[ADoubleDot]

:bump:

Multiple pivots linked to a database with over 1.3M rows. Yeah, that oughtta do it.

[vividox]

I didn't realize you could have 1.3M rows in Excel. Is that an add-on or something?

[ADoubleDot]

:bump:

Multiple pivots linked to a database with over 1.3M rows. Yeah, that oughtta do it.

M$ Access. Though I think in Excel 2010, you can have that many.

[vividox]

Oh yes, I fail at reading comprehension.

[MountainHawk]

M$ Access. Though I think in Excel 2010, you can have that many.
2007 allows just over 1M rows, and that was just due the memory limits of 32-bit.

2010 might have 100M rows available.

[tommie frazier]

figure about a dozen posts in here for me.

excel 2007.

some have 400k rows. ugh.

[ADoubleDot]

2007 allows just over 1M rows, and that was just due the memory limits of 32-bit.

2010 might have 100M rows available.

You know that its out right? You need not speculate. I knew it was high but I don't think its 100M high.

[MountainHawk]

You know that its out right? You need not speculate. I knew it was high but I don't think its 100M high.
Oh, is it? I had in my head it was this spring.

[E]

Pretty sure that Excel 2010 will have the same number of rows as Excel 2007. 1,048,576.

I think the confusion arises around whether you're talking about rows in some external database or the number of rows on an Excel sheet. You can, for example, run a pivot table over an Access table, which can have more than Excel's row limit.

[ADoubleDot]

Oh, is it? I had in my head it was this spring.

Well the Beta is, I guess they could still change stuff but I would think number of rows is fundamental and won't be changed.

[IMP]

so my computer has been sucking big time lately. my lease isnt' up yet but i will by asking IT for a new one anyway. along with many other issues, here's some of the latest:

we have a MANDATORY screensaver. when i logback on, sometimes Excel has decided to shut itself down. When I reopen Excel, none of the files that were opened before were autosaved. BUT, when i close it manually, then reopen again, the files show up as autosaved. :yikes:

on my latop, i have the touchpad mouse thing as well as the eraser tip mouse thing, both with their own set of click buttons. the other night, the touchpad mouse buttons decided not to work anymore. and of course, that's the mouse that i likeD to use when i'm at home not on a docking station. grrrrr

The only way that Word will shutdown properly without the "not responding" popup message is if i go to file/exit.

i could go on and on, but this isn't the venue for it. :shrug:

[vtek]

i should be bumping this thread 40 times a day. some of the files i use are ~220mbs while the computers are painfully slow. life sucks

[ADoubleDot]

Pre-emptive :bump: It's been "Calculating Pivot Table" for like five minutes. I'm not optimistic

[Doctor Who]

:bump:

Crashed Excel's ugly stepsister, Access.

[campbell]

:bump:

Crashed Excel's ugly stepsister, Access.
That takes some doing.

[and I just deleted a whole bunch of stuff that was evidently TWSS bait]

[ADoubleDot]

:bump:

[Doctor Who]

:bump:

I ran Excel out of memory while moving a pivot table into another workbook.

[Lucy]

:bump:

wasn't doing anything too exciting, but had a few big workbooks open, and had excel open for a couple of days.

[ajstudies]

That takes some doing.

[and I just deleted a whole bunch of stuff that was evidently TWSS bait]

I find it easier to crash Access than Excel.

[glassjaws]

:bump: stupid machine.

[Steve Grondin]

How about Word?

:bump:

Stupid frickin memo.

[JMO]

How about Word?

:bump:

Stupid frickin memo.
I thought all actuaries wrote their memos in Excel. :dsmile:

[Cheerio]

:bump:

I'm not sure why I let Excel save auto recover information. It either doesn't work, or takes longer to recover than it would take to re-create the lost data.

[ADoubleDot]

:iatp: Turn the bugger off.

[MountainHawk]

Question: Has "Microsoft Office Excel is currently recovering your documents" ever, in the history of mankind, been a true statement?

[Lucy]

Question: Has "Microsoft Office Excel is currently recovering your documents" ever, in the history of mankind, been a true statement?Yes, it often successfully recovers my documents after a crash.

[Doctor Who]

:bump:

Excel frowns on editing VBA while code is running in Excel 2007.

:swear:

[Lucy]

Hmmm, Outlook just crashed. No idea why. I wasn't even doing anything, I'd just come back from a meeting, was reading some e-mail, looked at something on my desk, and it was down. Now it doesn't want to re-start.

[Doctor Who]

Just crashed Access while trying to paste data into it from Excel.

Lucy it takes talent to crash Outlook.

[Lucy]

:bow:

[carrytheCrøss]

bumped

I'm almost :sad:

[Brad Gile]

Question: Has "Microsoft Office Excel is currently recovering your documents" ever, in the history of mankind, been a true statement?

Absolutely. Rarely has it failed for me, though I rarely get into that predicament. In fact, over many years of Excel use, crashes have been unusual. I have, of course, found ways to crash Excel deliberately. :smile:

[SirVLCIV]

Hmmm, Outlook just crashed. No idea why. I wasn't even doing anything, I'd just come back from a meeting, was reading some e-mail, looked at something on my desk, and it was down. Now it doesn't want to re-start.

Outlook has crashed twice a week for me now. Very annoying.

In the past week, I've crashed Outlook, Word, Excel, and Access, along with our internal valuation software. I tend to have four things going at a time, and often I push the limits too far ;-)

3.16 GHz CPU with 3.23 GB RAM, so it's not the computer, it's me.

[carrytheCrøss]

Question: Has "Microsoft Office Excel is currently recovering your documents" ever, in the history of mankind, been a true statement?

Yes, it often successfully recovers my documents after a crash.

Absolutely. Rarely has it failed for me, though I rarely get into that predicament. In fact, over many years of Excel use, crashes have been unusual. I have, of course, found ways to crash Excel deliberately. :smile:Mountainhawk, you may have to wait a while (two hours and five minutes to be exact :smile:), but it can work. I let it recover last night, and found out the good news this morning.

[JMO]

(two hours and five minutes to be exact :smile:)

So that's how long it takes Maelzel's Chess Player (http://en.wikipedia.org/wiki/Maelzel's_Chess_Player) to reconstruct the spreadsheet?

[Cheerio]

:bump: ...it seems like I've been here more often lately. :(

[Cheerio]

:bump: Really? Again?!!! All I'm trying to do is add a sheet and save the stupid file!!!!

[KandaBer]

:bump:

No comment.

[KandaBer]

:bump:

I could comment, but I won't.

[MountainHawk]

Sounds like maybe I'm just too impatient with it. After about 10-15 minutes, I get annoyed and just reboot assuming that it's not going to do it.

[SirVLCIV]

Sounds like maybe I'm just too impatient with it. After about 10-15 minutes, I get annoyed and just reboot assuming that it's not going to do it.

Heh. By the end of a project from last September-this January, we had a spreadsheet that took 20 minutes to calculate. Recursive array formulas with 40,000 rows by 78 columns of data will do that....

We're currently working on speeding up calculation time, since we'll probably have the same project this year.

[MountainHawk]

Heh. By the end of a project from last September-this January, we had a spreadsheet that took 20 minutes to calculate. Recursive array formulas with 40,000 rows by 78 columns of data will do that....

We're currently working on speeding up calculation time, since we'll probably have the same project this year.
I meant the recovery part. Calculation is somewhat obvious if it's still working or not.

The longest calculating one I had was something that created a pivottable from an Access database with 2.5M records, then did thousands of calculations to create exhibits. If you wanted to see a different state or line of business, you changed it in the pivottable, hit F9 and went to lunch or home.

[IMP]

:bump:

i'm impressed that it's been this long since it's crashed. :lol:

[Doctor Who]

:bump:

I was only using an Autofilter :shrug:

[SirVLCIV]

:bump: once.
:bump: twice.
:bump: three times.
:bump: four times.
:bump: five times.

Ugh. Ok, I have one sheet, 45,000 rows, up to column DL, but I'm really not doing anything really intensive (no array formulas or anything). Everytime I had a new column, it's breaking while calculating. Ugh.

[limabeanactuary]

Do you have it on automatic recalculation?

[SirVLCIV]

Do you have it on automatic recalculation?

This time, yes (I pulled data from a massive spreadsheet to do some calcs in a minor spreadsheet) but I'm shutting it off now.

[limabeanactuary]

This time, yes (I pulled data from a massive spreadsheet to do some calcs in a minor spreadsheet) but I'm shutting it off now.

Uh, yeah.

When I'm dealing with large spreadsheets, I always turn off automatic calculation.

[ADoubleDot]

(Not Responding) Why didn't I save??? :crying:

[ADoubleDot]

Whew. Came back.

Save save save

[Nobody22]

:bump: Froze. :bunny:
:bump: x2. Some issue with multiple programs, and 2003<->2007 conversions, auto-saving...:sigh:

[IMP]

:bump:

sweet brand new computer can't handle a couple of small excel files at once. AWESOME!!!

[Nobody22]

:bump: "Code execution has been interrupted" (http://ask.metafilter.com/112071/Code-Execution-has-been-interrupted) error, which occurs randomly. Had to re-boot to re-instate excels integrity.

I can't get too mad since excel works wonders under normal circumstances... but it's bad when you realize if excel decides to die... things won't get done.

[Nobody22]

:bump:

Lots of links to outside files.

2003 > 2007

"Microsoft Office Excel is recovering your documents"Don't lose them in the first place!

[SirVLCIV]

Not really a crash this time, but I tested the limits of my processor to handle multiple Excel instances, and lost. My fault for running one 10 minute macro in one instance and starting a 15 minute calculation in another, while working in a third. Eek.

Luckily, the calculation wasn't far along (and I saved beforehand), and the spreadsheet running macro (which was almost done) still worked.

[Ginormous76]

:bump:

:swear: Stupid Excel.

[Ginormous76]

AHHHHHHHHHHHHHHH!!!!

:bump: again! Already!

[Nobody22]

:bump:
2007 ¿upgrade? :redcard: THIS IS WORSE!

[ADoubleDot]

:bump::swear:

[ADoubleDot]

Is there a way to find external references?

[Ginormous76]

Is there a way to find external references?

Yes, give me just a second to remember.

[Ginormous76]

Edit -> Links

[SirVLCIV]

Edit -> Links

Doesn't work well if the links are in range names.

I usually do two things; 1) search all formulas in workbook for ".xls", then 2) check all range names.

[MountainHawk]

Doesn't work well if the links are in range names.

I usually do two things; 1) search all formulas in workbook for ".xls", then 2) check all range names.
What if someone named their sheets 'Data.xls', 'Exhibit.xls', etc.

[ADoubleDot]

Edit -> Links

:toast: Thanks!

[ADoubleDot]

Doesn't work well if the links are in range names.

I usually do two things; 1) search all formulas in workbook for ".xls", then 2) check all range names.

People do the bolded?? Thats a firable offense to me ;)

The first numbered solution is a good idea.

[KandaBer]

People do the bolded?? Thats a firable offense to me ;)

Links in range names can happen accidently, in copying tabs from file to file.

I agree that they are worse than regular links.

[SirVLCIV]

People do the bolded?? Thats a firable offense to me ;)

The first numbered solution is a good idea.

Links in range names can happen accidently, in copying tabs from file to file.

I agree that they are worse than regular links.

Agreed - it's usually not on purpose. I've had it happen when copying tabs to another spreadsheet (but I now make it a habit to save, exit, reopen, kill the links).

[SirVLCIV]

What if someone named their sheets 'Data.xls', 'Exhibit.xls', etc.

Rename them! ;-)

[SirVLCIV]

I've been having this issue lately in one of my massive workbooks: http://www.mrexcel.com/forum/showthread.php?t=337885

http://docs.google.com/File?id=dm2gjff_33f9f34cd8_b (not my workbook, but the guy in the link's).

Seems to be a repainting issue when using ScreenUpdating = False at the beginning of code then = True at the end (this is a 5 minute macro with a lot of moving parts). Ugh.

[Bobby]

I was getting this error on a workbook about "invalid references" the other day but I had checked everything I couldn't find any. Finally, I had Excel crash recently while I was in the middle of writing a large macro on this sheet. When it "recovered" the file, it gave me the file without any macros, any formatting, or any formulas. Luckily I had multiple versions saved, but I lost about three hours of work.

After that initial crash though, I kept on getting the same thing with other versions of my file. I lost about 30 mins of work at a time. It was really frustrating.

I searched the internet and found that the solution for the "invalid references" warning was supposed to be to fix external links. I went to Edit -> Links and removed all the external links to other spreadsheets, but it wouldn't delete one of them (even though I kept clicking the button to delete it.)

The solution that finally worked was saving the file as an .htm file and resaving the file as an .xls. I'm still not sure what was going on there, but the worksheet doesn't crash anymore.

[IMP]

SON OF A MONKEY'S UNCLE!!!!!!!!!!!!!!!

[IMP]

finally just now finished recovering documents. :sigh:

[Nobody22]

:bump: All I wanted to do was save... :wall:

[ADoubleDot]

:bump: I never learn!! :hsmack:

[chicken_po_boy]

:bump:

I was only re-sizing a chart, and Excel quit on me. Grrr....

[ADoubleDot]

:crying:

Why has Bill Gates forsaken me??!!!

[Doctor Who]

:crying:

Why has Bill Gates forsaken me??!!!

He just did the same thing to me. Shame on me for refreshing a pivot table :shake:

[ADoubleDot]

Microsoft Office is currently recovering your documents.

Why does this take so long?

[JMO]

Microsoft Office is currently recovering your documents.

Why does this take so long?
Because they are dumpster diving, and you know how long it takes to separate out the part you meant to keep.

OK, actually I have no idea. Why does it take windows so long to close down after it has "saved your settings"??

:shrug:

[Doctor Who]

:bump:

How dare I try to use ctrl+z to undo something!

[JMO]

:bump:

How dare I try to use ctrl+z to undo something!
Using the undo icon instead doesn't work any better, though.

[Doctor Who]

This time I just opened a file.

:(

[F-9]

This time I just opened a file.

:(

Ditto. :redcard:

[Doctor Who]

Although it hasn't crashed yet, I'm looking at the properties of my file and Excel tells me 1.6MB = 1,112,593 bytes.

:shake:

[whisper]

:bump:

grrr!!!!

[Brad Gile]

Because they are dumpster diving, and you know how long it takes to separate out the part you meant to keep.

OK, actually I have no idea. Why does it take windows so long to close down after it has "saved your settings"??

:shrug:

That seems to be history. Doesn't ever seem to happen in Windows 7. I was always baffled how variable the "time to save settings" took. Yes, it was very irritating to say the least. I am very happy with Windows 7, though Thunderbird 3 has problems with Win 7.

[Nobody22]

:bump: crashed while saving... interestingly enough one worksheet now looks like a word document, but still appears to have cells... :-?

[whisper]

interestingly enough one worksheet now looks like a word document, but still appears to have cells... :-?

:-?

Did the gridlines just get turned off?

[Nobody22]

As it turns out, it just switched a tab to (in 2007) view>page layout. So an easy fix... but bizarre (and a layout I'm obviously unfamiliar with).

Why would it convert the layout to save?

[ADoubleDot]

:bump: Copy/paste as values = No soup for you

[JMO]

Can I borrow this thread to bump when my wonderful new IE8 decides to lock up?
I opened a new tab and selected AAA from my favorites list.

:meltdown:

[Nobody22]

That reminds me of this code I ran across recently:
Sub Auto_Open()
'^ = Control, % = Alt, + = Shift
Application.OnKey "^+v", "CopyPasteValues"
End Sub

Sub CopyPasteValues()
If TypeName(Selection) = "Range" Then
'Selection.Copy
Selection.PasteSpecial xlPasteValues
Application.CutCopyMode = False
End If
End Sub

[Nobody22]

Caught in a loop of recalculating, recalculating, recalculating, recalculating...

[ADoubleDot]

Can I borrow this thread to bump when my wonderful new IE8 decides to lock up?
I opened a new tab and selected AAA from my favorites list.

:meltdown:

http://verydemotivational.files.wordpress.com/2010/09/7bb54014-25e9-47c1-8d64-f28470d34c96.jpg

Sent from my DROIDX using Tapatalk

[limabeanactuary]

:bump:

GRAAAAAAAAAAAAAAAAH

[Rake]

FURIOUS :bump:

[ADoubleDot]

Worst. Macro. Ever.

[yoyo]

who knew that File, Open was such a risky operation?

[yoyo]

sonofabiotch!

[Rake]

$#&*!!!

[yoyo]

motherfracker!

[ADoubleDot]

Dude, you're having a bad week. Close some programs!

[yoyo]

Dude, you're having a bad week. Close some programs!something ain't right. i restart my machine every day and i'm not one to have lots of progarms or files open at the same time.

[IMP]

:exams:

man this is nasty. :cry:

[yoyo]

ran the office repair feature and no crashes since :shrug:

[JMO]

OK, not quite a crash, but saving to the network is so slow I expect it to crash.

[White Castle]

:bump:

[MountainHawk]

Microsoft Excel is currently recovering your documents.


You better be, you stupid .... .sfhsdjlfhsdfsd

[IMP]

:bump:

didn't lose much if anything but PITA!!!!

[F-9]

:bump: Because, unhiding rows will cause a VBA error. That makes perfect sense. :wall:

[yoyo]

:swear:

[yoyo]

sonofab!otch

[yoyo]

POS

[MountainHawk]

Dividing by 1000 is not good.

[Doctor Who]

:bump:

How dare I run a macro after saving the file.

[JMO]

:bump:

How dare I run a macro after saving the file.
Be glad you didn't run before saving. . .

[yoyo]

:swear:

how dare i file, open

[Doctor Who]

Be glad you didn't run before saving. . .

Been there, done that. Learned the hard way.

[Doctor Who]

:bump:

I unhid a worksheet.

:shake:

[yoyo]

:bump:

WTF is wrong with my system?! I might have the most crashes in this thread.

Be careful with File, Open. It's kinda' buggy.

[JMO]

May I borrow this thread for a minute? I want to bump because MS Outlook crashed. It sometimes does this when I want to change to a different printer.
<sigh>

[Doctor Who]

:bump: I owe one from yesterday.

[Doctor Who]

pre-emptive :bump: since it is taking forever to save.

[yoyo]

my IT guy deleted the excel.exe and let the network rebuild it, or whatever the lingo is. working well so far.

[Doctor Who]

:bump:

I pasted special formats on 6 cells.

:shake:

[Doctor Who]

:bump:

I accidentally hit F1.

:shake2:

[limabeanactuary]

That's what you get for beating me in RPS.

[John Connor]

:bump:

I pasted special formats on 6 cells.

:shake:

this happens to me all the time

and bolding too

bold

damn you bold

bold

[strategygamer]

:bump:

I accidentally hit F1.

:shake2:

The way to get around that is to make the F1 key in excel do nothing (instead of the help menu).

In your personal.xls file, under the ThisWorkbook area, put this code in.

Private Sub workbook_open()
Application.OnKey "{F1}", ""
End Sub


Oh, and :bump:.
IA spreadsheet takes 30 seconds to calc, and is on automatic calculation. Thanks SOA!

[ActuarialBAMF]

I had to run the IA spreadsheet through citrix at work so it was managable.

[ActuarialBAMF]

I remember one of the spreadsheets had a macro that turned your calculations to 'automatic' whenever the spreadsheet was opened...i think that was one of the eom's

[ADoubleDot]

I the process of typing =column(), my entire computer froze and i had to do a hadr reset. I lost 4-5 productive hours of work :tup:

I got to =c

[Doctor Who]

That's what you get for beating me in RPS.

I was going to crash Excel anyway.

[Doctor Who]

I the process of typing =column(), my entire computer froze and i had to do a hadr reset. I lost 4-5 productive hours of work :tup:

I got to =c

Save early and save often.

[Jables]

I lost 4-5 productive hours of work :tup:

Job security!

[ADoubleDot]

Save early and save often.
I didn't lost any excel work, I save like a crazy person. I'm like Google Docs.

I lost 4-5 hours of SAS jobs processing cause Excel killed my whole computer. No way to save that.

[JMO]

Save early and save often.
:iatp:

ETA - LOL. It was the impact of Excel crash on other jobs that caused the productivity loss. Saving was NOT the solution. But I still approve of that post.

[Gedankenexperiment]

:bump: :bump: :bump: :bump:
Excel's been crash city for me lately. Which is bad because I have a deadline to make and a vacation to go on.

Save early and save often.
I'm copying and pasting large chunks. I tried breaking it into smaller chunks, but, apparently excel saves all the smaller steps for when I hit control-z, basically making the smaller steps irrelevant. Saving, thankfully, discards them, though takes forever. So yeah, SAVE!

An alternative, weirder trick, I just found? Is that there seems to be a fairly small copy-and-paste sweet spot between "Continue without undo?" and "Excel cannot complete this task with available resources." If you hit that, then you can go forever.

edit: There's also a way of changing the number of undo-steps saved in the registry, apparently, but obviously that's not something you want to fiddle with often.

[yoyo]

my IT guy deleted the excel.exe and then let the network replace it. i think i've been crash free since then

[whisper]

:swear::swear::swear::swear::swear::swear::swear:

POS software

[Doctor Who]

:taz:

I deleted two worksheets and attempted to undo the deletion.

[Doctor Who]

:bump:

Macro attempted to delete cell contents.

[limabeanactuary]

Dagnabbit.

Trying to save a backup copy of a spreadsheet I need to work on this weekend.

[Doctor Who]

:taz:

[Doctor Who]

:swear:

[hellomath]

:swear:

POS. Where are my changes I just made?

[whisper]

:swear::swear::swear::swear::swear::swear::swear:: swear:

Yippee - let's see how much work I lost....

[yoyo]

SON
OF
A
:swear:

[Gedankenexperiment]

:x

[Gedankenexperiment]

Bump!

What I learned today is that running a huge Excel file is like lifting a huge piece of furniture. Of course it's slow going and awful, and of course you can't lift anything else at the same time-- but you also can't do simple things-- like open your front door or walk it up some steps without dropping it on the cat.

[limabeanactuary]

:bump:

:taz:

seriously, just trying to save....

[limabeanactuary]

...and excel is choking on the "document recovery" step.

i think i have to put it out of its misery....

[limabeanactuary]

sonofabitch i did it again

[F-9]

Why, oh WHY, did I decide to update links? :(

[JMO]

Why, oh WHY, did I decide to update links? :(
You've heard it before. Links are evil. :danim:

[yoyo]

my IT guys deleted my excel.exe file and then let the network rebuild it. excel was well behaved for a good while after that. has crashed some lately though

[Doctor Who]

You've heard it before. Links are evil. :danim:

Not this one :link:

Also, :bump:. Just crashed it again opening a workbook.

[limabeanactuary]

=sigh= Will it crash? Who knows? I've got to sit here for 10 minutes to wait on this add-in to see if it will.....

[yoyo]

=sigh= Will it crash? Who knows? I've got to sit here for 10 minutes to wait on this add-in to see if it will.....the 10 mins are up. what happened?

[limabeanactuary]

It didn't crash.

That time.

[SirVLCIV]

Four times this week. And I'm not doing anything particularly intensive.

[MountainHawk]

Four times this week. And I'm not doing anything particularly intensive.
Excel knows when you are slacking. ;-)

[Dan Moore]

A few weeks ago, I lost many sheets from a large workbook because part of the workbook became corrupt and Excel had to repair it.

Today, I tried to load a pretty big workbook with just 4 sheets & Excel told me it was corrupt & unreadable. I had some other workbooks open at the time. I closed the open workbooks & tried opening the 'unreadable' workbook again - lo & behold, it opened. I saved an extra copy.

[Brad Gile]

Excel knows when you are slacking. ;-)

Yup. Inanimate objects...aren't! :)

[limabeanactuary]

dammit

[whisper]

Oh, you worthless POS...

[whisper]

Oh, you worthless POS...

Oohh - let's double up.

At least this time I only lost 5 minutes of work...

[whisper]

Oohh - let's double up.

At least this time I only lost 5 minutes of work...

Hey look - another crash!

[Brad Gile]

Hey look - another crash!

You should have doubled DOWN, not UP! :tup:

[Doctor Who]

:shake:

Opening a workbook? Come on!

[yoyo]

Nice. This is what I need when closing the quarter.

[Doctor Who]

:taz:

[limabeanactuary]

:bump:
Son of a motherless goat!

[limabeanactuary]

:taz: WHY ARE YOU RECALCULATING?! I PUT YOU ON MANUAL! :taz:

[Brad Gile]

:taz: WHY ARE YOU RECALCULATING?! I PUT YOU ON MANUAL! :taz:[Brad

Because it loves you! [Brad streaks for the nearest exit.] :)

[limabeanactuary]

Turns out it was some "helpful" VBA code someone else wrote.

I commented out the "Calculate" line

[limabeanactuary]

SON OF A BITCH! IT'S FRIGGING RECALCULATING!

(GRAAAAAAAAAAAAAAAAAAAAAAH)

I swear I'm going to punch a hole in the wall. Unfortunately, this recalculate is thanks to an add-in I have to use to get this thing done.

[limabeanactuary]

And that was a very hard crash.

DAMMIT

[limabeanactuary]

Oh great... it's hung up on "Recovering your documents"

So now I gotta open up Task Manager and kill the process.

[Brad Gile]

Turns out it was some "helpful" VBA code someone else wrote.

I commented out the "Calculate" line

Snort! :)

[Brad Gile]

SON OF A BITCH! IT'S FRIGGING RECALCULATING!

(GRAAAAAAAAAAAAAAAAAAAAAAH)

I swear I'm going to punch a hole in the wall. Unfortunately, this recalculate is thanks to an add-in I have to use to get this thing done.

That DOES suck! :(

[limabeanactuary]

The good thing is that it's calling "Calculate" only half as frequently now.

It used to be that I'd run the add-in - it would calculate - and then run a different macro - and it would calculate again.

Anyway, it's not been crashing since I made the change. But it's slow as hell.

[Brad Gile]

The good thing is that it's calling "Calculate" only half as frequently now.

It used to be that I'd run the add-in - it would calculate - and then run a different macro - and it would calculate again.

Anyway, it's not been crashing since I made the change. But it's slow as hell.

Gives you more time to post here on the AO, no? :)

[limabeanactuary]

That's pretty much what I was doing.

Enough pulling data for today. I'll finish it up tomorrow morning.

[limabeanactuary]

=very heavy sigh=

[ADoubleDot]

I overwrote some data that I can't get back. My system is crashing (not my computer, my mind)