Betfair P&L

[Shaun]

Not sure if anyone else has had this problem but i downloaded my P&L from betfair and excel 2010 says there is unreadable content if i want to fix it, i say yes and it opens but no sheet ?

Any ideas.

[Daywalker]

I get same in ms2010 running on win7. I have to download on my laptop which is ms2007 on vista. Might be to do with p&l figure not being of number format but i dont know why 2010 cant deal with it.
DW

[Shaun]

Ok thanks at least i know it is not just me, i might send the question over to the guys on mr excel forum see if they can solve it for us.

[osknows]

I think it's related to this http://www.mskbarticles.com/index.php?kb=2411912

Betfair will be generating the P&L excel file using 3rd party code. If you're desperate for the data either dual install Excel 2003/2007 along with 2010 or use Openoffice.org

If you dual install Excel the last install becomes default. This can be changed using the Start/Run menu

To unregister - "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" /unregserver

To re-register - "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" /regserver

And ensure you have the correct path and office version, eg OFFICE11, OFFICE12, OFFICE14 etc

[mickemick]

Please let us know if/when you solved this issue...At the moment I use OpenOffice to open P&L files.

Ok thanks at least i know it is not just me, i might send the question over to the guys on mr excel forum see if they can solve it for us.