Access "filters"

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have import data into an Excel 2007 spreadshee from a an Acess 2007
database table. Since I do not need them to be link I then deleted
the "connection"

However the "filer" drop downs remain on the table and the filter
button is greyed out so I cannot remove them

Any sugggestions
 
The data might be in an Excel Table. Select a cell in the table, and on
the Ribbon, click the Design tab, under Table Tools

In the Tools group, click Convert to Range, then click OK to remove the
query and table.
 

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

Access Access 2010: Activating controls in a form after filter by form 0
Excel2007: copying filtered table values, how can I copy ONLY thefiltered values 2
Microsoft Excel Filters (some rows don't filter) 1
Microsoft Excel Filters (last row doesn't filter) 2
Auto Filter 4
Update Filter List AFTER Filter Applied 3
PIVOT - Reference a cell outside the table for report filtering 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1

Back
Top