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.

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-

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.

Hi,

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

@CN998 hi, any solution to this?

@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?

@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

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

it is microsoft 365 install

Hi,

 

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

 

Have you got the solution??

​@vinit22 You’re going to be asked the same questions, as no one can help you if you don’t provide any info. Are you using Excel Advanced or Basic? What type of Excel (if any) is installed on the machine you’re running the bot on?