Last seen: May 6, 2025
The dynamic named ranges refer to the CUBE formula table, not the source data. You then use those names in your chart, as explained in the tutorial ca...
The dynamic named ranges are for the data that feeds the chart so that as you add more months to your source data, those should feed thorugh to the CU...
Hi Rik, Welcome to our forum! Please try uploading again. Be sure to click the 'start upload' button and wait for the grey check mark beside the fi...
Hi Bax, There's no native way to connect. You can either write your own FTP scripts to download the files from the FTP server to a local folder, or...
Hi Ashley, The SharePoint connector is only available in Excel 2019 or 2021 Professional Plus or with a Microsoft 365 Apps for Enterprise license. ...
In that case I would rearrange the data so that it is already stacked vertically because there is no easy way to stack it in a formula in earlier vers...
Hi Dario, Remember, Power Query is case sensitive. You have named the step 'path' lower case and you're referencing it with 'Path' upper case. M...
Hi Michalis, Use this formula in cell O6 instead: =UNIQUE(VSTACK(A6:A20,C6:C20,E6:E20,G6:G20,I6:I20,M6:M63),,TRUE) Mynda
Hi Tom, I was assuming you were using VSTACK inside the lookup e.g.: =XLOOKUP(lookup_value, INDEX(VSTACK(...),,1), INDEX(VSTACK(...),,2) ) or...
Hi Jim, I'm not familiar with a way to do this. You might be limited to a Table visual: Mynda
Hi Katherine, You can use Power Query Merge to combine these files similarly to how you might do a VLOOKUP to bring columns E and F into file 1. ...
Hi Tom, Yes, you can feed the result of VSTACK into XLOOKUP, but you'd have to FILTER the VSTACK to only return the relevant column for XLOOKUP's l...
Hi Dieneba, Try: Settings (cog icon) > Admin Portal > Tenant Settings > Integration Settings > Map and filled map visuals > Enable ...
Hi Joanna, I can't reproduce the expanding of grouped columns when I try and link a cell on the 'Link sheet' to the 'FTE & DAYS DEMAND' sheet. ...
Correct, protection like I describe allows the user to select periods in the timeline, but not change the aggregation from days, months, quarters and ...