Migrate any and all contents of a workbook to a new file

[MrsAlice]

Hello,

I have a workbook that seems to be corrupt somehow. It crashes occasionally when saving the file. The macros and sheets are fine, it is just that excel turns white, freezes up, and gives you the endless spinning blue icon and the recovery popup. Only happens on some excel versions: I have never succeeded in finding out the cause. I am planning to copy the contents of the workbooks to a new workbook, possibly eliminating a problem that is contained in the original file. I have two questions related to this problem:

1) Is this a hopeless endeavor that has zero chance of solving the problem? (I have tried the "open and repair" function)
2) If it is not hopeless: what would be the best way to go about it?

The workbook has about:

• 150 sheets
• 20 userforms
• 10 modules
• 1 class module
• 1 sheet object that contains code.
• 5mb when saved as .xlsb, about 9 when saved as .xlsm

Nearly every sheet has:

• Formatting (borders, fills, hidden rows and columns)
• Images
• Images with macros assigned
• Formulas linking to other sheets in the same workbook

There are 0 links to outside workbooks or data links to the internet. Last time I did something like this it ended up being a disaster with formulas linking to the original workbook, having to select images one by one, fixing hundreds of #ref!'s etc. Is there a smarter/less stupid way of going about this? I will take any help I can get!

Kind regards,
MrsAlice