Solved

latest windows update causes error in excel code

Posted on 2014-12-29
7
69 Views
Last Modified: 2015-01-06
I have a LOT of formulas for a number of different spreadsheets that work fine but when I allow the latest Windows update I get errors when I try to run the macros which then disappear when I go back to a previous restore point.

I would think that I'm going to have to update sooner or later but need help in correcting the code that the windows update causes to fail.

If you need to know the error, which I imagine you will, I will have to run the update.
0
Comment
Question by:mabehr
  • 3
  • 3
7 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 40523162
Find', backup, and delete your EXD files.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40523168
I'm sorry but my answer was for active problems but as long as you backup the files you could try it anyhow.
0
 

Author Comment

by:mabehr
ID: 40523192
are you saying to do a search for .exd files and then to delete them?
What are those?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 40523337
They are temp files - you don't need to back them up as they will be recreated automatically. There's a KB article about this issue here: https://support.microsoft.com/kb/3025036/EN-US
0
 

Author Comment

by:mabehr
ID: 40525319
ok, will do and then apply windows update and see what happens. thanks
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40525604
Don't reapply the Windows update.
0
 

Author Closing Comment

by:mabehr
ID: 40533334
Right now I'm not going to do any updates and will count this problem solved. However, I will have to update one day.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now