Does this crash your Excel?

Off Topic
1

Warning… Please save your work in all Office apps if you want to proceed any further!

Just curious. Our IT does weird stuff with our computers. Wondering if this is a real Excel bug or if it’s just something related to how our work computers are set up. Other users here have the same issue.

There’s nothing in this sheet but a single shape and a Form button that are grouped. There’s no code, and the button doesn’t do anything. It’s not even a macro-enabled workbook.

Trying to copy any worksheet cell (plain ol’ Ctrl+C) that is overlapped by this group results in Excel hanging for about 30s and then crashing to desktop. I think it may also be crashing some core components of Office because my Outlook complained that I exited without closing my mail file. I’ve never seen that message before today right when I started messing with this.

Same for you?

GroupingCrash.xlsx (12.4 KB)

2

I get a crash, but it takes about 5 seconds. Only Excel crashed, not my Outlook.

2 Likes
3

Thanks for checking it out!

I didn’t get an actual Outlook crash… It never closed, I just got a notification in my system tray that it had been closed. And when I looked at my calendar, it displayed a message that Outlook had been closed improperly rather than showing my calendar.

1 Like
4

The Form seems to be triggering it as deleting the form makes the copy-paste ‘work’ (doesn’t really do anything, just doesn’t crash)

I didn’t get any report either, it’s like an insta-close and reopen with the Excel recovery window

Could it be caused by the fact that the grouping was done programatically(I’m guessing), as I’m not able to group a form and a button?

5

It wasn’t done programmatically. I just dropped in a shape, then a button using this command

image
image348×334 11.7 KB

Selected both, right-click, and group. Are you able to un-group the ones in this file? If so, can you re-group?

6

Looks like grouping a shape with any of the objects on that “Form Controls” menu causes this crash. Even a “Label” control, which is pretty much just text.

1 Like
7

Does this help:

Go to File \ Options. Select the “Advanced” tab. Go to the “Cut, copy, and paste” section. Uncheck “Show Paste Options button when content is pasted” and “Show Insert Options buttons”

1 Like
8

I went ahead and un-checked all of those. No change.

image
image373×226 2.46 KB

It seems to be related to Excel’s interaction with the clipboard itself. While Excel is in the process of crashing, I can’t copy/paste other stuff.

9

I can copy any of the overlapping cells with no crashing.

Software version is Microsoft® Excel® for Microsoft 365 MSO (Version 2506 Build 16.0.18925.20076) 64-bit for what it’s worth.

10

Interesting… Looks like you’re a bit later than me. Not surprised about that tho.

image

11

My Excel says it is up to date, but it is build 2505.

image

12

This thread is impressive. When MS needs expert level trouble shooters they go to SW (or probably any base level 3D modeling system) users. Nice.

1 Like
13

Additional data points:

  • If you haven’t shown the clipboard in the current Excel session, the crash doesn’t happen.

  • If you have the clipboard hidden and CTRL-C a cell and then show the clipboard it crashes.

image

and

Microsoft® Excel® for Microsoft 365 MSO (Version 2506 Build 16.0.18925.20076) 32-bit

14

Interesting… I’ve never shown the clipboard. I’d have to google how to do it if I wanted to… :smiley:

I suppose I should learn how because I’m sure it would be handy at times.

1 Like
15

image
image265×217 5.42 KB

2 Likes
16

I like using Window key + V for clipboard history, system wide. I’ve never shown the cb in office apps

2 Likes