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