尝试使用Excel数据创建仪表板时出现问题 [英] Problems trying to create a dashboard with Excel data

问题描述

我正在尝试使用Excel电子表格中的信息在SharePoint Designer中创建电话列表"仪表板.我有通过PerformancePoint连接的电子表格，但我需要显示的列被包含数据的列广泛分隔 我不想显示.到目前为止，我还没有找到获取所需信息的方法.我尝试使用过滤器，但不知道如何设置它，也找不到任何信息...这不是用户友好的!!这是我第一次创建仪表盘，所以 在完成此操作时遇到问题.

I'm trying to use information from an Excel spreadsheet to create a Phone List dashboard in SharePoint Designer. I have the spreadsheet connected via PerformancePoint, but the columns I need to display are widely separated by columns that contain data that I DO NOT want to display. So far, I have NOT found a way to get the needed information in. I tried using a filter, but don't know how to get it set up, and can't find any information...it is NOT user-friendly!! This is my first time creating dashboards, so am having problems with getting this done.

我需要通过仪表板执行此操作，以便在更新Excel工作表时，电话列表也将自动更新(由于周转率"和超过100名员工).

I need to do this via a dashboard, so that when the Excel sheet is updated, the phone list is automatically updated, as well (due to "turnover" rate, and over 100 employees.)

推荐答案

嗨IceFireVS-几个选项:将Excel工作表导入到SharePoint列表中，然后维护该列表.或者，将Excel工作表连接到列表，但删除不想显示的列表中的信息列.

Hi IceFireVS- couple options: import the Excel sheet into a SharePoint list and maintain the list instead. Or, connect the Excel sheet to the list, but remove the columns of information in the list that you don't want shown.

这篇关于尝试使用Excel数据创建仪表板时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！