Last seen: Jun 29, 2026
Hi Susan, This isn't a Power Query issue, it's a Power Pivot issue. If the user wants to interact with the Slicers then they require Power Pivot, a...
Hi Ahmed, If you're referring to downloading the course videos, then the email with the download link is sent out 31 days after you joined. In the ...
Will do 🙂 Typical that for once there's something Excel for Windows won't do, that the Mac will! Glad you liked the INDEX solution for dynamic...
Hi Emily, As Sunny said, a sample of your data would help, but it sounds like you might be able to use PivotTables to automate this process, as des...
Hi Arvind, The only ways to 'automatically' update a cell/s is with formulas or a VBA routine that executes every time a cell is modified, I don't ...
Hi Anders, Fellow Excel MVP, Jon Peltier, discovered that regular charts correctly display the custom day format in both the axis and labels. So...
Hi Anders, I agree it's not an ideal workaround. I've asked my MVP community and raised it with Microsoft. I'll let you know if I get a helpful res...
Hi Anders, Thanks for sharing the file. There appears to be a limitation on PivotTables displaying day duration with hours and minutes in the one f...
Hi Jay, In the attached file I've made the following changes: 1. Formatted the data in an Excel Table - it makes the formula in column H easier ...
Hi Anders, That's odd, but then so is the starting point of the vertical axis. Can you please share your file, or if it contains confidential in...
Hi Ibrahim, I don't think the ProPlus membership is limited to businesses as such, it's just a branding label. Have you tried to upgrade? This woul...
🙂 sorry, Russ, I forgot to tell you that I changed one of your Credits to a Debit because the sample file '1' only had Credits, but your second samp...
Hi Russ, If you have Excel 2010 then you can use Power Query (free Microsoft add-in) to get the data out of your files and into the format you want...
Hi Jay, Please start a new thread. New question = new topic/thread. Before you post it, please make your question clearer by showing the value/d...
Hi Rob, DAX Time Intelligence functions only work on calendar periods. If your fiscal periods are different to the calendar then you need to use a ...