Home > SharePoint - TroubleShoothing > Unable to Load Workbook – Excel Services MOSS 2007

Unable to Load Workbook – Excel Services MOSS 2007


Olá! Smile

Overview:

Visitando um cliente essa semana. Encontrei este cenário, onde algumas planilhas não carregavam no Excel Services.

Cenário:

Podemos usar o Excel Services, no MOSS 2007, para mostrar informações tanto estáticas quanto dinâmicas. Apenas precisamos ter cautela com os recursos que colocamos na planilha, alguns muito avançados não vão rodar. 

ERRO:

Unable to Load Workbook – The workbook that you selected cannot be loaded because it contains features that are not supported by Excel Services.

A planilha que tentamos abrir no Excel Services possuía, neste carro, PivotTables muito avançadas. :S

SOLUÇÃO:

Caso, ainda sim, seja necessário abrir a planilha via Excel Services, precisamos remover qualquer recurso que o Excel Services não suporte. Aqui vai uma lista de alguns deles:

  • Code. This includes workbooks with VBA macros, form controls, toolbox controls, Microsoft Excel 5.0 dialog sheets, and XLM macro sheets.

clip_image001Note:

Excel Services supports user-defined functions that are written in managed code. Native code add-ins like XLL files are not directly supported. However, you can use "wrappers" to call the native code functions. 

  • Information Rights Management (IRM) protection.
  • ActiveX controls.
  • Embedded smart tags.
  • PivotTables report with multiple consolidation ranges.
  • External references (workbooks that contain links to other workbooks).
  • Workbooks saved in formula view.
  • XML expansion packs.
  • XML maps.
  • Data validation.
  • Query tables, SharePoint lists, Web queries, and text queries.
  • Workbooks that reference add-ins.
  • Workbooks that use the RTD() function.
  • Workbooks that use workbook and worksheet protection.
  • Embedded pictures or clip art.
  • Cell and sheet background pictures.
  • AutoShapes and WordArt.
  • Ink annotations.
  • Organization charts and diagrams.
  • DDE links.

Documentação completa hein: http://msdn.microsoft.com/en-us/library/ms496823(v=office.12).aspx – Unsupported Features in Excel Services

Abraço!

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: