Forum

List of functions d...
 
Notifications
Clear all

List of functions does not automatically appear when I start typing...

6 Posts
3 Users
0 Reactions
60 Views
(@a-vanlieshout64gmail-com)
Posts: 6
Active Member
Topic starter
 

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

 
Posted : 21/05/2022 10:04 am
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

Which Excel version are you on?

 
Posted : 21/05/2022 10:22 am
(@a-vanlieshout64gmail-com)
Posts: 6
Active Member
Topic starter
 

I am using Microsoft Office 2019 for Students and Using At Home

 
Posted : 21/05/2022 10:58 am
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

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.

 
Posted : 21/05/2022 11:16 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 21/05/2022 6:45 pm
(@a-vanlieshout64gmail-com)
Posts: 6
Active Member
Topic starter
 

Thanks Mynda and Riny, I will try to update my version or else buy a new version.

 
Posted : 29/05/2022 7:30 am
Share: