Unable to select a worksheet when importing spreadsheet data

Alerts and notices

If you are unable to select a worksheet while importing data from a spreadsheet, or if the worksheet field remains blank after you select a spreadsheet, try the following:

Install the Microsoft Access Database Engine 2007 package. This package must be installed, regardless of your Microsoft Office version.

Note: Install this system driver package on every machine where Accounting CS is installed.

If this does not solve the problem and you can't select a worksheet, try the following suggestions.

  • Regardless of the Microsoft Office version you are using, install the Microsoft Access Database Engine 2010 Redistributable package.

    Note: Install this package on every machine where Accounting CS is installed, and use the same version (32-bit or 64-bit) that you use for your Microsoft Office suite. To check your version, visit About Office: What version of Office am I using? External link

  • If the spreadsheet file is not on your local computer, copy or move it there.
  • If Accounting CS is open, close and then reopen it.
  • If the Excel filename extension is .XLSX, convert the spreadsheet to the .XLS format.
    1. Open the file in Excel.
    2. Choose File > Save As and navigate to a local folder.
    3. In the Save as type field, select Excel 97-2003 Workbook (*.xls).
    4. Click Save.

Related topics

Spreadsheet import overview

Microsoft Office Guidelines for CS Professional Suite

Was this article helpful?

Thank you for the feedback!