Hi All,

I originally posted this on the Microsoft Answers - Office forum, thinking there was an easy fix, but was directed here...

So, Ive got a list of documents on our office 365 sharepoint site exported to an excel (2010) table.  I have several extra columns in the table with data that ive entered manually but when updating the external data connection it either ignores the extra data, overwrites it or worse, moves it to other lines!

New documents get added to the site on a daily basis and the extra data is required for tracking purposes.

I can manipulate the list manually to get it where i want it but this gets very time consuming and is extremely frustrating.

Ive only managed to find 1 similar question in several hours of trawling, now a few years old -

• Body text cannot contain images or links until we are able to verify your account.

The proposed workaround relied on the external data being sorted by modification date, and the extra data not being part of the table.

This makes filtering and sorting very cumbersome!

Im not sure why but if the extra data is part of the table it gets shifted quite randomly it seems, everytime the external data is updated - even if there's no change to that data!

Ideally i would like any new data to be inserted on a new row, or failing that just be added at the bottom of the table and i can sort it manually after the update...

Any ideas or suggestions would be greatly appreciated!

Running Win 7 Enterprise, Office 2010 Pro Plus, and SharePoint Online (Plan 1)

Regards,

Heath

Hi, do you mean you wonder the excel only appear the parts of data in Sharepoint list which are changed but not the whole data?