Unable to set the Interactive Property of the Application Class

Unable to set the Interactive Property of the Application Class

Issue

When running a report, you are running into an error about setting the Interactive Property for the Application Class.

Symptoms

When running a Report out the following error is received:


Interactiveprop.png


Unable to set the Interactive property of the Application class

Resolutions

Resolution 1:

  1. Please make sure that you close down Excel on the workstation. This includes all open Windows and any workbooks that you have open.
  2. This is to ensure that there are no open cells on the user sesssion
  3. Run Report

Resolution 2:

  1. Please ensure that Macro's are fully enabled on the user profile
  2. Follow the instructions in the Knowledgebase on Enabling Macro's.

Resolution 3:

To resolve this issue you will need to terminate any of these rogue Excel processes manually.
  1. Close any Excel workbooks open on your desktop
  2. Press Ctrl+Alt+Delete and open up Task Manager
  3. Select the Processes tab
  4. Click on the column heading Image Name to sort the processes by name
  5. Look for any EXCEL.EXE processes which may appear in the list
  6. Select each of these processes, then click End Process
  7. The rogue Excel processes will now be terminated and removed from the Processes list
  8. Create and link your Excel workbook.


    • Related Articles

    • Error 438 Object doesn't support this property or method

      Error Error number:[438] Description: [object doesn't support this property or method] Source:[BICore] " Symptoms When trying to run a report, you get an error message appear immediately Troubleshooting Confirm whether it is isolated to only one ...

    • Microsoft Excel Security Issue Disabling Macros

      Overview of Microsoft Security Issue Earlier in 2022, Microsoft added a security measure to Office applications where it blocks Visual Basic for Applications(VBA) macros by default on any files sent via the internet. You cannot prevent the block from ...

    • Setting up an Excel ODBC (32bit) System DSN

      Issue You would like to connect to Excel files to use as data in your Intelligence Reports Resolution You need to configure a 32bit System DSN on all workstations. Instructions as follows: Set up a System Data Source Name (DSN) using the Microsoft ...

    • Error: An error occurred during configuration of inquiry

      Symptom When defining a connection to an MYOB Advanced tenant, the user is presented with a message about one or more inquiries not being set up and asking if the user would like to create them: After clicking Yes, the user is presented in an error ...

    • REF error in the data range definition

      Error: You are receiving a #REF error on Sheet1 when normally it should be RawData as the range. Resolution: Copy the report and remove the template Run it and the RawData definition will still be corrupt Remove one Excel formula (this one contained ...