| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto-filter messes up the formulas
My spreadsheet has working formulas (that reference a separate tab in the
spreadsheet) When I filter the data, the formulas are not referencing the correct cells anymore. It's not always obvious in a big spreadsheet so I've had to stop using autofilter completely, which is a shame. Why does this happen?! This is a major flaw in my opinion. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refresh auto filter | Excel Worksheet Functions | |||
| Auto Filter question | Excel Worksheet Functions | |||
| URGENT !! Auto Filter | Excel Discussion (Misc queries) | |||
| AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Threaded Mode
