Forum

Close and Load to E...
 
Notifications
Clear all

Close and Load to Existing Worksheet Greyed Out

2 Posts
2 Users
0 Reactions
1,799 Views
(@kateb)
Posts: 1
New Member
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.

Close-and-Load-Screenshot.PNG

Thanks.

 
Posted : 28/08/2021 4:44 am
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: