filter on excel table with msquery and replaced header

C

clucom

Can I add an automatic filter, replacing or hiding original header line
created importing data from external data (msquery) and adding manually a
new header because I need to rename column names in ordere to not modify
names?
Deleting header from option table of excel simply hides the line and
automatic filter created over that line doesn't display value list.
Please note that this operation was possible with excel 2000 but I'm not
able to do it with excel 2010.
May you help me please?
Thanks
 
D

Don Guillett

Can I add an automatic filter, replacing or hiding original header line
created importing data from external data (msquery) and adding manually a
new header because I need to rename column names in ordere to not modify
names?
Deleting header from option table of excel simply hides the line and
automatic filter created over that line doesn't display value list.
Please note that this operation was possible with excel 2000 but I'm not
able to do it with excel 2010.
May you help me please?
Thanks
Click to expand...

If desired send file to dguillett1 @gmail.com with a complete explanation.
 

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

Dealing with the error: unable to filter on excel hc home school 0
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
Importing Excel Files to Aceess 2003 table with Descriptive header 1
Update Pivot Table Filters based on a Cell Value in Excel 2007 0
Filter Juction Table and related tables 1
export MySQL to Excel? 7
Rename imported MS Access field names 1
How to get 2003 Excel pivot table to work correctly? 5

Top