.XLSM sheet shuts down after any changes are made

Plasmech

New Member
Joined
Oct 26, 2021
Messages
44
Office Version
  1. 365
Platform
  1. Windows
I have an .XLSM that, until this morning, worked fine.

No changes have been made to it recently.

Now, if I try to make *any* changes to it, Excel crashes and I'm back on my desktop.

Even if I simply select a cell and press Enter, Excel crashes. Any kind of "execution" whatsoever causes a crash to the desktop.

Where would I begin in troubleshooting this?

I prefer not to upload the file. If it comes down to it, though, I realize that I may have to.

Thanks for any help.

I apologize if this post is annoyingly vague.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
It sounds like your workbook may have become corrupted.
Your best bet probably would to restore a copy from the last time it was working like it was supposed to.
 
Upvote 0
Update:

I sent the file to a coworker. He had no issues using it.

I asked him to save it as a copy and send it back. The copy works fine on my PC.

Strange.
 
Upvote 0
Yeah, without seeing it, and what it is running against, it is hard to tell.
I have seen things like this happens when the data it runs against changes in a way where the code is trying to access a row or column that does not exist.

Anyway, glad you seem to have things working again.
 
Upvote 0

Forum statistics

Threads
1,215,351
Messages
6,124,445
Members
449,160
Latest member
nikijon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top