Dugantrain
Active Member
- Joined
- Feb 10, 2003
- Messages
- 354
I have several MS Access crosstab queries. I would like to link an Excel Workbook to these queries, one crosstab per worksheet. After linking and refreshing on open, I would like two things:
1. The Column Headings in my Access Crosstab are dynamic; they change daily. I would like for the Excel Worksheet to add or delete columns automatically to reflect these changes.
2. I have manually sorted these column headings in Access by dragging and dropping. Any new column headings that come in are appended to the end (the right) of the crosstab alpha-numerically, which is fine. I would like Excel to keep these column headings in the exact same sort order as what I've done in Access and not list all of the headings alpha-numerically.
1. The Column Headings in my Access Crosstab are dynamic; they change daily. I would like for the Excel Worksheet to add or delete columns automatically to reflect these changes.
2. I have manually sorted these column headings in Access by dragging and dropping. Any new column headings that come in are appended to the end (the right) of the crosstab alpha-numerically, which is fine. I would like Excel to keep these column headings in the exact same sort order as what I've done in Access and not list all of the headings alpha-numerically.