I used the "Export to Spreadsheet" option for a SharePoint document library to create my working report. I created a special view for this as I did not want all of the columns in my export. I build my report on a seperate tab in Excel around this exported data and it has been working great. I recently added a new column to the view on SharePoint but it does not show up when I refresh my data. I tried manually adding the column, evening ensuring it was in the same orderl; still no luck. The Connection file does not exist so I cannot edit the owssvr.iqy. All I have is the connection string and command text. I created a new workbook to see if the command string changed because of the new column but it did not. I don't want to rebuild my report from scratch just because I added a new column, but it appears that may be the only option I have unless someone can answer my question.
Question: How can I get a new column from a view added to an existing data connection query?