Filtering a Shared Workbook

  • Thread starter Thread starter PCC
  • Start date Start date
P

PCC

I cannot use the advanced filter function when I share a
workbook. Is there a 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
 
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 must log in or register to reply here.

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

shared workbook - macros using advanced filter - substiitution nee 1
adding a control button with a filter 2
Protected Sheets 2
AutoFilter settings in shared workbook 2
Sharing workbooks limitations - Merged Cells 12
Can't unshare workbook 7
Sharing workbook 3
AutoFilter settings in shared workbook 1

Back
Top