Forum

Power Query Close a...
 
Notifications
Clear all

Power Query Close and Load To

3 Posts
2 Users
0 Reactions
207 Views
(@razorbacker07)
Posts: 2
New Member
Topic starter
 

Working through the Power Query Unpivot - fix 4 Common Data Layouts.

When I am ready to select Close and Load to, I do not see the same options shown in your video.  I am using MS Excel 2013 and have upgraded my Power Query in MS.

 
Posted : 03/02/2022 6:36 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Bill,

Welcome to our forum!

Unfortunately, Excel 2013 does not have the newer options to load to PivotTable and Pivot Chart. There's no way to get them other than to purchase the latest version of Excel (2021) or get a Microsoft 365 subscription. If you were to upgrade, I would strongly recommend you do not get Excel 2021, as it's already out of date.

Mynda

 
Posted : 03/02/2022 7:39 pm
(@razorbacker07)
Posts: 2
New Member
Topic starter
 

Thanks Mynda.  I really appreciate your tutorials and useful information.

 
Posted : 04/02/2022 9:28 am
Share: