August 27, 2021
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.
November 8, 2013