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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,826
Messages
5,855,866
Members
431,771
Latest member
CoryMelth

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
Top