Is there any way to create a dashboard, and use KPI from a shared doc lib that contain excel sheets ?



I'd recommend migrating your use of Excel Spreadsheets to store the KPIs onto using Custom Lists within the SharePoint platform. There, you will be able to easily produce KPI reporting based on this SharePoint List.

This method is dependent on the requirements of both your reporting and your acquisition of the data used for the KPI, and also the version of SharePoint which you are using, all of which you have not stated, so a realistic and fulfilling solution cannot yet be recommended.

  • how to link the sharepoint list, with a excel sheet column ? – Iyad May 26 '10 at 13:32
  • Once you have created a SharePoint list from a template or with custom columns, you can link to Excel by using the option in the "Actions" menu in the toolbar of the List. – James Love May 26 '10 at 14:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.