Excel 2013 logo - www.oostdam.info  This is an article about the best way I can think of, to fix the correct working of existing
  macro's in Excel 2013 after a crash or even after installing some Office updates.
  Now, this bugged me for a while because I'm using Excel 2013 a lot. I mean really a lot!
  Not only personal, on my desktop, but also within Office 365 and on mobile devices.

  When a system has been shut down automatically for battery reasons, Blue Screen of Deads (BSoD)  or has crashed in any another way, you might see very unclear and annoying errors in your sheets and on your screen. They can be various, in a lot of ways, so I found it not useful to add an example picture in this article. But, as I told before, I use Excel 2013 a lot and you will notice it rather quickly that macro's are not working the way it should be, and you most likely are being used to...

Watch the underneath solution, it might surprise you, but it is certainly worth a try. It helped me one time, but after doing this with a few customers as well lately, I decided to write this article about it.


Okay, lets start....  First of all,..  Close all Excel files and the Excel 2013 Application as well of course.

Open your Windows Explorer and search on the OS drive (C:) to the file MSForms.exd,
which is often located at the default user TEMP folder on your operating system and the path is:

C:\Users\YOURNAME\AppData\local\Temp\Excel8.0\

Now just delete the MSForms.exd file by clicking on it and perform the Shift+Delete action.

After this, no restart is needed, just start your Excel 2013 again and a new exd temp file will be created automatically. As the macro's, are stored within your original excel files, they are not affected at all and will run and work again like you are used to.


Tip:

1.) Think about copying or synchronizing your most valued files to a backup location in your 
      personal cloud like OneDrive. It might save your day one day....



I hope this has been informative for you, and have fun, and productive working, with Microsoft Excel 2013 !


 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Ben OostdamBen Oostdam has been working with Windows systems since 1993. Worked for several companies as a system administrator, and is currently a Senior Support Engineer and a (Freelance) Trainer, for a large company in the Netherlands, specialized in Mail and and System Center Solutions.

Disclaimer: The information contained in this website/article is for general information purposes only. The information is provided as is, by Ben Oostdam and others, and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Any reliance you place on such information is therefore strictly at your own risk. In no event will we be liable for any loss or damage including without limitation, indirect or consequential loss or damage, or any loss or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website. Through this website you are sometimes able to link to other websites which are not under my control. I have no control over the nature, content and availability of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them. Every effort is made to keep the website up and running smoothly. However, I take no responsibility for, and will not be liable for, the website being temporarily unavailable due to technical issues beyond our control. All entries in these articles, are my individual opinion, or from co-writers, and they don't necessary reflect the opinion of my employer.


Tuesday the 12th, December 2017. All rights reserved.. // Oostdam WebDesign