Access "filters"

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
 
D

Debra Dalgleish

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

Excel 2007 - Pivot Tables Include Filtered / Hidden Values inSubtotal / Total 0
Embed the same Excel multiple times 0
Adding a big matrix in Word 2013 5
Table Security in Access 2013 1
Filter out rows based on the value of a cell 4
Filtering data in Excel Pivot 0
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
filter on excel table with msquery and replaced header 1

Top