Forum

I'm pretty sure you need a 365 licence to use the stock data types in Excel Online.

Hi Pieter, Yes, in Excel 365 for Mac. Do they have 365? Also, Dropbox is a web query, not a local Excel file. This may be the difference. Mynda

Welcome to our forum! Without 365 you'd need to scrape the price from a web page. You can use Power Query to do this as explained here. Mynda

Hi Jeff, Thanks for sharing your file. In my file you'll notice that my ledger table is called 'Ledger'. In your file it's called Table1. You eithe...

Hi Zohar, You need to go back to the step in the query where the sheets and tables are listed and filter out the ones you don't want to include in ...

Hi Marc, Welcome to our forum! In order to use the result of a query as the source of a PivotTable you must Close & Load to > PivotTable....

Hi Fred, You should remove it from your source and then refresh your query and close & load to Power Pivot. This should update everywhere. You ...

Thanks for sharing your file, Mark. What you're seeing are the gridlines which you've hidden with white borders on the cells. When the PivotTable r...

Hi Mark, I couldn't really make out what was happening in the video, sorry. Can you create a mock up file and share it with us so we can reproduce ...

Hi Keith, You can use the expand and collapse buttons to drill up/down into a time period in your charts. There's no way to apply this to all char...

Hi Lester, Welcome to our forum! As explained in my reply on YouTube, "You'd need to add a column (to the ledger table) that marks shares as ...

Hi Aslihan, Right-click on the Start Date column in the PivotTable > Ungroup. This will fix the SEQUENCE formula. Repeat for the End Time column...

Hi Zohar, Welcome to our forum! I'm delighted you were able to make use of the techniques in my Project Management Dashboard tutorial. If you wa...

Hi Vicky, It sounds like you need to update Excel. If you had Text.Middle before and now you don't then that's a regression. I'd get on to IT! A...

The lines of code that are deleted are simply evaluated by the gatekeeper and therefore don't need to be evaluated again in the following conditional ...