Skip to main content
Question

An unknown error happens when I try a bot with the Open Excel command. This is the message: "An unknown error occurred when executing the 'OpenExcel' command. To continue, contact your system administrator." I have excel and path is c drive.

  • September 26, 2022
  • 8 replies
  • 1240 views

An unknown error happens when I try a bot with the Open Excel command. This is the message: "An unknown error occurred when executing the 'OpenExcel' command. To continue, contact your system administrator." I have excel and path is c drive.

8 replies

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+18
  • Most Valuable Pathfinder
  • September 27, 2022

Hi @Spence 6113 (MAXX Potential)​ ,

 

  • No Excel installed: If you do not have Microsoft Excel installed on the device on which you are running bots to automate Excel-related processes, use the Excel basic package.
  • Desktop Excel installed: If you have a desktop version of Microsoft Excel installed on your computer, use the Excel advanced package in your bots.
  • Online Office 365 Excel only: If you are using Microsoft Excel 365 on a web browser, use the Office 365 Excel package for automating tasks related to Excel.

 

Note: If you are using Excel Advance Packages then you need an Office license should active. (Please upgrade or downgrade the excel package version and give it try)

 

https://apeople.automationanywhere.com/s/question/0D52t00000IdoYhCAJ/i-was-trying-to-run-excel-advance-package-to-read-excel-data-below-error-occurred-despite-following-the-right-steps-


  • Author
  • Cadet | Tier 2
  • September 27, 2022

I am using the desktop version with the excel advanced package. In addition to the Excel Open command, the Create Workbook command does not work either.


Forum|alt.badge.img
  • Cadet | Tier 2
  • July 14, 2023

Hi,

 

Has anyone found a solution for this issue. I have tried downgrading and upgrading the packages. However still facing the issue.

 


Forum|alt.badge.img+12
  • Pathfinder Advocate | Tier 6
  • October 22, 2024

@CN998 hi, any solution to this?


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • October 22, 2024

@Semih 3318 Some information would help us help you:

  • Package you’re using (Excel Advance/Basic/365
  • File location (Variable/Control Room/Desktop file)
  • Has this ever worked on this machine (new install? updated?)
  • Type of Excel installation?

Forum|alt.badge.img+12
  • Pathfinder Advocate | Tier 6
  • October 22, 2024

@JLogan3o13  using excel advanced

Desktop file.

New task- first try. Havent done any task on this machine. Excel basic work, but need to use excel advanced

Packages are in default.

i couldnt understand the question about type of excel installation


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • October 22, 2024

Type of Excel installation - is it desktop install (Office 2021, for example), O365 install, etc?


Forum|alt.badge.img+12
  • Pathfinder Advocate | Tier 6
  • October 22, 2024

it is microsoft 365 install