Excel 2007 & Integrated Planning workbooks

[Former Member]

Hi,

I am working with Excel 2007 and have a problem in combination with IP based workbooks. Each time I open a IP based (input) workbook my Excel 2007 session is freezing. It doesn't happen with normal reporting workbooks when these are opened in Excel 2007. So the problem is really IP based.

I switched off virus scanners, windows firewall, installted the newest Bex FEP,... but this didn't help. The probleem seems Excel 2007 related since other collegues with similar SAP patch levels and older Excel versions don't have this problem.

Does anyone have any idea ?

[lucimar_moresco]

Hello

What are your FEP and system version and patch level?

Have you tested your frontend instalation using note 1013202?

Lucimar

[Former Member]

Hi,

Pls find if this is helpful.

https://websmp106.sap-ag.de/~sapidb/011000358700000091442008E/NWBIandMSFTExcel2007integr.pdf

Regards

Shyam

[Former Member]

Hi,

Excel 2003 works well with the Analyzer.

We too faced many problems when our MS office was upgraded to 2007. Hence, we reverted back to 2003.

Now we don't have any problems.

Regards,

Srinivas Kamireddy.

[Former Member]

Hi,

What is the newest FEP that you have installed?

Following is an excerpt from Product Management - Netweaver BI:

Vista & Office 2007 support (Stack 12, only as of BI 7.0 ADDON FOR SAP GUI 7.10Patch 1!)

��BEx 7.0 (2004s) Tools support for combination of GUI 7.10/Windows Vista/Office 2003

��BEx 7.0 (2004s)Tools support for combination of GUI 7.10/Windows Vista/Office 2007

��Remark: newfilesformat(OfficeXML) notsupportedyet(Stack14)

��Please note that BEx7.0 (2004s) tools won’t besupported for Vista in combination with GUI 6.40

��Please note that BEx7.0 (2004s) tools won’t besupported for Office 2007 in combination with GUI 6.40

Best Rgds

Shyam

[Former Member]

Hi,

Just try setting your macro security to low and check both the boxes to trust all sources in the next tab of the security screen.

Does this help any bit?

Regards,

Aby