Power Query from Google Sheets results in #DIV/0


New Member
Mar 19, 2019
Hi everyone, I'm new to this forum. I use Excel on a daily basis for work and have recently started playing around with Power Query for pulling in data from the internet. Haven't been able to find any info on this specific problem that I've been having.

Google Sheets has a handy finance function where you can get exchange rates for nearly every currency there is. Last week I was able to link this Google Sheet with automatically updated FX rates with a local Excel sheet with the Power Query function. It worked great last week and everything was working as I had expected. This week I wanted to expand the power query to also include daily rates (previously I was only pulling weekly) and so I made some changes to the google sheet, including adding an extra tab which had all the daily rates in it.

Whatever I did seemed to have broken the connection between the initial Power Query, and when re-linking, all I now get is a bunch of #DIV/0's in excel, although there are numbers in the google sheet. I attached two screenshots, one of the Google Sheet, the other of the Excel table the was created through Power Query.

Google Sheets:

Excel Power Query Table:

Any ideas or suggestions would be greatly appreciated!

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics