1 Reply Latest reply on Mar 26, 2012 7:06 PM by David Peeples

    Can't publish to Tableau Server with Excel 2007

    David Peeples

      I'm working on a Tableau Server account and can't publish to Tableau Server when connected to excel 2007. It's no problem when connected to .xls files. I'm getting this message when trying to publish with 2007 excel file connection:

       

      An error occurred on the server. The details of the error are:

      DataSourceException:

      • The drivers necessary to connect to the database server '' are not properly installed on Tableau Server. You may visit http://www.tableausoftware.com/drivers to download driver setup files. Database error 0x80040154: Class not registered
      • Unable to connect to the Microsoft Excel file "C:\Program Files (x86)\Tableau\Tableau Server\data\tabsvc\temp\0z3gtj70tc2zpy1f7xr5v18dktp6\Data\AmeriChoice\AMC Appeal Data.xlsx". Check that you have access privileges for the requested file and that it is not open in another application.

      Click the Refresh button in your web browser and try again.

      If you continue to receive this error please contact your Tableau Server Administrator

       

      Anyone have any input?

       

      The following resource does not list any special drivers for 2007: 

      Any help is greatly appreciated.

       

      thanks,

       

      Dave