excel 2013, periodic crashing, macros from older versions

Dear All,
I have a series of Excel workbooks which I have developed over the years. I am currently using Excel 2013. The workbooks and their macros were first created in previous versions of Excel. I can't remember exactly which Excel2003? Excel2007? They have numerous sheets, formatting, bunch of data, formula, the usual, with supporting macros.

In 2013, when running macros, Excel 2013 completely crashes periodically. To be clear, it might work find 10 times in a run, and then crash all of a sudden, crashing completely out of Excel. Once it has crashed, if I re-enable macros on reopening the sheet (before recompiling), everything crashes again.

However, if I reopen Excel, reopen the workbook, and go to VBA, and immediately recompile before enabling macros, then things are ok and the workbook will work again for awhile.

I read the web somewhere that some unknown "junk" exists behinds the scenes in files created in previous versions of excel, and this can cause the crashing in Excel 2013. This is where I learned that the recompiling trick solves the problem (at least temporarily).

Does anyone have any tricks which can solve this problem for me once and for all?  The crashes are inconvenient, mess up my work flow, and will eventually cause me some damage (data lost, time lost, errors, etc etc).

For example, is there a 100% reliable program which could copy over everything from an old workbook to a new fresh workbook (data, formulas, formatting, macros, etc etc), without bringing any of the previous version "junk" which may be causing my crash? Or... is there some certain VBA code which was ok in old versions but known to cause crashes in new version which I could delete/change?

I known this question lacks a bit of specificity... but I am kind of floundering. Any help would be appreciated.

[I did a little more research... in VBA/Tools I unchecked the "Compile On Demand" box... I think this means it will recompile everything before it runs any macros... maybe this will solve the problem?]
tobal99zAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Try running Rob Bovey's  Code Cleaner

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
[ fanpages ]IT Services ConsultantCommented:
[I did a little more research... in VBA/Tools I unchecked the "Compile On Demand" box... I think this means it will recompile everything before it runs any macros... maybe this will solve the problem?]

Only if you make a change to the code.  The code will not be "re-compiled" (well, not quite, but that is a whole new question thread!) every time "a macro" is run.

PS. Is this still a ".xls" workbook, or have you re-saved as ('upgraded' to) a ".xlsm", or ".xlsb" file?
tobal99zAuthor Commented:
Hello... they are all ".xlsb" files...
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

tobal99zAuthor Commented:
I just cleaned them with RIBBON COMMANDER. Do you think that will help?
Roy CoxGroup Finance ManagerCommented:
I have used Rob's tool for years. I have tried various Ribbon Commander tools but not the code cleaner, I think it performs the same functions as Code Cleaner
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.