I’m kind of wanting to lobby for a gaming setup at work.
well, not the audio system, but the processing power.
but if I did have the audio system, I could REALLY enjoy opera
2 Likes
Trying to do a rate impact calculation, and I had 4 other workbooks open. Which, it really shouldn’t have been a problem - but then I remember, those other workbooks were doing calculations too.
On the flip side, this is the first time I’ve crashed out Excel in a long time.
1 Like
Not excel, but I just crashed windows explorer when I searched “content:kwijybo”. …all of a sudden black screen of death.
Preemptive 
I just copied a row of 8 columns down about 51k rows. It’s at 16% after 15 or 30 minutes.
I should ve known better.
You should stop shaving and see how long your beard is when it finishes.
1 Like
It’s at 56% now. Assuming it makes it and assuming linear progress, it looks like I’ve got just under 1/2 an hour to go. 
Ooh. 90%. 
It finished. Now let’s go add some =RAND() to really spice things up.
I am sorry. I am just not going to post that often!
1 Like
A Big 4 firm provided file had corrupted macros, so we had to get a new version. Accountables… 
1 Like
This thread is far under-bumped.
I didn’t need any of those 7 open files I was working on, now I get to re-save them all with a suffix and delete the originals and hopefully have all my work retained.
Strangely, Task Manager has been crashing a lot for me recently. Maybe I have my usage spread across too many separate programs, or there’s been a system update which made the program glitchy.
I t hasn’t yet, but I’m updating (find/replace) a slew of external links without having the destination file open.
70k+ replacements later and I live to tell about it.
Mitä me opimme tästä?
Petitioning a thread name change
No longer “Post when you crash Excel”
Instead “Post when Excel crashes for absolutely no damn reason”
2 Likes
Bump. working on an Excel file, all of a sudden, blank Excel. Other open files are fine. Just this one is blank. Go to close it, and Excel asks, “do you want to save the changes?” Um, what? The screen is the no Excel File open screen. So I do, and the file manager updates the file.
OK, so, I try to open it again, nothing.
Save and Close all Excel files. Close Excel.
Open the file. blank Excel screen shows up.
I thought I might have protected it somehow, but internet is no help. So I Google, and I quote: “blank Excel shows up when I open a file” Some accidental sequence of keys “hid” the workbook. Unhid it and voila.
Why would anyone hide a workbook? And why is it so easy to do accidentally?
One use-case that comes to mind:
- Collaborative session with some folks who are not authorized to see some privileged information of logic.
- Set up with two workbooks – one with inputs, outputs, etc. that the non-privileged folks can see and kibitz on, and the other with the sensitive data/calculations. Change values in the non-privileged workbook, the privileged workbook does its calculations, and the non-privileged workbook displays the results
- Hide the privileged workbook, to reduce the risk that the non-privileged folks will be exposed to it.
That’s not something I’ve done before…but I can imagine situations where such a tactic can be useful.
(Now, hiding worksheets with the xlVeryHidden property…that’s something I have used, usually when building tools for non-actuaries / non-Excel-nerds.)
Actually…just thought of another, probably more likely use-case for “hide this workbook quickly” functionality:
Let’s say for the sake of argument that you are running the office lottery pool, or the office fantasy football league, and you’re doing a lot of the record-keeping in Excel on your corporate computer.
Let’s also say that someone with pointy-hair who does not approve of such frivolity is making the rounds, and they stop by your desk to chat.
A keyboard shortcut would be very, very handy to have.
alt-w-h is your friend.
alt-w-u is your friend’s friend.
Which keyboard shortcut is the enemy of my enemy?