Sorted... the problem was actually the range. It was set at row 61,500 and the last column. (Over 100mb a workbook!!!) got it down to 2mb...

Thanks again and when I've the finshed article I'll post up. (This is for a very serious peice of health data collection)....