FILTERS

[ACCOUNTING GAL]

WE HAVE 15 PEOPLE SHARING AN EXCEL WORKSHEET WITH ABOUT 12 COLUMNS. DATA IS
CONTINUALLY ADDED ALL DAY LONG. FOR SOME REASON THE FILTERRING TABS WE SET UP
IN EACH COLUMN DISAPPEAR. WE CAN NOT FIGURE OUT WHY THIS HAPPENS. WE WOULD
LIKE TO PERMANENTLY KEEP THE TABS OPEN. ALSO COMMENTS ARE INSERTED IN THE
FORMATTED CELLS AND THOSE ARE DISAPPEARING TOO.
ANY HELP WOULD BE APPREICATE.

 

[Gord Dibben]

Probably because your Caps Lock is stuck.

Un-stick it please................hurts my ears.

But more likely due to users fiddling with settings.

Tools>Options>View>Comments "Comment Indicator" and "None" are being
changed.

Same for Objects "Show All" and "Hide All"


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 17:18:02 -0800, ACCOUNTING GAL <ACCOUNTING