If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|