Skip to content
logo Knowledgebase

ERROR: 'Runtime error 62 Input past end of file'

Created on  | Last modified on 

Summary

How to resolve the error 'Runtime error 62 Input past end of file' when running a report to Excel. The error occurs when payroll data merges with Excel templates on Sage VIP Classic or Sage VIP Premier.

Description

Many payroll reports export information to Excel. These include the Old Mutual Pension Fund export, and Employment Equity report. The error when you run any payroll report which merges with the Excel template. 

Cause

  • Special characters in the data preventing the file merge
  • An issue with the Excel report template

Resolution

Step 1: Check regional settings

Step 2: Review payroll export data

  1. Close all open Excel reports.
  2. Run the report again and note where the merge stops (refer to a specific sheet or tab).
  3. Review the corresponding CSV file to check for misaligned columns.

 NOTE: The CSV files create in the system folder, as the newest file. Open the file with Notepad to review. 

  1. Inspect the payroll data for special characters such as:
    • Commas
    • Apostrophes
    • Quotation marks
  2. Remove any special characters from the affected payroll fields.
  3. Re-run the report after corrections.

Step 3: Replace the Excel report template

  1. Replace the Excel template file for the specific report in the Advisor folder with a compatible version.
  2. Contact Sage Customer Support for assistance if needed.
  3. Run the report again to confirm that the solution solved the error.
View More...