linking to access database
 

i have a pivot table in excel that is linked to a query in an access
database. two questions...

i have modified the query to include an additional column. when i go to
show the field list in excel, the new column does not appear. i have tried
going through the pivot table wizard, but that did not seem to make a
difference. is there a way to get the new column to appear without having to
re-create the entire pivot?

this is unrelated to acces...but i notice when i modify the pivot (e.g.
drage new fields to pivot on or check/uncheck options to summarize
differently, the formatting (e.g. summary row & header row colors)
changes...is there a way to keep the formatting intact?