In Power Query, I am unable to Close & Load any query to an existing sheet. The error message reads "Cannot return external data to a macro sheet". I have no problem loading to a new sheet.
I am using Office 365 Personal/Windows 10 and it is up to date. I do not have a hidden Personal Macro workbook and I get this error whether or not the workbook contains any macros. I have Googled and found nothing in on this error. Any ideas?
Thanks.
I am using Office 365 Personal/Windows 10 and it is up to date. I do not have a hidden Personal Macro workbook and I get this error whether or not the workbook contains any macros. I have Googled and found nothing in on this error. Any ideas?
Thanks.