Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERS
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERS
Probably because your Caps Lock is stuck.
Un-stick it please................hurts my ears. But more likely due to users fiddling with settings. ToolsOptionsViewComments "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 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
Filters | Excel Worksheet Functions | |||
How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Using Filters | Excel Discussion (Misc queries) |