While basic Excel lets you create or paste a table in the spreadsheet itself, Power Query can connect to a variety of sources ...

Unprotect, then protect your sheet again. Disable background refresh. Repair Microsoft Excel. Another thing you should check is that no change is done in the query and structure. If you have made ...

Go to “Data > New Query > From Other Sources > From Web ... 9] Now, click “Close & Load” to load the data of Google Sheet in Excel. You have connected your Google Sheet with Excel.