Excel Expression Error

[MBClarke]

Hi all,

I am no expert on power queries and I have search the internet for hours to see if I can figure out my error on its own, but I seem to have all the answers, but no idea how to correct my issue.

I have a spreadsheet that gathers data from a website. This has been working wonderfully since February, but all of a sudden when I open my Excel sheet, I get an expression error, and I don't know what has changed.

Data Source errors.xlsx
	A	B	C	D
1	Currency	Code	Bank Selling.1	Bank Buying.1
2	EURO	EUR	17.1036	16.3249
3	BRITISH POUND	GBP	19.7066	18.7615
4	UNITED STATES DOLLAR	USD	16.3668	15.7171
FNB Rates

I have uploaded my workbook to see the query and assist in what changed or went wrong.

Thanks for all the help.

 

[MBClarke]

It almost seems as though my web url does not work as it did previously. If I try add it again to a new Excel sheet, the data that comes up seems weird.

Foreign Exchange Rates

Foreign exchange rates and pricing - FNB. Foreign exchange solutions to suit your personal or business needs from FNB. All exchange rates are updated regularly. As an FNB customer you could qualify for discounted rates.

www.fnb.co.za

Can you load that to Excel and get the currencies?

 

[MBClarke]

I think that maybe the URL has changed or something as the data does not seem correct when you connect that to Excel.

Foreign Exchange Rates - If you go there you see the rates, but if you go to Excel and link that URL the table data that comes up is not what is on the website.

Something seems strange.