Delete Rows causes unrelated error: 'Please make sure it's not partially overlapping a table.'

Help Activities
,
1

Hello,

I am encountering an error that I believe is a bug.
When trying to delete the top two rows of an excel sheet, UiPath throws the error: ‘Delete Rows: Could not delete range $A$1:$AA$2. Please make sure it’s not partially overlapping a table.’

I believe this is a bug because (in my research) the error ‘Please make sure it’s not partially overlapping a table.’ only occurs when making a table or pivot table.
I am not making any table, but only trying to delete the top two rows.

Using versions,
UiPath Studio: 2023.4.3
Excel: 2.22.3

Thanks,
Grant Walker

3

The error message “Delete Rows: Could not delete range $A$1:$AA$2. Please make sure it’s not partially overlapping a table” in UiPath doesn’t necessarily indicate a bug, but rather a potential conflict between UiPath’s deletion attempt and underlying Excel structures.

Here’s why you might see this error even though you’re not explicitly creating tables:

  • Hidden Tables: Excel allows creating tables without visual borders. These hidden tables can interfere with deleting specific ranges if they overlap with the rows you’re trying to remove.
  • Chart Data Source: Charts in Excel often link to specific data ranges. If the top two rows of your sheet are the data source for a chart, deleting them might trigger this error because UiPath might perceive it as affecting the chart’s data range.
  • Formatted Tables: Even without creating a formal table, applying formatting options like alternating row colors or banded rows can sometimes create internal structures that UiPath interprets as tables, leading to this error.

Solutions:

  1. Check for Hidden Tables:
  • Go to the “Insert” tab in Excel.
  • Click on “Table” and then “Convert to Range.”
  • This will convert any hidden tables back to a normal range, eliminating the conflict.
  1. Verify Chart Data Source:
  • Right-click on your chart and select “Select Data.”
  • Ensure the data range for the chart doesn’t include the top two rows you want to delete. Adjust the data range if necessary.
  1. Clear Conditional Formatting:
  • Select the top two rows.
  • Go to the “Home” tab and click on “Conditional Formatting.”
  • Choose “Clear Rules” and then “Clear Rules from Selected Cells.”
  1. Delete Rows One by One (UiPath):
  • Use the “Delete Rows” activity twice: once for the first row and once for the second. This avoids potential conflicts with larger ranges.
  1. Use VBA Macro (Optional):
  • If comfortable with VBA, use a macro within an Excel Application Scope activity to directly delete the range using Range("$A$1:$AA$2").Delete. This bypasses potential UiPath interpretations.
5

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