Note: Someone at the Excel community board recommended asking this here. My question is similar in spirit to this one, but I'm not working on a pivot table. It's a primary table generated from a SQL connection.
I have an excel table whose data is generated from an external SQL connection.
Id like to format the table nicely by (e.g.):
1. Changing some column names
2. Changing some column widths
3. Applying conditional formatting to the data in the table.
When I refresh all on the spreadsheet, #3 is retained, but #1 is set to the value from SQL, and #2 is reset to the default column width.
Is what Im trying to do possible? Does it require some amount of indirection to a new table?
Thanks!