Form Controls stop working after December 2014 Updates (Updated March 10, 2015)

For some users, Form Controls (FM20.dll) are no longer working as expected after installing MS14-082 Microsoft Office Security Updates for December 2014. Issues are experienced at times such as when they open files with existing VBA projects using forms controls, try to insert a forms control in to a new worksheet or run third party software that may…


Your changes could not be saved to ‘filename.xlsm’ because of a sharing violation. Try saving to a different file.

Guest Blogger:  Dustin Yonker It has come to our attention of a potentially new issue where users receive one or multiple error messages during the save process of Excel files with macros.  All reported cases have been .xlsm file extensions and the errors mention a “sharing violation.”  If you are being impacted by this, we…


Blocked access to files with Windows 10

This is not new. But after upgrading to Windows 10 from Windows 8.1, I found that when trying to unzip a compressed folder that contained an executable file (.exe) and sent to me from a trusted source, I was presented the error below and the executable could not be unzipped and run. <Insert a frustrated "What?!?!"…

4

ODBC drivers that are compatible with Excel for Mac 2011 and 2016

Using Excel for MAC and experiencing an error similar to below?  You may need to install the specific components needed to successfully connect.  Message examples:       No ODBC driver is installed.      To refresh a query, you must first install the appropriate ODBC driver for this version of Excel on your computer.       Microsoft Excel cannot…

1

Office documents may error when opened after a Windows 10 upgrade

If you have upgraded from Windows 7 to Windows 10, you may find that some of your Office 2013 documents result in errors when you try to open them in protected view using a Click-to-Run install of Office.  Protected View can occur when opening files from locations that may pose a threat such as Outlook or the…


Excel 2013 32-bit Performance Articles Released

After you upgrade to Microsoft Office 2013, you experience one or more of the following symptoms: The computer uses more memory when you open multiple Microsoft Excel 2013 files, save Excel files, or make calculations in Excel workbooks. You can no longer open as many Excel workbooks in the same instance as you could before…


Excel hidden dialogs resolved with Dynamics CRM 2013 Update Rollup 3

Previously, I had written about an issue we were experiencing in Excel where the Excel application would appear to be hung and dialogs were not coming to the front as expected after using the Save and Send as attachment feature. http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/04/26/hidden-dialogs-cause-excel-2010-to-appear-to-hang.aspx Since that time, the Microsoft Dynamics CRM team has helped to resolve this issue…


Form Controls are no longer supported outside of Microsoft Office

After installing the March 2015 updates for Office 2007, Office 2010 or Office 2013, form controls (fm20.dll) are no longer available for use in Internet Explorer or custom compiled applications that obey IE security settings regarding ActiveX control trust. You may see errors in the custom applications or that the controls do not load in the web…

0

Dynamics CRM files do not open in Excel 2013 as expected

If an Excel workbook in XML Spreadsheet format (*.xml) is stored as a UTF-16 Unicode text stream, you may have problems opening it in the expected program when trying to open it through Windows Explorer or Windows Internet Explorer. This problem can occur if you have Office 2013 or an Office 2013 component installed. Example…

3

Excel 2013 error connecting to .bism files "The handle is invalid"

After applying May 2014 Cumulative updates for Office 2013 Click-to-Run, an error occurs when refreshing an existing workbook data connection to a .bism file and/or when creating a new connection using a .bism file.   The message received is:  "The following System Error occurred: The handle is invalid"       Note:  This has been found to occur only with Click-to-Run Office 2013 WORKAROUND: Connect…

2