Skip to main content

Hi,

 

I am getting below error while reading multiple cells from an excel sheet using Excel Basic Package.

 

‘Specified named range 'ColxOUS_5c' does not exist in the current workbook.’

Can someone please assist what is this issue about and how to resolve it.

Thanks in advance

@pramod.karumampoyil could you please just upload the parameter that you are passing while selecting the range. It seems the range you are passing not appearing correctly .


@Rehan.S1 Thanks for your response, But I am providing All rows parameter in Get Multiple Cells action of Excel Basic Package


Hi ​@pramod.karumampoyil - In the excel file go to formulas > Name Manager look for the named range called ColxOUS_5c. If it is missing then it confirms the issue. you will have to create it or correct the name used in AA.

Or updated get multiple cells action by:

In you AA code, if you are intended t get data from a cell range like A1: B20, and not a named range then Change the configuration in Automation Anywhere to use range reference mode instead of named range. like ex: A1:D10 instead of ColxOUS_5c.

Or 

If you want to stick with named ranges then:

  1. Highlight the correct cell range in Excel.

  2. Go to the Name Box (top-left, next to formula bar).

  3. Type ColxOUS_5c and press Enter.

  4. Save the file.

AA should now be able to access it.


Reply