Hi,

I am helping the local school sports partnership to create a spreadsheet of what acitivities the children do. It nearly does all the things I want it to do, but it goes so slow every time a user enters one piece of data into worksheet. Initially I thought it was just the size of the file (15000 rows and lots of columns). However, having seen other spreadsheets with over 20mb of data running smoothly on older PCs I guess there must be more to it than that.

So I would be really grateful if you could take a look at the file attached. Could it be my use of validated data drop-down lists? Is it any of the VBA coding? The use of filters? I have removed some conditional formatting colour coding (e.g. column G) but this does not seem to resolve the speed issue. I have also added a 'Data entry mode' button, which runs a calculationmanual vba code, but this seems to make no difference to the overall speed.

I've had to compress the file to .zip format as it is over 4mb. The password is 'password' to unprotect the sheets.

Any suggestions will very helpful.

Simon
UK Teacher