Hi NoSparks I was running another Excel workbook at the same time so I do not think that helped. Closing all Excell workbooks and restarting and then going through the delete unused rows and columns and saving and closing still doesn't reduce the workbook size. The file is being saved as i set up a test workbook and deleted one of the spreadsheets after anther and the file size started to reduce, particularly with the deletion of Tomato and Apples. The size of the spreadsheets are no more than 3K each and then a massive drop to 41MB.