Macro enabled spreadsheet will only open in safe mode but then auto closes

PartsPig

New Member
Joined
Sep 13, 2024
Messages
9
Office Version
  1. 365
Platform
  1. Windows
I have a macro enabled spreadsheet that I have never had problems with opening before. I use this spreadsheet daily but the last time I saved and closed it 11/1/24 Friday evening at 5:29pm was the last time I was able to open the spreadsheet. Now it will only open in safe mode and pops a message that "Excel has detected that you have recovered files. These files will be opened the next time you start Excel in normal mode" so I click OK but then Excel shuts down. When I open another macro enabled spreadsheet (or any other) NOT IN SAFE MODE it then lists all the recovered files (about 20 of them for the one spreadsheet I am having issues with) but when I select one to open Excel just shuts down. Unfortunately I have no back up for his file and really need to get it back. Any suggestions?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Start Excel like you're going to create a new Workbook. Click on Open. Select your file. Before you click Open, check to see if it contains a drop-down menu. If so, drop down and click Open and Repair.
 
Upvote 0
Start Excel like you're going to create a new Workbook. Click on Open. Select your file. Before you click Open, check to see if it contains a drop-down menu. If so, drop down and click Open and Repair.
I should have mentioned that I tried that and many other things to no avail. I was able to get the data I needed by from a teammate who had made a copy last week and was able to recreate the code and formulas and so far so good. Thanks for the follow up.
 
Upvote 0

Forum statistics

Threads
1,223,406
Messages
6,171,927
Members
452,434
Latest member
NUC_N_FUTS2

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