Hi,
When Mynda starts typing a formula in PowerQuery, then automatically a list of options appears. F.i. she types the word Date and every function that starts with the word Date appears.
That list does not automatically appear when I start to type. What am I doing wrong?
Best regards,
Annette
Which Excel version are you on?
I am using Microsoft Office 2019 for Students and Using At Home
That may be the reason. Don't believe that the 2019 version has this feature. But I may be mistaken and have no way to check it.
Hi Antonia,
Riny is correct. This is a version issue. You can try updating your version of Excel to see if the feature is available. If that doesn't work, then you'd have to buy a new version of Office or upgrade to 365, which is what I'd recommend.
Mynda
Thanks Mynda and Riny, I will try to update my version or else buy a new version.