在线共享和保护 Excel 文档(使用 Powerpivot)，无需 Sharepoint &电源 BI? [英] Share and protect online an Excel document (using Powerpivot), without Sharepoint & Power BI?

问题描述

我的一位客户制作了这个令人难以置信(而且非常庞大)的 Excel 文档，其中包含许多数据源、工作表、Powerpivot 表格、图表等......很棒的工作.

One of my client has made this incredible (and really huge) Excel document with many data sources, sheets, Powerpivot tables, graphs, etc... Awesome work.

他想与授权人员共享，但要保护他的宝贵内容(也就是数据源和文档逻辑").例如，用户可以使用过滤器，但只能在查看模式下使用.

He want to share it with authorized people but protect his valuable content (aka data sources and document 'logic'). Users may be able to use the filters for example but in view mode only.

不幸的是，Sharepoint 不适合我的客户.以下是他对自己的经历的评价:

Unfortunately, Sharepoint is not an option for my client. Here's what he say about his experience:

作为包括 SharePoint Online 在内的 Office 365 产品的一部分，Microsoft 提出了 Power BI 服务.这允许创建一个我们过去用来安装和操作 PowerPivot 工作簿的 Power BI 网站.

As part of its offerings Office 365 including SharePoint Online, Microsoft proposed the Power BI service. This allowed to create a Power BI website where we used to install and operate PowerPivot workbooks.

我已订阅 Office 365(免费试用版)以共享我的文件.这时候才发现创建Power BI的功能站点，需要在 SharePoint 上激活 PowerPivot 工作簿在线，未提出.

I have subscribed to Office 365 (free trial) to share my files. That's when I found that the function of creating a Power BI site, necessary to activate a PowerPivot workbook on SharePoint Online, was not proposed.

我的研究让我质疑，除了网络，Sharepoint 和 Cloud服务供应商.我在网上找到的信息表明旧体验于 2015 年 12 月 31 日结束，有利于新体验，有时间体验老客户迁移到新客户.

My research led me to question, besides the web, Sharepoint and Cloud service providers. I found on the web information indicating that the old experience ended at 31/12/2015 in favor of the new, with a time to experience old customers to migrate to the new.

服务公司已经向我确认微软已经锁定 Office 365 的 Power BI，从而禁止任何新进入者.

Service companies have confirmed to me that Microsoft had already locked the Power BI for Office 365 thus prohibiting any new entrant.

微软力图强调两项优惠:- 服务器上的企业 SharePoint(SharePoint 经典版)，- Power BI 在线(新体验 Power BI).

Microsoft seeks to emphasize two offers: - Enterprise SharePoint (SharePoint classic) on server, - Power BI online (the new experience Power BI).

第一个解决方案很昂贵.第二个还不够先进成为 PowerPivot 的替代品.

The first solution is expensive. The second is not yet advanced enough to become an alternative to PowerPivot.

你怎么看?Jamespot、Alfresco、Huddle、OneDrive Online Excel，......?

What do you think? Jamespot, Alfresco, Huddle, OneDrive Online Excel, ...?

推荐答案

再看看 Power BI :).我们刚刚添加了将 Excel 范围固定到仪表板的功能.http://blogs.msdn.com/b/powerbi/archive/2015/11/24/pin-a-range-from-excel-to-your-dashboard.aspx

Take a look again at Power BI :). We just added the ability to pin Excel Ranges to dashboards. http://blogs.msdn.com/b/powerbi/archive/2015/11/24/pin-a-range-from-excel-to-your-dashboard.aspx

如果您围绕 excel 工作簿构建组织内容包，则可以与用户共享它，而无需与用户共享原始 excel 工作簿.

If you build an organizational content pack around your excel workbook, you can share it with your users without needing share the original excel workbook with your users.

这篇关于在线共享和保护 Excel 文档(使用 Powerpivot)，无需 Sharepoint &电源 BI?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！