Restoring a deleted column in Excel from a SharePoint Data Connection view

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?

February 28th, 2013 3:01pm

Hi,

First, make sure you have added the new column into the view as well as the list.

Second, try to use "MSQuery" feature in Excel to check the issue.

For more information about MSQuery, please refer to the following link:

http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx

Free Windows Admin Tool Kit Click here and download it now
March 1st, 2013 8:33am

Hi,

First, make sure you have added the new column into the view as well as the list.

Second, try to use "MSQuery" feature in Excel to check the issue.

For more information about MSQuery, please refer to the following link:

http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA01009966

March 31st, 2015 9:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics