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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto-filter messes up the formulas
Hi Drew
Can you give some examples of the formula you are using, the data being referenced on the second tab, and the errors you are seeing. Autofilter should not be creating these problems for you, but a bit more information may enable us to help. -- Regards Roger Govier "Drew2006" wrote in message ... 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. |
Reply |
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) |