Fail to remove duplicates in Excel (error: 0x800A03EC)

Help Activities
1

Dear Experts

There is error message(0x800A03EC) when I try to use [Remove Duplicates] activity

image
image1216×634 36.8 KB

image
image407×312 13.4 KB

May I know how to fix it?

Thank you
Ivan

2

@yangyq10,

Check if there is any formula in your range. If the formula have any error this could also result in this error.

3

@ashokkarale No formula in it. I attach the file for your reference

Test.xlsx (12.9 KB)

4

Hi @yangyq10

Can you try the below

The image shows an automated process scope in an Excel file that removes duplicates based on the columns "Order Number" and "SO Line Item" from a specified table. (Captioned by AI)
The image shows an automated process scope in an Excel file that removes duplicates based on the columns "Order Number" and "SO Line Item" from a specified table. (Captioned by AI)832×808 39.3 KB

This image shows a UiPath workflow where the 'Remove Duplicates' activity is being configured, with the 'Range' argument not yet supplied, displaying the available Excel tables to select from. (Captioned by AI)
This image shows a UiPath workflow where the 'Remove Duplicates' activity is being configured, with the 'Range' argument not yet supplied, displaying the available Excel tables to select from. (Captioned by AI)1245×708 120 KB

Input:

This image shows an Excel spreadsheet containing a list of orders segmented by Order Segment, Order Number, Sales Order Line Item, and Mode of Transport, with duplicates in the SO Line Item column highlighted in yellow. (Captioned by AI)
This image shows an Excel spreadsheet containing a list of orders segmented by Order Segment, Order Number, Sales Order Line Item, and Mode of Transport, with duplicates in the SO Line Item column highlighted in yellow. (Captioned by AI)701×747 25.2 KB

Output:

This image is a screenshot of an Excel table with columns for Order Segment, Order Number, SO Line Item, and MOT, with one cell in column F highlighted in yellow. (Captioned by AI)
This image is a screenshot of an Excel table with columns for Order Segment, Order Number, SO Line Item, and MOT, with one cell in column F highlighted in yellow. (Captioned by AI)701×747 24.2 KB

Regards,

1 Like
5

@lrtetala Thank you, it is the table format issue which cause this issue :slightly_smiling_face:

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.