Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

If I add a new row in excel, I want to sync that with KPI list

  Asked By: Garrett    Date: Feb 26    Category: Sharepoint    Views: 1786

I’m not able to add the columns in KPI list, it always shows 4 columns, I need to add extra column to that & I want to have KPI list automization from excel sheets. I don’t want to create the list items one-by-one, I need to create multiple items from excel and if I add new row in excel I want to sync that with KPI list. Is that all possible?



1 Answer Found

Answer #1    Answered By: Thomas Davis     Answered On: Feb 26

The out-of-the-box KPI List has such a specialized function that your added column  won’t get displayed in the view. Could you please kindly let me know what column do you want to add?

And you cannot use Excel to update the KPI List without low level programming. A workaround it to use the Actions->Open with Access and choose “link to data on SharePoint site” so that you can edit the KPI List data in Access link table.