Query table not load on sheet

mr2bart

New Member
Joined
Dec 18, 2014
Messages
49
Hi,
I am starting to use Power Query.
After query table is done, I load it to a specific sheet to get the results, then I can use again this table for further calculations.
My question is: do I mandatory need to load the query table in a sheet to get the data for further calculation in excel sheet or is there a way to get the data if I do not load my query in a sheet?
(hope I am clear :))
Thanks!
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,307
table loaded into the sheet is usually end result but you can create pivot table without loading query table to the sheet

btw. don't forget to use appropriate forum for Power Query
 

Forum statistics

Threads
1,078,373
Messages
5,339,814
Members
399,332
Latest member
weeyang86

Some videos you may like

This Week's Hot Topics

Top