Filter changes upon reopening file!

G

Guest

Can anyone help with why my filter settings change upon opening a file??

The scenario is I save a file with particular filter criteria that display
one row of about a 100. When I reopen it I see the 1 row briefly and then it
reverts to a previous filter critera that displays around 10 of the 100!!

I haven't been able to repeat the problem with a simple sheet but have now
seen it multiple times ;-(

The current offender has track changes turned on.

TIA
Barry
 
D

Dave Peterson

Just a guess...

Do you have macros in that workbook that could be helping out?

If you close excel and reopen it in safe mode, then open your file, does the
problem still occur?

Close excel
windows start button|Run
excel /safe
file|open your workbook

(starting in safe mode disables lots of things--including macros.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xl filter &/or freeze panes point changes on reopen! 1
Auto Filter does not work with embedded objects 2
Reconstruct Filter string on Subform 2
Track Changes Won't Stay Off 4
Filter on more than one field 3
PivotChart will not preserve series formatting for some charts when reopening workbook 1
Track Changes won't turn off 2
Track Changes-Changes by different users converted to "Author" on 3

Top