Returning data from Microsoft Query to Excel

I am trying to use queries I have been running in MS SQL Server Management Studio, to return data in Excel where it would display as pivot. Some queries I was able to use through Excel but few others are not returning anything.

Any idea what could be the cause? I am doubting it has something to do with the query itself - but they are displaying results properly in MS Query, they are just not returning any data to Excel.

Thanks.

Could be the website... What is the website?

I receive the data from the SQL DB on our server. Just to clarify, I do get valid results in Microsoft Query but the problem is in returning this data to Excel in form of a table. Is there something in the query itself that would prevent the results from displaying properly in Excel? I can see results in MS SQL Server Management Studio also so query is fine, but I would prefer if I could just use Excel straight up instead of copying data and formatting manually.

Apparently there was an issue passing the data to Excel because the query contained Transact-SQL Variable.

Adding "SET NOCOUNT ON" to the beginning of the query did the trick.