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?
Big thanks if anyone could solve this problem!
You can simply right click your data source > edit data source filters > choose the year field > and select the year you want to display and unchek all you want to hide.
I guess thats what you are looking for.?