When I format a range of cells as a Table in Excel 2007 and then convert the
table back to a range, the style formatting seems to get locked into the
range. If I convert the range back to a Table, I can then not change the
table style from the original one selected in the first table format. Any
ideas?

Lynn Trapp
Application Developer/Trainer