View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
linglc linglc is offline
external usenet poster
 
Posts: 31
Default 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?