Category / Section
Common Error: Infinite Row or Column Selection
1 min read
Issue Explanation
When working with data, selecting an infinite row or column (e.g., Data!3:3 or Data!D) or the entire sheet is not allowed. This can cause errors and prevent the tool from functioning correctly.
Common Selections Causing Errors:
- Infinite rows (e.g., Data!3:3)
- Infinite columns (e.g., Data!D)
- Entire sheet selection
Solution
To resolve this issue:
- Select a Specific Range: Choose a finite range of cells instead of an entire row, column, or sheet.(e.g., Data!D3:E3, or Data!D4:D10 or Data!D10:E100)
- Click Update Again: After selecting the appropriate range, click the update button to proceed.
For any further assistance, please contact our support team.