Hi Mynda I understand that, but it wouldn't make a whole lot of sense to me to buy the 365 version, when my comany ( with more than 11.000 employee...
Hi again Mynda It seems to me, that Microsoft isn't going to answer this one. I understand that developement is for Excel 365 users only, but I ...
Hi I have been having the same issue using Excel Power Query and found a solution. If you edit your query and remove queries from files beginnin...
Allready on my next project at work - budget on salary expenses for 600 + emplyees for the next 4 years I look forward to your Power Pivot course ...
Hi Mynda With a lot of trial and error, I finally succeed in finding a solution that works. I have shown it to upper management, and it has already...
Hi Mynda Guess my next online course will be your Power Pivot course After a lot of try and error, I finally got it - thanks a lot. Erik
Hi Mynda Thanks a lot - knowing a bit about databases, I should have known about the Calendar table. But - tried to use the same data in a ...
Hi Mynda and Phil I have made a simple example - Pivot tables from data - danish and english - no problem sorting weekdays in the correct order. ...
Hi again Phil I took the simple data set and used it in Power Query - same problem - Power Query sorts weeksdays ( in danish ) in alphabetical orde...
Hi Phil The issue is not there - I have set up a custom list and so on, but the slicer settings does not give me the option to sort according to th...
Hi Mynda Excel does not give me the option to use a custom list - only alphabetic from a - z, z - a or sorted as in the datasource. That means t...
Thanks a lot - think this will work perfectly. My colleagues will have access and should be able to refresh the queries. But the users should no...
Hi Mynda I have one "main" file with a dashboard and 2 sheets with detailed information to specifik departments. This one is placed in the mai...