hope you can help!?
I have set up a table in Excel which does a great job of exporting data from a SharePoint however I have added my own columns to add (local) information to each entry.
ie. I am exporting a list of products with various columns showing detail (such as price, quantity, description, etc.) which is always updating on the sharepoint so I've connected my excel sheet to automatically update - and this is all done which works great.
BUT I have added a few of my own comments as we need to demonstrate how we have used each product (ie. classify how we have used the product, local product manager and comments). This is detail which we only want to keep local and something the central sharepoint can not add - however each time i refresh this excel table, the information I have entered (and saved) it disappears as the new data is transferred in.
SO - what i need to do, is keep the table refreshing with the new data from the SharePoint but also keep my added information on the columns that I have added.