Last seen: Aug 31, 2025
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...
Hi again Found the Microsoft webpage describing use / import of .odc-files in Excel 2010, 2013, 2016, 2019 and 365. Erik
Hi Mynda Thanks a lot I guess you are right - but still strange, that I can save .odc-files but not use them. Erik
Hi again My private Excel 2016 is a part of Microsoft Office Professional Plus 2016 - and Excel is Version 2004 - Build 12730.20270. Erik
Hi Mynda I am at work now and have tested on Excel 2016 here - (16.0.4849.1000) 32-bit. MS Office 2016 Professionel Plus. Here I cannot exp...
Hi Mynda First try was a repair through the control panel - no luck Then I went the hard way with a reinstall - no luck Have you got any idea...
Hi Mynda I have tried it with a number of files including a number of your course files - all saved on my laptop. Tried different folders, tried th...
Hi again Mynda Thanks - but it turned out that my mistake was not to work in a new worksheet. I had used to course file from a previous lesson ...