Pretty urgent request:

buteaur

Board Regular
Joined
Mar 15, 2016
Messages
167
I have a spreadsheet that I use as a data dump to run formulas off of and the formulas are dependent on it. The spreadsheet crashes Excel every time I try to open it!!

It's only a 2,825 KB spreadsheet so I am at a total loss as to why it won't open.

I need this to do my reporting.

ANY HELP IS GREATLY APPRECIATED!!:confused:
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

CalcSux78

Well-known Member
Joined
Oct 15, 2013
Messages
1,120
Are there any macros to the workbook? If so, you can hold {Shift} while opening the document to disable.

You may also look to see if there are any shapes within any of the sheets. (Our company has a reporting system that will insert a triangle to new reports that will sometimes crash things)

Plan C: Copy the data on each sheet of the document to a new workbook.
 
Upvote 0

buteaur

Board Regular
Joined
Mar 15, 2016
Messages
167
Thank you. I was able to get it open with the shift key.

Now the macros are disabled but I need this report (by name given the other spreadsheets that feed from it) and I have to run the macro assigned.

Not sure what to do....

Thank you!
 
Upvote 0

buteaur

Board Regular
Joined
Mar 15, 2016
Messages
167
I figured it out.

I had to do some maneuvering but I got it.

I uploaded it to dropbox from my desktop. Then I downloaded it from dropbox to my desktop as a version 2. Then I opened that version blocking the macros. Then I saved as again to my desktop. I opened it allowing for macros. I moved the original version to a flash drive (just in case) and changed the new version name to the original. All spreadsheets are feeding properly and I'm back in business!

Thanks for the shift-key tip!!
 
Upvote 0

Forum statistics

Threads
1,191,371
Messages
5,986,264
Members
440,015
Latest member
knijgh

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
Top