Forum Discussion
Power Query - SKU Generator
Hi,
I am using MacBook Excel Version 16.102.2
I am trying to build a Power Query - that build out a SKU (e.g Column H). Based on the products I've entered in Column E and the Size Range chosen in Column F.
I've managed to build a power query - but when I refresh nothing happens / updates. Some screenshots attached of my workings.
2 Replies
Your screenshots don't show the query you have built and it's not clear what should 'happen' upon a refresh. Can you share a link giving access to your file on OneDrive or similar.
And kindly ignore Kidd_Ip 's comments on Loading options. PowerQuery on a Mac loads back to Excel by default. Each query into its own sheet. Very annoying and you can't choose the loading destination. There are work-arounds but they aren't user friendly.
Below may help fix Power Query refresh issue:
1. Ensure using “Close & Load To…”
• After building your query, use “Close & Load To…” instead of just “Close & Load”.
• This lets you choose where the query output goes (e.g., a table in a specific sheet).
• If you only used “Close & Load”, Excel might not have created a visible output table, so refresh appears to do nothing.
2. Check Query Dependencies
• If your query depends on another query (e.g., merging Products and SizeMapping), make sure:
o Both queries are loaded properly
o The merge keys (e.g., SIZE RANGE) match exactly—no trailing spaces or mismatched formats
3. Verify Output Table Exists
• Go to the sheet where the query should output.
• If no table is visible, go back to Power Query and re-load it using:
o Home > Close & Load To… > Table > Existing Worksheet
4. Refresh All Connections
• Use Data > Refresh All from the Excel ribbon—not just the Power Query editor.
• On Mac, this is the only way to trigger refresh for all queries.
5. Check for Errors in Applied Steps
• In Power Query Editor, look at the Applied Steps pane.
• If any step shows a warning or error (e.g., merge mismatch, null values), the query may silently fail on refresh.
