Articles in this section
Category / Section

Common Error: Incorrect Input Range Format

1 min read

Issue Explanation

The input range format is incorrect. This error occurs when the selected range does not follow the required format(A1 Notation).

Correct Format

The correct format for the input range should include the following:

  • Sheet Name: The name of the sheet.
  • Beginning Cell: The starting cell of the range.
  • End Cell: The ending cell of the range.
  • Example: Data!A1:B2 (in A1 notation format).

Solution

  • Use the Update Button: Click the "click to update input range"  button to automatically update the range based on your selection in the sheet.

Ensure your input range is in the correct format before proceeding.

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Access denied
Access denied