I know I'm a pain, but I can't be bothered with Microsoft all the time, so OpenOffice does for me.



Cheers, fella!

I can see where the issue is and should hopefully have this sorted tomorrow.

Now updated for OpenOffice 3.1



Make sure the following options are checked to make sure Spreadsheet will work properly



=#FF0000Macro Security



Tools -> Options -> OpenOffice.org -> Security -> Macro Security (Button) -> Set to Medium

note - if you don't want a macro warning to enable macros everytime then set the option to Low. This is not recommended for other spreadsheets though.



=#FF0000Enable VBA Properties



Tools -> Options -> Load/Save -> VBA Properties



Make sure all tick boxes are enabled, especially the one called 'Executable Code' under Excel



=#408000You should now be able to use the button on the league menu. Please download the latest Excel spreadsheet [url=http://www.halifaxcomputers.co.uk/billy/c2010.xlshere[/url.

Works now.





Do I need to save it in its current format (excel), or can I save it in OpenOffice format?



Btw, att. for Blackpool v Keighley was 468.







Many thanks.

Cheers for the attendance TS, I've been looking all over for that one.



I've tried saving the spreadsheet as an =#408000Openoffice Spreadsheet (*.ods) and the functions still work fine so you should be ok to save it in Open Office format.

Thanks for all your help, Billy.

I've updated the super league spreasheet so it now does automated updates for fixtures from the league table page. Works with both Excel and OpenOffice.

You need to take a look at the NRC group results tables. They are out of kilter.

They look fine on mine. Try downloading [url=http://www.halifaxcomputers.co.uk/billy/c2010.odsthis version[/url which is a OpenOffice one that I use for testing.

I don't get it! Yesterday, when I updated the results, the tables were all over the place. Just checked again before I did anything else and they are fine. Bleeding pc's.

Yeah, computers are a pain. If they weren't I wouldn't have a job!





What you might find is, if it doesn't quite work if you close it and reopen it should be fine, as all tables are recalculated when you open the spreadsheet anyway.

Attendance for Blackpool game was 194.