I not entirely sure but I think you have to have Excel 2010 and abovegregory196 wrote: ↑Thu Oct 29, 2020 5:17 pmGreat file thanks !!! Guess wont update on excel 2007 ;-(
The power of (2.718)
- paspuggie48
- Posts: 636
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
-
- Posts: 3217
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
I couldnt get it to work with anything apart from Office 365.paspuggie48 wrote: ↑Thu Oct 29, 2020 5:28 pmI not entirely sure but I think you have to have Excel 2010 and abovegregory196 wrote: ↑Thu Oct 29, 2020 5:17 pmGreat file thanks !!! Guess wont update on excel 2007 ;-(
- paspuggie48
- Posts: 636
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Strange Archery, I used to have Windows 7 and Excel 2010 with no problems.
-
- Posts: 3217
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
Well, could be me then. The other office versions i tried it either didnt update or just hung for like 20mins. Same machine, installed office 365 and the spreadsheet updated in less than 10 seconds. All fine now.paspuggie48 wrote: ↑Thu Oct 29, 2020 6:05 pmStrange Archery, I used to have Windows 7 and Excel 2010 with no problems.
- paspuggie48
- Posts: 636
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Brill Archery...Memphis loves it
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Wondered if anyone can help please.
Getting the error message on this great spreadsheet.
Any clues?
Getting the error message on this great spreadsheet.
Any clues?
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
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.
If it doesn't maintain the same links it breaks and you get an error message similar to one shown.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
I see. Thanks memphis.MemphisFlash wrote: ↑Sat Nov 28, 2020 7:48 ami 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 cant seem to find it though.
- MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
ok, i've had a look and hopfully rectified it.
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Thanks for that mate but it still isn't working for me...Im on office 2016.MemphisFlash wrote: ↑Sat Nov 28, 2020 6:06 pmok, i've had a look and hopfully rectified it.
BTTS v Odds - Power Query.xlsx
Capture.JPG
I must be missing something
- MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Ok, try again , 3rd time lucky
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Thanks MF. Appreciate you helping. Ive read quite a few of your posts. Your a wizard with Excel.MemphisFlash wrote: ↑Sun Nov 29, 2020 5:15 pmBTTS v Odds - Power Query.xlsx
Ok, try again , 3rd time lucky
- MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
got a feeling you into the same music as me REALROCKNROLLA
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
I could be! What you like?MemphisFlash wrote: ↑Sun Nov 29, 2020 6:15 pmgot a feeling you into the same music as me REALROCKNROLLA