New Posts For Thread: help with betfair tracking spreadsheethttps://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheetI have recently downloaded the tracking spreadsheet from the labs site have it working great, BUT:any ideas how to stop the error pop up message "This Web query returned no data"It happens when the race has finished or any market that suddenly suspen.https://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739814#422739814.Tue, 10 Nov 2009 16:30:21 -0600What ever happened to this?https://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739514#422739514What ever happened to this?Thu, 05 Nov 2009 04:22:48 -0600.https://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739390#422739390.Tue, 20 Oct 2009 10:33:54 -0500ttthttps://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739386#422739386tttThu, 15 Oct 2009 16:01:25 -0500:xhttps://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739382#422739382:xTue, 13 Oct 2009 13:22:26 -05002009 Flat Semi-Detached Detached Terraced total Number of Sales 95 65 65 35 260 Average price £ 147385 174503 252359 166313 total sales 14001575 11342695 16403335 5820955https://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739378#4227393782009 Flat Semi-Detached Detached Terraced total Number of Sales 95 65 65 35 260 Average price £ 147385 174503 252359 166313 total sales 14001575 11342695 16403335 5820955Fri, 09 Oct 2009 13:02:39 -0500actually, just cracked it. there is a 'public sub forcerefresh()' that needs to be set to false too. on the query table, i did as unk suggested and i set refresh period to 0 (not sure if that helped, i just did!)ll works fine now without the pop up.https://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739374#422739374actually, just cracked it. there is a 'public sub forcerefresh()' that needs to be set to false too. on the query table, i did as unk suggested and i set refresh period to 0 (not sure if that helped, i just did!)ll works fine now without the pop up.Fri, 02 Jan 2009 16:16:12 -0600i am also having this problem. i have spent a very long time learning vba in order to get the sheet to do what i want (in fact, unk you started me off and helped me out months ago if you remember), only to have this put a stop to my sheet after a lothttps://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739370#422739370i am also having this problem. i have spent a very long time learning vba in order to get the sheet to do what i want (in fact, unk you started me off and helped me out months ago if you remember), only to have this put a stop to my sheet after a lotThu, 01 Jan 2009 09:30:50 -0600**inghttps://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739366#422739366**ingSat, 22 Nov 2008 09:38:17 -0600cheers Unk,As a thought I have created a new webbrowser form. I have then amended the refreshalltables( ) code with an IF statement. It navigates to the table connection address and interrogates the HTML coding to see if the strings "market suspendedhttps://community.betfair.com/labs_chat/go/thread/view/94114/23597134/help-with-betfair-tracking-spreadsheet?post_id=422739362#422739362cheers Unk,As a thought I have created a new webbrowser form. I have then amended the refreshalltables( ) code with an IF statement. It navigates to the table connection address and interrogates the HTML coding to see if the strings "market suspendedSat, 08 Nov 2008 03:59:00 -0600