SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


share|improve this question
up vote 0 down vote accepted

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.

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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