I'm using MS Query to create reports that can be refreshed (Data/From Other Sources/MS Query). Once the data is pulled into Excel (2007), the column headings are those of the Safari report that I am querying. I can update the SQL code with <select field name> as <new name> but this is cumbersome to do for many data fields and queries.
I am looking at an Excel sheet that was created by someone else. The column headings are stable and do not change when the report is refreshed. It is not using the SQL code above. I can right click on the column heading, select "define name" and this is what I see :
Name: Guest_Type
Scope: Workbook
Refers to: =Sheet1!$A$2
Yet, the actual column heading is "Guest Type" (without the underscore), and the defined name does not appear in the formula box - it says A2 as it normally would.
I am looking at an Excel sheet that was created by someone else. The column headings are stable and do not change when the report is refreshed. It is not using the SQL code above. I can right click on the column heading, select "define name" and this is what I see :
Name: Guest_Type
Scope: Workbook
Refers to: =Sheet1!$A$2
Yet, the actual column heading is "Guest Type" (without the underscore), and the defined name does not appear in the formula box - it says A2 as it normally would.
