When importing data into Excel 2007 (using Microsoft Query) the table style
default is always "Table Style Medium 9". How do I change that default for
all instances of an import? I know that I can change it for each individual
instance by going to the "Table Tools - Design" tab and right-clicking the
style I want and then clicking 'set as default' but I would really like the
default I choose to be for each new import as well. Is it possible to set a
permanent table style defualt for each new import that I do? Thank you.

You could create a default template named book.xltx and save it in the
XLSTART folder, as described he

http://office.microsoft.com/en-us/wo...5501033.aspx#3

In that template, set the default table style that you want to use.
When you create a new blank workbook, it will be based on that template.

fneiling wrote:
When importing data into Excel 2007 (using Microsoft Query) the table style
default is always "Table Style Medium 9". How do I change that default for
all instances of an import? I know that I can change it for each individual
instance by going to the "Table Tools - Design" tab and right-clicking the
style I want and then clicking 'set as default' but I would really like the
default I choose to be for each new import as well. Is it possible to set a
permanent table style defualt for each new import that I do? Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Debra,
Thank you for the suggestion but unless I'm missing something with the
template idea it doesn't fix my problem. The "table tools design" tab is not
available until after I have used the Microsoft Query wizard to pull the data
into the spreadsheet, therefore I am unable to chose a 'table style' until
after the data is pulled in, which prevents me from setting up a template
(because imported data has to already be on the sheet).

"Debra Dalgleish" wrote:

You could create a default template named book.xltx and save it in the
XLSTART folder, as described he

http://office.microsoft.com/en-us/wo...5501033.aspx#3

In that template, set the default table style that you want to use.
When you create a new blank workbook, it will be based on that template.

fneiling wrote:
When importing data into Excel 2007 (using Microsoft Query) the table style
default is always "Table Style Medium 9". How do I change that default for
all instances of an import? I know that I can change it for each individual
instance by going to the "Table Tools - Design" tab and right-clicking the
style I want and then clicking 'set as default' but I would really like the
default I choose to be for each new import as well. Is it possible to set a
permanent table style defualt for each new import that I do? Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

In a blank workbook, type "A" in cell A1, and type 1 in cell A2.
Select cell A1, and on the Ribbon, click the Insert tab.
Click Insert Table.
With cell A1 selected, set your new default table style.
Delete the table.
Save this blank workbook as a template named book.xltx and save it in
the XLSTART folder, as described in the link in my previous message.

Close and reopen Excel.
The Book1 workbook that opens automatically, and any other new blank
workbooks, will be based on the book.xltx template.
When you run MS Query, the imported table will have the default table
style from that template.

fneiling wrote:
Debra,
Thank you for the suggestion but unless I'm missing something with the
template idea it doesn't fix my problem. The "table tools design" tab is not
available until after I have used the Microsoft Query wizard to pull the data
into the spreadsheet, therefore I am unable to chose a 'table style' until
after the data is pulled in, which prevents me from setting up a template
(because imported data has to already be on the sheet).

"Debra Dalgleish" wrote:


You could create a default template named book.xltx and save it in the
XLSTART folder, as described he

http://office.microsoft.com/en-us/wo...5501033.aspx#3

In that template, set the default table style that you want to use.
When you create a new blank workbook, it will be based on that template.

fneiling wrote:

When importing data into Excel 2007 (using Microsoft Query) the table style
default is always "Table Style Medium 9". How do I change that default for
all instances of an import? I know that I can change it for each individual
instance by going to the "Table Tools - Design" tab and right-clicking the
style I want and then clicking 'set as default' but I would really like the
default I choose to be for each new import as well. Is it possible to set a
permanent table style defualt for each new import that I do? Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Debra,
Thanks so much for putting up with my ignorance - I'm always so focused on
pulling data into Excel with Microsoft Query that it never even occured to me
to make a table 'by hand' for this purpose. This worked perfectly and will
save me countless (cumulative) hours of aggrevation! Francine

"Debra Dalgleish" wrote:

In a blank workbook, type "A" in cell A1, and type 1 in cell A2.
Select cell A1, and on the Ribbon, click the Insert tab.
Click Insert Table.
With cell A1 selected, set your new default table style.
Delete the table.
Save this blank workbook as a template named book.xltx and save it in
the XLSTART folder, as described in the link in my previous message.

Close and reopen Excel.
The Book1 workbook that opens automatically, and any other new blank
workbooks, will be based on the book.xltx template.
When you run MS Query, the imported table will have the default table
style from that template.

fneiling wrote:
Debra,
Thank you for the suggestion but unless I'm missing something with the
template idea it doesn't fix my problem. The "table tools design" tab is not
available until after I have used the Microsoft Query wizard to pull the data
into the spreadsheet, therefore I am unable to chose a 'table style' until
after the data is pulled in, which prevents me from setting up a template
(because imported data has to already be on the sheet).

"Debra Dalgleish" wrote:


You could create a default template named book.xltx and save it in the
XLSTART folder, as described he

http://office.microsoft.com/en-us/wo...5501033.aspx#3

In that template, set the default table style that you want to use.
When you create a new blank workbook, it will be based on that template.

fneiling wrote:

When importing data into Excel 2007 (using Microsoft Query) the table style
default is always "Table Style Medium 9". How do I change that default for
all instances of an import? I know that I can change it for each individual
instance by going to the "Table Tools - Design" tab and right-clicking the
style I want and then clicking 'set as default' but I would really like the
default I choose to be for each new import as well. Is it possible to set a
permanent table style defualt for each new import that I do? Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

You're welcome! Glad I could help.

fneiling wrote:
Debra,
Thanks so much for putting up with my ignorance - I'm always so focused on
pulling data into Excel with Microsoft Query that it never even occured to me
to make a table 'by hand' for this purpose. This worked perfectly and will
save me countless (cumulative) hours of aggrevation! Francine

"Debra Dalgleish" wrote:


In a blank workbook, type "A" in cell A1, and type 1 in cell A2.
Select cell A1, and on the Ribbon, click the Insert tab.
Click Insert Table.
With cell A1 selected, set your new default table style.
Delete the table.
Save this blank workbook as a template named book.xltx and save it in
the XLSTART folder, as described in the link in my previous message.

Close and reopen Excel.
The Book1 workbook that opens automatically, and any other new blank
workbooks, will be based on the book.xltx template.
When you run MS Query, the imported table will have the default table
style from that template.

fneiling wrote:

Debra,
Thank you for the suggestion but unless I'm missing something with the
template idea it doesn't fix my problem. The "table tools design" tab is not
available until after I have used the Microsoft Query wizard to pull the data
into the spreadsheet, therefore I am unable to chose a 'table style' until
after the data is pulled in, which prevents me from setting up a template
(because imported data has to already be on the sheet).

"Debra Dalgleish" wrote:



You could create a default template named book.xltx and save it in the
XLSTART folder, as described he

http://office.microsoft.com/en-us/wo...5501033.aspx#3

In that template, set the default table style that you want to use.
When you create a new blank workbook, it will be based on that template.

fneiling wrote:


When importing data into Excel 2007 (using Microsoft Query) the table style
default is always "Table Style Medium 9". How do I change that default for
all instances of an import? I know that I can change it for each individual
instance by going to the "Table Tools - Design" tab and right-clicking the
style I want and then clicking 'set as default' but I would really like the
default I choose to be for each new import as well. Is it possible to set a
permanent table style defualt for each new import that I do? Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html