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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
v-heq-msft
Community Support
Community Support

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
Most Valuable Professional
Most Valuable Professional

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
Memorable Member
Memorable Member

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

PwerQueryKees
Impactful Individual
Impactful Individual

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
Most Valuable Professional
Most Valuable Professional

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

AmiraBedh
Most Valuable Professional
Most Valuable Professional

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.