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
Connect to the data source directly without using the .bism connection file.
STATUS (updated October 2014):
This issue was resolved in the October 2014 updates for Office 2013 Click-to-Run. To resolve the issue, apply the current Click-to-Run updates available.
More information on updating: http://support2.microsoft.com/gp/office-2013-click-to-run
After applying the updates, "About Excel" information in Account shows the build has been updated to: 15.0.4659.1000 MSO 15.0.4659.1001
Additionally, your msolap110.dll version is now: 11.0.2814.8
Example 32-bit Location: C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll >>> Properties >>> Details
"The handle is invalid" error in Excel 2013 when you import data by using a BISM file