Zend certified PHP/Magento developer

Saving an Excel file with filters and conditionals applied

I am working with MS Excel and I need to save a file with a lot of filters and conditionals applied to many books. Is there any way to do it in each book? (I mean without copy-paste in new books).

In order to clarify: when I apply a filter data and save the file, the data is saved without filters applied. The same is true for conditionals. Only solution that I have found it is copy filtered data and paste in a new book.