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
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.