LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 data corruption using sort within a filter. J_Harrington Excel Discussion (Misc queries) 4 November 14th 07 07:43 PM
data corruption [email protected] Excel Discussion (Misc queries) 5 January 24th 07 09:22 AM
Screen corruption and more Charlie Excel Discussion (Misc queries) 1 October 17th 06 06:02 PM
Corruption in Excel? Dudley Excel Discussion (Misc queries) 0 October 25th 05 03:36 PM
formula corruption Graham Excel Worksheet Functions 1 December 15th 04 10:24 AM


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"