Power Query from Google Sheets results in #DIV/0

jandaman

New Member
Joined
Mar 19, 2019
Messages
1
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:
vrr0i8.jpg


Excel Power Query Table:
2h7gug1.jpg


Any ideas or suggestions would be greatly appreciated!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top