Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
1,799
Views
Topic starter
Hi,
Please could you tell me why the Close and Load option to load to existing worksheet is greyed out when I use Get Data From File/From Folder? I have tried several different ways to access the close and load option but 'load to existing worksheet' is greyed out each time.
This option is available to me when I use Get Data From File/From Workbook.
Thanks.
Posted : 28/08/2021 4:44 am
Hi Katie,
I don''t know the reason, as it's not documented anywhere, all you can do is to add to a new worksheet then cut the table and paste it where you want it to be.
Requires extra steps, but at least we have a workaround.
Posted : 29/08/2021 1:12 am