Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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.) b1 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File asks to update when no links were created | Links and Linking in Excel | |||
Network access to file - read only property | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Metering Office 97 products | Excel Discussion (Misc queries) |