Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
88
Views
Topic starter
HI , I reviewed chapter 5-1 on creating pivot charts in the workbook from the table without loading into worksheet. But my 2016 excel version does not show all the fields you can select (such as pivot chart etc.) after "close and load to" please refer to the attachment. Could this be because it is excel 2016 and not office 365? I also noticed that when you select Data - "tables/ranges", my excel only has "table" please see attachment
Posted : 06/06/2019 4:19 am
Hi Junko,
Yes, this is just a limitation of the version of Excel you have. You should be able to update Excel and get the newer Power Query features, but you'll need to speak to your IT support for help with that.
Mynda
Posted : 06/06/2019 8:13 am
