#1
|
|||
|
|||
Dragging cells with filters on
I'm finding that, with a simple filter on, dragging over cells hidden by the filter changes the values in the hidden cells too. This happens to some users in the organisation while for others they do not experience any issues.We all use Office 2010.Is there some settings not configured right for some users? Last edited by krisjah; 12-27-2013 at 12:24 AM. |
#2
|
|||
|
|||
Not completely sure what is going on. I would have to know for sure what kind of data is in those hidden cells. Numbers, text, formulas. If it's formulas it may that automatic calculation is turned off on the computers since filtering data with formulas will calculate with every filter and cause it to run slow.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dragging conditional formatting like a formula | sjp1966 | Excel | 9 | 04-13-2017 06:01 AM |
How Do You Keep Cell Outline Borders After Dragging & Dropping? | juliansdad | Excel | 9 | 12-11-2013 10:08 PM |
Dragging Pictures into Placeholders | simville02 | Drawing and Graphics | 1 | 09-29-2013 06:33 PM |
filters | userman | Outlook | 1 | 05-29-2012 01:50 PM |
Permissions error when dragging Notes into Outlook | eljapo4 | Outlook | 0 | 07-01-2010 03:22 AM |