3128017 - Error: 'No value given for one or more required parameters' when refreshing a report connecting to Excel via OLEDB, in Crystal Reports

• Error: Failed to retrieve data from the database.
• Error when refreshing a report based on Excel in Crystal Reports.
• Able to refresh reports based on other MS Excel spreadsheet in Crystal Reports.
• When refreshing a report based on a specific MS Excel spreadsheet, using an OLEDB connection in Crystal Reports, it fails with the error:
    
       "Failed to retrieve data from the database."
    
  Followed by:

       "Failed to retrieve data from the database.
        Details: ADO error code 0x80040e10
        Source: Microsoft Excel data engine
        Description: No value given for one or more required parameters."

       
       

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
• SAP Crystal Reports 2025 

CR, OLEDB , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem