View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna_UK Anna_UK is offline
external usenet poster
 
Posts: 1
Default autofilters and data corruption


Repeated use of the filters in a spreadsheet is leading to the filter/data
freezing.

Can get around the filter problem by removing the autofilter and unhiding
the rows, but need to avoid the freezing.

Problem is specific to one tab of the spreadsheet only (where filtering is
done)
There's approx 40 columns and only 2311 rows of data.

Data is pasted in from Access and doesn't contain any vlookup/functions etc
etc

Root cause of problem may not be Excel, but solutions I've tried for my work
PC profile etc have not worked.

If anyone has found this before, any input would be useful - thank you

Many thanks