Freigeben über

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

  • Artikel

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 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: https://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
https://support.microsoft.com/kb/3009669

Comments

  • Anonymous
    January 01, 2003
    nice job
  • Anonymous
    July 08, 2014
    Thanks for sharing this information it was very helpful.
    MA Subhan
    www.upskilltechnologies.com