The power of (2.718)

[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

[Realrocknrolla]

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

No worries... i'll keep trying.

[MemphisFlash]

Capture.JPG

if you click on queries and connections before you hit refresh all,
you will see the tables loading.

[spreadbetting]

Can you schedule the connection to run with VBA? Like a worksheet open event?

[paspuggie48]

Can you schedule the connection to run with VBA? Like a worksheet open event?

You can record a macro to refresh (if that is what you are after?) or if it is an open event, then go into Connections > Properties and select Refresh data when opening the file.

Screenshot 2020-11-30 164427.png

[spreadbetting]

Yep, was suggesting if you can code VBA (macro is VBA) then you could use the Worksheet_Open event so you'd load up new data automatically each time you opened the workbook