I have created this report that uses Pivot tables and Microsoft Query
to populate the Excel file and extract data from a Oracle database. To
increase the security in these reports, I have created a stored
procedure which when run populates a temp table. on which I run the
select statement.

I have been able to run both the commands individually but not one
after the other in Microsoft Query. Can someone please advise me on how
I might be able to run these one after the other. Thank you.

Unfortunately, I don't think it's possible to use MS Query to get data
from a stored procedure. Perhaps you could create a View instead, and
give it read-only permissions?

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev