Forum Discussion
Updating Excel Table
Hi Concileus,
I do not think your way of adding notes will work. Excel would not be able to remember specific database row you put your notes against, unless these get pushed back to the database. To keep your notes aligned, you would need to add them directly in the SharePoint database. Alternatively, you could add your notes in a separate table against a unique identifier from each row of the SharePoint database, then use INDEX/MATCH formula in the main SharePoint query table to reflect these notes against the respective rows.
Hope this helps
Yury
Hi Concileus,
I do not think your way of adding notes will work. Excel would not be able to remember specific database row you put your notes against, unless these get pushed back to the database. To keep your notes aligned, you would need to add them directly in the SharePoint database. Alternatively, you could add your notes in a separate table against a unique identifier from each row of the SharePoint database, then use INDEX/MATCH formula in the main SharePoint query table to reflect these notes against the respective rows.
Hope this helps
Yury