Pivot Table from Query Studio output?

[wskacz]

Ran a query in Query Studio as Excel 2007 output.  Trying to run a Pivot Table on results but get a Data Source reference is not valid message in Excel.  Even copied data to a separate workbook.  Data looks OK, sorts, etc.  Stumped....   Walter

[CognosPaul]

This is a bug with Excel 2007. When you open the Excel output directly you will not be able to pivot. I believe it has something to do with the temp folder it's saved to. If you save the file, you should be able to use pivot.