P PCC Jul 28, 2004 #1 I cannot use the advanced filter function when I share a workbook. Is there a way around this?
F Frank Kabel Jul 28, 2004 #2 Hi Excel does restrict the functionality for nshared workbooks. I would assume Advanced Filters are one of them. So no way around this
Hi Excel does restrict the functionality for nshared workbooks. I would assume Advanced Filters are one of them. So no way around this
D Debra Dalgleish Jul 29, 2004 #3 You can't run an Advanced Filter in a shared workbook. However, you could open a new workbook, start the Advanced Filter, and extract the data to the new workbook. Then, copy the results back to the shared workbook.
You can't run an Advanced Filter in a shared workbook. However, you could open a new workbook, start the Advanced Filter, and extract the data to the new workbook. Then, copy the results back to the shared workbook.
