I just got Excel 2013. I cannot figure out how to get my ActiveX buttons to work. I went to File>Options>Trust Center>Trust Center Settings... and enabled all the Macros and ActiveX selections like in Office 2010 but still cannot use the buttons. What am I missing?
ActiveX buttons in Excel 2013
-
-
-
Re: ActiveX buttons in Excel 2013
Try going into Windows Explorer and searching the C: drive for files with an extension of .EXD and deleting them. My search found 3 such files, all in the C:\Temp folder, and deleting them re-enabled my ActiveX buttons that had stopped working.
-
Re: ActiveX buttons in Excel 2013
I deleted all the *.exd files in the Temporary Folders. That was not the problem. Any suggestions?
-
Re: ActiveX buttons in Excel 2013
See this article by Rory,
-
Re: ActiveX buttons in Excel 2013
There may be .EXD elsewhere, other than the Temp folder.
This is an extract from the Microsoft Support site for this isssue ( http://support.microsoft.com/kb/3025036/EN-US )
Note The .exd files will be re-created automatically when you use the new controls the next time that you use VBA. These extender files will be under the user's profile and may also be in other locations, such as the following folders:
%appdata%\microsoft\forms
%temp%\excel8.0
%temp%\word8.0
%temp%\PPT11.0
%temp%\vbeI had the same issue and deleted all .exd files I could find, and, like you, the problem remained. I then ran the FixIt from the MS Support link and that completely resolved the issue for me.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!