[PowerPivot]設計筆記-發佈SharePoint Excel不支援功能列表
最近在做報表時發現有部份的功能會造成Screenshot圖出不來原因為使用了SharePoint Excel Services不支援的功能.找了很久資料終於讓我找到一篇文章寫到這樣子的內容.
Excel Services 十二大不支援Excel 好用的功能
Excel Spreadsheets that will not load on the first version of Excel Services
Spreadsheets that contain one or more of the following features will not load in Excel Services.
- Spreadsheets with code. This includes spreadsheets with VBA macros, forms controls, toolbox controls, MS 5.0 Dialogs, and XLM Sheets.
- IRM-protected spreadsheets
- ActiveX Controls
- Embedded SmartTags
- PivotTables based on “multiple consolidation” ranges
- External references (links to other spreadsheets)
- Spreadsheets saved in formula view
- XML expansion packs
- XML Maps
- Data validation
- Query Tables, SharePoint Lists, Web Queries, and Text Queries
- Spreadsheets that reference add-ins
- Spreadsheets that use the RTD() function
- Spreadsheet that use spreadsheet and sheet protection
- Embedded pictures or clip art
- Cell and Sheet background pictures
- AutoShapes and WordArt
- Ink Annotations
- Organization Charts and Diagrams.
- DDE Links
以上內容參考來源為 <http://blogs.msdn.com/excel/archive/2005/12/01/499206.aspx>
及Excel 2007 發佈至SharePoint Excel Services 不支援功能.
http://office.microsoft.com/en-us/excel/HA100217161033.aspx
請大家永躍參與Facebook MSBI 粉思團:http://www.facebook.com/#!/group.php?gid=303757165010