I made a test and works fine for me .... Unfilter your sheet...filter again...do a Control + C in your selection and Paste in another workbook...or to a Notepad file and copy from notepad and paste again in another excel sheet...try this trick...and tell me!