ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table and MS Query (https://www.excelbanter.com/excel-discussion-misc-queries/201110-pivot-table-ms-query.html)

linglc

Pivot table and MS Query
 
I am trying to create a pivot table from another excel file with a range of
data called "info" via MS query. Everything works ok until the last step when
I want to return the data to Excel. The message that pops up says - "The
Microsoft Access database engine could not find the object "xls.info". Make
sure the object exists and that you spell its name and the path name
correctly."

Does anyone know what went wrong?


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com