How to load query to specific sheet in excel for Mac

Question

Hi team,&nbsp;I know that we can choose to load query to specific sheet in excel for windows, but I can't find this function in excel for mac!&nbsp;not sure if i miss something, any input are welcome&nbsp;Nelson

omid_motamedise · Answer

Load it into a new sheet, then copy and paste it in your desired sheet.

amirabedh · Answer

If you want to load the data into a specific sheet, you'll need to copy and paste it manually.

If you want to keep the link between the query and the specific sheet (so it refreshes automatically) . After pasting the data, you can set up a connection between the query and the destination sheet using VBA.

nelsonyan · Answer

Thanks&nbsp;AmiraBedh&nbsp;Looks like it's really some limitation on Mac.Do you have more information on VBA setup? I need to make the query connection active on the table.&nbsp;&nbsp;Nelson

amirabedh · Answer

What do u want to achieve exactly ?

nelsonyan · Answer

What I want to achieve is just like what we can do on Windows.1. Load the query to specific sheet2. Data of query in that sheet can be refreshed properly

Forum Discussion

How to load query to specific sheet in excel for Mac

9 Replies

Related content

Google sheets

Changing Excel sheet name in Power Query

Power Query extract specific sheets of the same Excel Workbook

Help: import google sheet by Power query to Excel

Unable to run olap query in linked excel sheet