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
 
Ad

Advertisements

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

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

Top