Forums

General Betting

There is currently 1 person viewing this thread.
Templeton Peck
03 Aug 11 19:48
Joined:
Date Joined: 17 Sep 02
| Topic/replies: 4,134 | Blogger: Templeton Peck's blog
I have a new PC and am unable to download the P+L spreadsheets from here.  I can do it ok on my old laptop (running Excel 97 and Windows Vista) but with my new PC (running Windows 7 and Excel 2010) I can't get them to open.  The following message appears when I try to open a downloaded file:

"Excel found unreadable content in 'BettingPandL.xls'.  Do you want to recover the contents of this workbook?  If you trust the source of this workbook, click Yes." 

I click 'Yes' but nothing happens.  Any of you tech wizards able to solve this problem for me please?

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 23
By:
Templeton Peck
When: 03 Aug 11 19:56
I see this thread also specified the problem:

http://community.betfair.com/site_feedback/go/thread/view/94170/27373413/betting-pl-download-xls-doesnt-work-on-64bit-machines#

Does anybody know if there is a solution?
By:
Ghetto Joe
When: 03 Aug 11 20:02
Been happening for ages, I get the same error with win 7 and excel 2003 but it fixes the error when I click yes. Some people are using open office to open the file then save it and reopen with excel after.

God knows why they didn't stick to a simple format like csv files for the downloads that everyone could open.
By:
Templeton Peck
When: 03 Aug 11 20:12
Thanks.  If Betfair can't give me a solution then I'll try the open office route.
By:
Compound Magic
When: 03 Aug 11 20:16
I don't have Excel 2010, but excel 2010 is xlm and the sheet BettingPandL is xls.

You could try ~ opening up a workbook, go to options, click excel options, click save,
Where it says Save file in this format click in drop down box, Excel 97-2003.

Then download 'BettingPandL.xls' and open. When finished revert the options back to Excel. Workbook
By:
Templeton Peck
When: 03 Aug 11 20:24
Thanks for the tip but I'm afraid it didn't work.  Same problem.
By:
Compound Magic
When: 03 Aug 11 20:27
Sorry it was a shot in the dark as I did not have 2010 to test on. [:x]
By:
Templeton Peck
When: 03 Aug 11 20:31
No problem, it seemed like a decent suggestion, although I know sod all about IT.
By:
Cuban
When: 03 Aug 11 20:36
I've had the same problem. The only solution I've found is to download the P&L, then use OpenOffice Calc to open the download then save file as an excel file. It's a bit messy but works for me.
By:
Compound Magic
When: 03 Aug 11 20:44
This site, at the bottom of the first page suggests uninstalling an update which causes the problem.

http://forums.techarena.in/ms-office-support/749154-2.htm
By:
TheInvestor2
When: 03 Aug 11 20:53
The solution is to download the file in Google Chrome. For some reason it let's you open it in excel that way, even though you still get an error message.
By:
Templeton Peck
When: 03 Aug 11 23:55
I do use Chrome, I haven't even tried other browsers.  Off to bed, will investigate further tomorrow.  Betfair have escalated but not expecting a solution.
By:
TheInvestor2
When: 04 Aug 11 02:14
Strange.

In Firefox I get the message "The document is corrupt and cannot be opened. To try and repair it, use the Open and Repair command in the Open dialog box and select Extract Data when prompted." And nothing works.

In Chrome, I get the same error message as you, but it does work.

The problem started when I installed Windows 7.
By:
brendanuk1
When: 04 Aug 11 08:29
its symptomatic of the whole fooked up site. As has been mentioned whats wrong with csv??????

Somewhere in betfair towers there is someone anally rententive saying its not broke. When 99% of customers have to work around its issues.
By:
Templeton Peck
When: 04 Aug 11 14:14
It doesn't work in Firefox either.

I've just installed Open Office and can open the files with that and then save/copy & paste to Excel.  Adds a bit more time but at least it works.

I received this email today:

Dear Templeton

I am writing to you today to advise that we have noticed a posting made on the Betfair Community by yourself, and wanted to advise that we are aware of an issue that currently exists concerning the P&L display and download. This issue is being investigated by our Technical Department. Hopefully there should be a resolution shortly.

I apologise for the inconvenience this causes. Should you need a report on any information on your account please contact us and we can supply a report in Excel format.
Please do not hesitate to contact me if you have any further enquiries.
Kind regards,
Betfair Helpdesk
By:
brendanuk1
When: 04 Aug 11 21:14
ok cool. Its been like that for literally years so far.

Wonder how long till it gets fixed?
By:
brendanuk1
When: 04 Aug 11 21:15
Betfair Community Manager 2 When: 31 Mar 11 11:43

I'm going to pass this on to our technical support team.
By:
PHS
When: 20 Aug 11 21:54
Have BF come back to you with a resolution of this problem TP ? I have the same problem, and it's driving me mad. Ability to download my results to Excel is the main reason I put up with paying 5% on here.
By:
brendanuk1
When: 20 Aug 11 22:10
The solution is to download the file in Google Chrome

try that
By:
TheInvestor2
When: 20 Aug 11 22:15
Yeah, that works for me, but not for Templeton apparently.
By:
PHS
When: 20 Aug 11 22:52
I'm already using Chrome
By:
brendanuk1
When: 20 Aug 11 22:55
try open office
By:
monksfield2
When: 24 Apr 12 22:02
I've also posted this on the other thread referred to by Templeton:

I've just switched to a new laptop running 64-bit Windows 7 and clicking the Download to Spreadsheet link causes this message:

"Microsoft Excel
The document is corrupt and cannot be opened.  To try and repair it, use the Open and Repair command in the Open dialog box and select Extract Data when prompted.  OK"

Following these instructions produces nothing.

If I click `Save link as' and open the saved file in Excel, the error message is different:

"Microsoft Excel
Excel found unreadable content in 'BetHistory2.xls'.  Do you want to recover the contents of this workbook?  If you trust the source of this workbook, click Yes.  Yes No"

Whether I click Yes or No, nothing happens.

I've just noticed that the new machine came with Microsoft Excel Version 14.0.4760.1000 (32-bit).

Should a machine with 64-bit Windows not have 64-bit Excel?

Has anyone found a solution to this problem since last August?

I guess I need to download Open Office and Google Chrome and see if either of those works.
By:
Ghetto Joe
When: 24 Apr 12 22:24
Betfair's priorities lie with promoting crap like the beta site or super slots rather than sorting out anything useful on the site.
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com