Troubleshooting

Error message: UserForm_Initialize - - 2147467259 Automation error Unspecified error Unspecified or Miscellaneous Errors Description: When attempting to use a Diligent connected Excel cube file, the user will unexpectedly encounter similar Microsoft errors as seen above. The causes are usually...

Error message: No error message. In Excel, the ribbon at the top will be blank. Excel Ribbon is Blank or Missing Description: This can be caused by the machine having recently been updated to a different version of Microsoft 365. Solution: Enable "Optimize for compatibility" in Excel. To do so, ...

Error message: Operation cancelled by user. Error when attempting to change a filter setting in a row or column Description: Can sometimes occur when attempting to manipulate a filter field in a cube or pivot table. The effect will manifest in attempting to add or remove a specific field that wi...

Error message: Either a connection cannot be made to the server or Analysis Services is not running on the computer specified. Server Access Error Description: This error is caused by an access issue or link issue between the system and the cube attempting to open. Solution: Restart the computer.

Error message: Analysis Services Connection 14.0 - This wizard will help you connect to a Analysis Services data source. File Refresh Issue - Analysis Server Login Wizard Description: When attempting to use a Diligent connected Excel cube file, the user will unexpectedly encounter similar Micros...

Error message: XML for Analysis parser: The 'xxx' session ID cannot be found. Either the session does not exist or it has already expired. Session ID Cannot Be Found Error Description: This message occurs if the user session expires or if a cube structure change has been applied. A new session o...

Error message: Upload Failed: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document. Invalid Hyperlink in Cube File Description: You'll experience an error message when attempting to run a file through the Cube Updater: "Upload Failed: A malformed URI was found in the docum...

Error message: Data shows up in the Excel cube file that doesn't exist in Diligent. Where is this data coming from? Cube showing non-existent data Description: Users will unexpectedly see data that doesn't exist in Excel cube files within a pivot table. This data can't be vetted elsewhere, such ...

Error message: An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vend...

Error message: EBM login dialog window stops halfway and never fully loads. Initial Login Window Halts Halfway Description: When opening a Cube file (e.g. EBMOfficeBridge.xlsm) the initial login window progress bar stops halfway and will never complete. Indicative of an Internet Explorer event, ...

Error message: No error message. The EBM Office Bridge interface will appear blank. Empty Office Bridge Interface Description: This can happen when attempting to open a new cube file and not being prompted to log in immediately. Upon attempting to Enable Content (or Macros), the EBM Office Bridg...

Error message: Either Excel will spin and eventually timeout and shutdown or it will require a new login through a Microsoft SharePoint dialog login window.  SharePoint Login Window Required After Refreshing Cube Description: Occurs after opening up an Excel file and attempting to click the "Ref...

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. Message from webpage timeout error Description: This is a communication issue between the browser and ...

Error message: When uploading from Excel, the subsequent Diligent dialog window is missing processing/validation options or indicators.  Diligent File Upload Window is Missing Validate/Process Button Description: When attempting to upload data into Diligent from Excel using the EBM Office Bri...

Error message: Microsoft Visual Basic for Applications File not found ____ MS VBA Missing File Error Description: This issue can happen when an EBM Office Bridge file (e.g. Cube) is opened and can be caused by an Excel application crash while the file was in the process of opening. The technical...

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: 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: 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 Description: You'll experience an error message when attempting to run a file through the ...

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: 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: 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: This PivotTable report is invalid. Try refreshing the data (On the Analyze tab, click Refresh). Invalid PivotTable Report Error Description: This error occurs because of hierarchy changes.  Solution: Please run "Refresh all Cubes" under the EBM Office Bridge tab in the MS Ribbon.  

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...