How do I get a new column from a Sharepoint list into Excel?
- by Jono
I've been using Excel to process data from a Sharepoint list for a while now.
However, I recently added a column to the Sharepoint table, and when I refresh the data in Excel, I don't get the new column.
I perform a lot of calculations based on this data, so creating a new worksheet with the "new" Sharepoint list, moving the calculations and the pivots to THAT sheet is more hassle than I'd like to face.
Is there a way to force Excel to display this new column that I've added?
Maybe by modifying the connection string?