The new Excel 2007 is very good, all the possibilities to work with
big databases, the flexibility in pivot tables and filters is awesome.
However I am having a very big problem. When I am working with
autofilters I can't choose a category and fill the row of other column
or the same because the hidden values are overwritten. The same
happens dropping rows or copying. This is very uncomfortable and
didn't happened with the last Excel. Thanks for your help.

You're in the wrong newsgroup. This one is for Visual Basic. Try an Excel
group, such as:

microsoft.public.excel
microsoft.public.excel.programming

Mike

Thank you!
Bye