Power Query - SKU Generator

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.