Dugantrain
I Love Pants
- Local time
- Today, 03:54
- Joined
- Mar 28, 2002
- Messages
- 221
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.
*I realize that this is more of an Excel issue than an Access issue, but Access gurus tend to know more about Excel than Excel gurus do about Access.
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.
*I realize that this is more of an Excel issue than an Access issue, but Access gurus tend to know more about Excel than Excel gurus do about Access.
