Forum

Erik Halkjaer
@erik_h_dk
Trusted Member
Joined: Mar 18, 2020
Topics: 9 / Replies: 31
Reply
RE: .ODC file problems

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...

4 years ago
Forum
Reply
RE: .ODC file problems

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 ...

4 years ago
Forum
Reply
RE: Power BI Refresh from Open Excel Workbook

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...

4 years ago
Forum
Reply
RE: Data modelling with multiple sources

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 ...

5 years ago
Forum
Reply
RE: Data modelling with multiple sources

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...

5 years ago
Forum
Topic
Forum
Replies: 4
Views: 79
Reply
RE: Sort weekday names in slicer

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

5 years ago
Forum
Reply
RE: Sort weekday names in slicer

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 ...

5 years ago
Forum
Reply
RE: Sort weekday names in slicer

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. ...

5 years ago
Forum
Reply
RE: Sort weekday names in slicer

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...

5 years ago
Forum
Reply
RE: Sort weekday names in slicer

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...

5 years ago
Forum
Reply
RE: Sort weekday names in slicer

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...

5 years ago
Forum
Topic
Forum
Replies: 12
Views: 111
Reply
RE: Dynamic path to a number of folders

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...

5 years ago
Forum
Reply
RE: Dynamic path to a number of folders

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...

5 years ago
Forum
Page 2 / 3