Hi all,

Using Sql Server Express 2012 64 bit
Office 2013 64 bit

I Linked from Access to a table in SSE - works
I created a query on the linked table - works
I saved and closed Access
I opened a new excel workbook
I attempted to use the query as my data source for a new PivotTable and received this error

The query did not run, or the database table could not be opened.
Check the database server or contact your database administrator. Make sure the external database is available and hasn't been moved or reorganized, then try the operation again.
Both SSE and Access are on local machine
Other than PivotTable, everything else seems to work perfectly.
SQL Server and SQL Browser are running.

I can create a PivotTable in excel using other tables from the Access database, just not linked tables or queries that use linked tables.

Have you seen/hear of this?
Any solutions?

thx
w