Troubleshooting

Error message: The file originated from an untrusted location and might be unsafe. [AND] MS Office has timed out while receiving or sending data, please close the window and attempt the operation again. HP Sure Click Untrusted Location Description: This will occur after attempting to open a new ...

Error message: A problem with this webpage caused Internet Explorer to close and reopen the tab. Internet Explorer Crashes Description: MS Office Bridge files communicate using Internet Explorer. Occasionally users will experience an issue where after logging into the cube IE crashes. This can b...

Error message: This PivotTable was created in a later version of Excel and can't be updated in this version. To update it, click OK, and then open the workbook in the version of Excel it was originally created in.  User Credential Issues Description: This error occurs, likely because the user ha...

Error message: We couldn't get data from an external data source. Please try again later. If the problem persists, please contact the administrator for the external data source. Here is the error message that was returned from the Analysis Server named https://ebmcatalyst.com/olap/msmdpump.dll: E...

Error Message: Anything related to Microsoft Excel Macros. Note: As of 2022, Microsoft will begin to harden security for Macro Enabled documents and Trusted Locations, eventually sunsetting Macros entirely. Check out these instructions to stay ahead of this. Enabling Macros To work correctly, EBM...

Error message: Upload Failed: A malformed URI was found in the document. Please provide a OpenSettings.RelationshipErrorRewriter to handle these errors while opening a package. Malformed URI in document Issue: Malformed URI in Document Description Encountering an error message during Cube Upd...

Error message: Microsoft Visual Basic code execution has been interrupted. Unknown Visual Basic for Application Error Description: This error is a common and unknown error with Microsoft Visual Basic for Applications.  Solution: To resolve this issue, click the Debug button, then press Ctrl + Pa...

Error Message: Microsoft Visual Basic Run-time error 2147... The operation timed out. File upload error - Operation Times Out Description: When attempting to upload to EBM from Excel, the operation times out and eventually produces an error similar to the above screenshot: Microsoft Visual Basic...

Error message: No error message. You'll see text missing from the Measures section in the PivotTable where it should read "Activity". You may also have luck following the steps in the adjacent help site article here.  "Activity" Text Missing from PivotTable - Measures Section Description: This h...

As great as Microsoft Excel is and has been for all of us, we all know it can also create some unique frustrations. One of its issues is its ability to maintain network connections to its files over stretches of time. Files become stale and eventually lose connection. If this has happened to you,...

Error message: No message. Noticed when a field in the PivotTable options isn't present when it should be. Usually a Hierarchy. You may also have luck following the steps in the adjacent help site article here.  Missing fields in the PivotTable Description: May occur after making a change to a H...

Error message: Can't find project or library. Cannot run the macro 'GetVisibleEBMDataTools'. The macro may not be available in this workbook or all macros may be disabled.  Can't Find Project or Library Description: May occur when opening a cube or reloading all cubes via the EBM Office Bridge o...

Error message: MS Office has timed out while receiving or sending data, please close the window and attempt the operation again. If the issue persists, please contact your system administrator. Timeout error when uploading via Excel EBM Office Bridge Description: May occur when attempting to upl...

Error message: We couldn't get data from an external data source. Please try again later. If the problem persists, please contact the administrator for the external data source. Here is the error message that was returned from the Analysis Server named ____. The following system error occurred: T...

Error message: Excel cannot find OLAP cube. Either the OLAP database has been changed or you don't have permissions to connect to the cube. Consult your database administrator. OLAP / Macros / Enable Content Error Description: In order for the EBM Office Bridge file to correctly prompt the user ...

Error message: Microsoft Excel is waiting for " to complete an OLE action. Microsoft Excel waiting for an OLE action Catalyst not responding when refreshing cube Description: You may see these issues after attempting to refresh your Excel Cube file, either via the EBM Office Bridge ribbon or in...

Error message: Errors in the OLE DB provider. An error occurred while loading the connection dialog box component for prompting. Analysis Server OLE DB Provider Error Description: This error is a bit misleading, as the issue is not the OLE DB Provider, but instead is related to the Excel 20** Se...

Error message: We couldn't get data from the external source. Here's the error message we got: Memory error: Allocation failure - Not enough storage is available to process this command. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of...

Error message: IE or Edge based error message - This page can't be displayed. Internet Explorer or Microsoft Edge Error Message Description:  May occur after opening up your Catalyst enabled Excel cube file after submitting through the login dialog window. Once logged in, the dialog window wi...

This article aims to address common permissions-related issues encountered with data cube files. Sometimes, apparent EBM-related permission issues may have alternative origins, underscoring the need for thorough investigation. Optimize your data cube for efficient collaboration and analysis by f...

Error message: Status: BadRequest (400). Response: {"error":{"code":"InvalidRequest","message":"Invalid effective username provided"}}. RequestID: 6d500a41-a6f6-4e56-9964-a418da1af2f1. Power BI - Embed Report Error Description: A user may encounter an error message after attempting to click on a...

Error message: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Transaction deadlocked due to another process running simultaneously Description: This may present when attempting to upload data in Excel or via th...

If you are encountering repeated login prompts when accessing EBM cubes in Excel, this guide will help you troubleshoot common causes. In most cases, this issue is related to Excel updates, how Microsoft handles authentication tokens, or to internal IT configurations. When the token granted upon...

This guide provides steps to resolve the "not a valid short file name" error when installing the EBM Office Bridge Plugin for Excel. This issue often arises when the Personal registry key is set to a network drive. Steps to Resolve Verify the Personal Registry Key: Open the Registry Edito...

Error message: Run-time error '1004': Initialization of the data source failed AND/OR ConfigurationComplete - 91 - Object variable or With block variable not set. Immediate error after pulling down fresh cube and logging in Description: Unable to see an actual pivot table in Microsoft Excel after...

Error message: UserForm_Initialize - 1004 Method "Save" of object "_Workbook" failed. Cube Reload Failure Description: May occur when opening a file and selecting the Refresh All Cubes option in the EBM Office Bridge ribbon. Solution: First try running the file through the Cube Updater and resta...

Error message: Frozen "Processing..." screen and/or spinning browser and blank EBM popup. Users will unexpectedly see that their browser tab with the Catalyst instance open will get stuck in a processing loop and continue to spin into perpetuity. In addition, when attempting to open the downloade...

Error Message: You have entered potentially harmful data. This application does not allow text to be enclosed in less than (<) and greater than (>) signs (e.g. <Over>).  Export Automatically Logs User Out Description: When attempting to export a Hierarchy export/upload Excel sheet, the user is a...

If you’re getting connection errors in Excel when opening or refreshing Catalyst cubes, especially messages about “remote name could not be resolved” or “WinHttpSendRequest failed,” this article will help you or your IT team identify and fix the issue. These errors are almost always local to your...

Error message: Microsoft Visual Basic for Applications Unexpected error (35010) MS VBA error when uploading from Excel Description: Users will unexpectedly see the above Microsoft Visual Basic for Applications error when attempting to upload from the EBM Office Bridge ribbon in Excel. Usually...