Excel 2007 - table style default

[Guest]

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]

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

http://office.microsoft.com/en-us/word/HA102045501033.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.

 

[Guest]

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]

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.

 

[Guest]

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]

You're welcome! Glad I could help.

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

: