Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

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

  Asked By: Garrett Reyes         Date: Feb 26, 2009      Category: Sharepoint      Views: 252
 

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?

Tagged:                          

 

1 Answer Found

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

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.

 


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].