- Sheets not available.
- No MS Excel sheets displays in Crystal Reports.
- Connection to MS Excel only show "Add Command" option in Crystal Reports.
- MS Excel Spreadsheets are not available when creating a report using an ODBC connection to a MS Excel document.
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
Reproducing the Issue
- In Microsoft ODBC Administrator, create an ODBC connection using the MS Excel ODBC driver to the MS Excel spreadsheet to report from.
- In Crystal Reports, create a new report using the ODBC connection created in steps 1.
- It does not display anything under the new connection other that "Add Command". The MS Excel spreadsheets are missing.
- When Using ODBC connection to MS Excel document, the spreadsheets are interpreted as "System Tables", and by default, the system tables are not visible when creating an ODBC connection in Crystal Reports.
- To be able to display the MS Excel sheets when using an ODBC connection to a MS Excel document in Crystal Reports, check the Crystal Reports Database Option: "System Tables"
- Open Crystal Reports.
- Under the menu "File", select "Options..."
- In the "Options" window, under the tab "Database", check the Data Explorer option "System Tables".
- Click "OK" to accept the change.
- Now, when creating a new report off an ODBC connection to a MS Excel spreadsheet, it it will display the available sheets.
ODBC, Excel Spreadsheets, missing, Excel 2003 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016