Skip to main content
Cadet | Tier 2
June 5, 2025
Question

Error:Specified named range 'ColxOUS_5c' does not exist in the current workbook.

  • June 5, 2025
  • 3 replies
  • 114 views

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

    3 replies

    Rehan.S1
    Navigator | Tier 3
    Navigator | Tier 3
    June 5, 2025

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

    🤝Let's connect on LinkedIn://www.linkedin.com/in/rehanshaikh0444/
    Cadet | Tier 2
    June 5, 2025

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

    madhu subbegowda
    Most Valuable Pathfinder
    Most Valuable Pathfinder
    June 5, 2025

    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.

    Madhu Kumar T S || https://www.linkedin.com/in/madhukumarts/