Subscript Out of Range

Excel Import → Subscript Out of Range - Error in Excel Import


      

Root Cause of the Error: This issue primarily occurs when you import an Excel sheet and modify the formatting of the software's predefined Excel sheet.

Solution: To resolve this issue, please follow these steps:

Step 1: Open the Excel sheet that you are attempting to import.
  1. For example, the date format in the Excel sheet is incorrect. Ensure that all data formats align with the expected standards.
      

Step 2: Correct the data in the Excel sheet and reattempt the import process.
  1. Once corrected, the Excel sheet should import successfully.
Step 3: If the issue persists:
  1. Download a blank Excel template provided by the software.
  2. Paste your data into the new Excel file without altering the default formatting.
  3. Attempt the import again.
We hope the above steps help resolve your issue.

    • Related Articles

    • Income Tax || Share Holding (Schedule SH-1)

      How and Where to Fill Share Holding (Schedule SH-1) To complete the Share Holding (Schedule SH-1) section, follow the steps provided below. You can use Manual Entry, the Excel Import Process, or Import Data from Previous Year methods based on your ...

    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...

    • ExpressTDS || Excel Import Error → Challan Not Getting Mapped

      Step 1: Log In and Access Deductor Master Visit https://www.expresstds.com/ and log in with your credentials. Navigate to the Deductor Master section. Select the deductor or company for which the correction return needs to be filed. Step 2: Locate ...

    • Zen IT || Excel Import → Type Mismatch, Error in excel import

      Root Cause of the Error: The error stems from either erroneous data entry in the Excel sheet or alterations to the format of the specific Excel file. Solution → Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy". ...

    • TDS Correction Excel Import "Error converting data type varchar to numeric"

      TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric Possible Resolution To solve this excel import issue, here are some suggestions are given below.  1. In the Excel template, it is to be checked that the ...