Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

Lost macro assignments in Excel 2010

All of a sudden the buttons in my Excel 2010 spreadsheets have lost their association with the underlying macros.  It's as though the buttons don't exist.  I find that I can add a new button and assign a macro.  However, I have many buttons and am wondering if anybody knows how to recover what was lost.

The only thing I can think of is that my PC needed 48 Windows updates last night, and one update or another destroyed this.  However, I've not been able to find any information online as to a fix (or to confirm the cause for that matter).

Thanks.
0
g_johnson
Asked:
g_johnson
2 Solutions
 
MacroShadowCommented:
Yes, it is an issue with a recent update. Just discovered it after banging my head against the wall for an hour.
MS published a Fixit http://support.microsoft.com/kb/3025036/EN-US
See http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx
0
 
Martin LissRetired ProgrammerCommented:
I believe that basically it comes down to deleting all your .exd files
0
 
g_johnsonAuthor Commented:
Thank you.  Deleting the .exd files worked.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now