Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
NelsonYan
New Member

How to load query to specific sheet in excel for Mac

  • Hi team,

 

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!

 

not sure if i miss something, any input are welcome

 

Nelson

9 REPLIES 9
Anonymous
Not applicable

Hi @NelsonYan ,
Does the information provided by PwerQueryKees   help you solve your problem? If it helps, please accept the responses you find helpful as solution.

Best regards,
Albert He

AmiraBedh
Super User
Super User

I don't see any mention for Power BI here (or any other component) Are you sure about choosing the correct community to post your question ?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Omid_Motamedise
Super User
Super User

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

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h
PwerQueryKees
Super User
Super User

And just load to new tab and then do a rename?

Or load to a new tab and then MOVE the table to the location you want. In windows this also moves the data needed for refresh.

AmiraBedh
Super User
Super User

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.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Thanks @AmiraBedh 

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.

 

 

Nelson

What do u want to achieve exactly ?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

What I want to achieve is just like what we can do on Windows.

1. Load the query to specific sheet

2. Data of query in that sheet can be refreshed properly

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors
Top Kudoed Authors