The power of (2.718)

[Sean R]

Great spreadsheet. Thanks for taking the time to do this and share.

[Realrocknrolla]

Wondered if anyone can help please.

Getting the error message on this great spreadsheet.

Any clues?

[MemphisFlash]

i posted a revised sheet in this thread as the site i scrape the data from is constantly changing.
If it doesn't maintain the same links it breaks and you get an error message similar to one shown.

[Realrocknrolla]

i posted a revised sheet in this thread as the site i scrape the data from is constantly changing.
If it doesn't maintain the same links it breaks and you get an error message similar to one shown.

I see. Thanks memphis.

I cant seem to find it though.

[MemphisFlash]

ok, i've had a look and hopfully rectified it.

BTTS v Odds - Power Query.xlsx

Capture.JPG

[Realrocknrolla]

ok, i've had a look and hopfully rectified it.

BTTS v Odds - Power Query.xlsx

Capture.JPG

Thanks for that mate but it still isn't working for me...Im on office 2016.

I must be missing something

[MemphisFlash]

BTTS v Odds - Power Query.xlsx

Ok, try again , 3rd time lucky

[Realrocknrolla]

BTTS v Odds - Power Query.xlsx


Ok, try again , 3rd time lucky

Thanks MF. Appreciate you helping. Ive read quite a few of your posts. Your a wizard with Excel.

[MemphisFlash]

got a feeling you into the same music as me REALROCKNROLLA

[Realrocknrolla]

got a feeling you into the same music as me REALROCKNROLLA

I could be! What you like?

[MemphisFlash]

i think my user name gives it away 50's rock and roll, rockabilly, country, swing, modern bands like restless, straycats, and of course elvis, eddie, buddy and gene, not to mention johnny burnette, cash, perkins et al.

[Realrocknrolla]

i think my user name gives it away 50's rock and roll, rockabilly, country, swing, modern bands like restless, straycats, and of course elvis, eddie, buddy and gene, not to mention johnny burnette, cash, perkins et al.

Certainly does with them names! I like them all! True fact.. i was born the same day Elvis died! My mother had 24 hour Elvis on the hospital radio!

[MemphisFlash]

i went to graceland and sun studio in 1999 with my brother

[Realrocknrolla]

i went to graceland and sun studio in 1999 with my brother

Phenomenal. Me and the wife have that on our bucket list if and when the world resumes normality. Austin is a place we wish to see too.

Am i doing anything wrong with this spreadsheet mate? Im refreshing data and nothing is working! Im on office 2016.

[MemphisFlash]

i'm on office 365, so that maybe the issue. or it's up to date at the minute