I've got a workbook that contains data for 2011 and 2012. Its size is around 6G. But later I found out that I only need data for 2012. So is there a way to delete 2011 data without regenerating the workbook so that my workbook will be half smaller and have a better performance.
Furthermore, are there scripts to do this automatically?