FILTERS

A

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.
 
G

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
 

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

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Issues when deleting cells with multiple versions of Excel 0
Insert Data From Multiple Worksheets Into One (With Criteria) 0
If Formula and Dates 4
Pulling Data that falls within a specific date range? 3
shared issue 0
Multiple Tables and Multiple Pivot Tables Help 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0

Top