Updated Excel Spreadsheet with automated Results and Crowd details. To use automation simply click the 'Load Results' button located on the 'League Table page. Function only available in Championship 2010 spreadsheet.

Tested on excel, not yet tested on Open Office. This function requires internet connection.

This will mean people can update spreadsheet without having to download the latest one just for results.

Bril-lant this spreadsheet, I'll adopt it right away.

I'll try it in OpenOffice and get back to you.

Cheers TS. If you delete any results in the spreadsheet and click the button it should reload them for you automatically.

It's not working in OpenOffice.

You have to adjust the settings for macros to start with.

Tools - Options - OpenOffice.org - Security - Macro Security

I set it to Medium so it asks if I want to go any further.

Tried deleting all info from NRC page and then using 'Load Results' button - nothing.

Back to you. Not sure what to do with regards to internet setting.

I'll download openoffice and see what needs to change

Cheers for testing it.

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

Cheers, fella!

Now updated for OpenOffice 3.1

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

Macro 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.

Enable VBA Properties

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

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

You should now be able to use the button on the league menu. Please download the latest Excel spreadsheet rlhererl.

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.