View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Avril V Avril V is offline
external usenet poster
 
Posts: 1
Default MSExcel 2007 Filters do not allow Copy and Paste of data

In MSExcel 2003, I could apply a filter, highlight the data that was selected
and paste it to another worksheet. When I attempt to do this in MSExcel 2007,
the data that is pasted includes all the data from the worksheet from which
it was selected (i.e. it unpacks the filter when you paste it and all the
lines are shown). Is there a patch that needs to be installed to correct this
problem?