cancel
Showing results for 
Search instead for 
Did you mean: 

BPC EPM Add-in and Office 2013

Former Member
0 Kudos

Hi Experts,

is Microsoft Office 2013 supported by BPC 10 / EPM Add-in?

I can not find any notes about this subject.

Thank you and kind regards

Tobias

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Tobias,

As of now, the support is as below:

1. Office 2003 in Sp07 and above

2. Office 2007

3. Office 2010 (32 bit only). 64 bit is supported in SP09 and above

Hope this helps.

Former Member
0 Kudos

Dear Nilanjan,

Whether EPM Add-in is supporting Excel 2013??


I am installing BPC10 EPM Add-in in window 7 MS Office 2013 with patch SP14 I am getting the below error . Kindly advise.

thanks in advance for your kind response.

Regards
,

Srinivasan.V

0 Kudos

Hi Srini,

Did your problem resolve? I am having the same issue as you did. Please advise.

Thanks

H.Nguyen

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Huong,

Can you please post a new forum question stating:

Exact version of EPM Add-In, office and operating system.

Thanks,

John

Answers (15)

Answers (15)

Former Member
0 Kudos

Hi all ,

BPC netweaver is working with O365 Setup with the below patch.

with regards

suraj

Former Member
0 Kudos

Hi,

See note:

1855186 - ALL: Windows 8, Office 2013 and Internet Explorer 10 Support


Solution

Microsoft Windows 8, Microsoft Office 2013 and Microsoft Internet Explorer 10 are supported in Support Package 14

Hope it helps, worked for us.

Jaco de Kock

Former Member
0 Kudos

SP14 was a first attempt and not worked for everyone, e.g. http://service.sap.com/sap/support/notes/1965149

Full support (including 64-bit Office) starts from SP20: http://service.sap.com/sap/support/notes/2130246

Former Member
0 Kudos
Former Member
0 Kudos

I had faced issue with connecting to BPC 10.1 using Excel 2013 - EPM-Addin, I had encountered error "EPM General error " Unable to connect to server". Some of the above comments were helpful but had not resolved the issue. Steps followed to resolve

Ensured 1 .Net 4.0 is installed

             2. XML Parsor 6.0

             3. Visual C++ 10.0 relevant for windows OS installed

             4. 1. Epm addin  10.0 SP22 is installed

Even after this encountered error " Unable to connect to server". I had make settings in the Antivirus software as it was blocking the applications. launch Antivirus software and click on Network threat protection, Click on application settings and enable settings for .Net, Excel and Word, SAP to successfully connect to server. Hope this info helps.

Former Member
0 Kudos

Please see below:

Former Member
0 Kudos

Dear Experts,

Whether EPM Add-in is working on Excel 2013??

I am facing issue with updating my EPM SP12 to SP14.


My system configuration is windows 7 and Msoffice 2013 . when I try to upgrade to SP14  I am facing the below issue.

Your inputs will be very helpful . Thanks in advance.

Regards,

Srinivasan.V

Former Member
0 Kudos

Can any one suggest how to over come ?

Former Member
0 Kudos

Hello everyone,


I recently discovered there are two versions of the EPM Add-in on the SAP Service Marketplace:

1. EPM Excel Client for 10.0

2. EPM Big Vol Excel Client for 10.0

I uninstalled my existing EPM add-in (which I had installed from my server) and deleted the install folders completely. I then downloaded and installed the latest EPM Big Vol Excel Client and it works without any issues. I will continue using it and see if any issues pop up and post them here.


Regards,

Aditya

former_member182766
Contributor
0 Kudos

Big Vol is for .NET 4 and standard is for .NET 3.5

Different naming.

I would suggest using Big Vol.

Former Member
0 Kudos

Hi guys,

I Have updated my EPM Addin from SP12 to Sp14 , where as all my formulas are getting disappear when I try to change the context and do refresh.

Kindly Advise.

Regards,

Srinivas

Former Member
0 Kudos

HI Ajay,

Kindly Do the  Referesh Metadata  for Current Connection and clear Meta Data Cache and again login

hope this Helps

Regards

Bhupendra Arya


uh12e4
Newcomer
0 Kudos

I cannot access this link.  What note is this referencing.  Thank you

Former Member
0 Kudos

Cannot access the fix link. Thank you

Former Member
0 Kudos

I can't access the link. Could you email the info to me?

Former Member
0 Kudos

Hi Cesar,

We have received feedback (including the comments below) that this URL does not work.  I have no difficulty viewing this link, and it seems to have almost 600 views.


To those with difficulty, please make sure you are logged into the SCN forum.  If you still have an issue, please reply to this comment with a screenshot of the error.

The blog does address a third-party solution to Office 2013 installation issues caused by VBA. It is not a solution supported by SAP. SAP recommends that you install the latest Support Package (SP18), which also includes support for Office 365.

Regards,

SCN moderator

Former Member
0 Kudos

Good morning from California SAP friends: My solution was taken down by SCN moderators. I do not remember being told why. I will go ahead and figure out how to repost it. Please note: my solution was for a VBA issue associated with *some* Office installations, mainly the versions that were digitally delivered, (download vs convention cd installation) Make sure as the SCN moderator suggested you are on the latest SP which is SP18. I will post shortly.

Former Member
0 Kudos

Hi Cesar,

We didn't take down your solution. Please let me know if you are getting an error of this sort. For me, the URL opens correctly.

I do however believe that the solution is now somewhat outdated, and if anyone has issues of this sort in SP18 Patch 1, they should create a new post.

This post was created in March 2013. I will lock it shortly to ensure that it does not have conflicting and outdated suggestions.

Thanks,

Andrew

SCN moderator

Former Member
0 Kudos

Hi Andrew,

I have tried to access the link today, but I've got the error below:

Former Member
0 Kudos

Haven't forgotten this... please see below. If this is an urgent matter preventing progress at work, please send me a private message.

(I originally posted this April 11, 2014... I do not know why moderators took it down)

Former Member
0 Kudos

Hi Andrew, could you provide an SAP source (note, post, etc) that supports this:

SAP recommends that you install the latest Support Package (SP18), which also includes support for Office 365.

I'm searching for what SAP has to say about it but have found only these notes:

  • 1999305 - Microsoft Office 365 users are unable to install SAP EPM Add-in
  • 1721724 - Does BPC support Office 365


Both of them conclude it's not supported but users have reported to have done this succesfully, but would like to know the official SAP version. Thanks!

andrewdiaz2000
Active Participant
0 Kudos

Guys,

with excel 2013 epm add in is working fine. try to get the latest EPM Add in. My observation is some of the features are not all perfectly implemented. hope it take some time for excel 2013 with epm add. but if you want to get used to the latest one it works fine.

Decision is up to  to you.


Regards,Andrew

former_member224107
Participant
0 Kudos

It could be working fine with Excel 2013 , but I am using also Windows 8. So I am not sure what is the cause of the EPM add-in slowing down and crashing. Are you using Excel 2013 on windows 8 ?

former_member224107
Participant
0 Kudos

I have experience using Excel 2013 with BPC NW and BPC MS (64-bit) , running on windows 8. It is indeed running with the latest support packs, but still it is not workable on a project. Excel seems to crash in many occasions and the EPM add-in response times become very long after a while. Then you re-start Excel and the performance is back to normal , but temporary.

So I recommend not to use Excel 2013 with the BPC EPM Add-In.

Former Member
0 Kudos

Thanks! That's really what I needed to hear. I have a VM setup with Win 7 and Office 2010 and its all normal now.

andrewdiaz2000
Active Participant
0 Kudos


Hi,

I think without uninstalling the previous version you might have over written office 2013. some how its not working something. try following the approach suggested by chavarria and let us know if you face any problem.

And right now I am using EPM Add in SP17 which is compatible with 2013 so u need to check is your EPM add in is compatible with office 2013 or not.

Regards,

Andrew.

Former Member
0 Kudos

Hi Andrew,

I was informed previously that the SP14/15 was only able to be used in MS Office 2013 Pro edition and not Home Edition due to the availability of Visual Basic for Application.

Therefore, would like to confirm from your experience whether SP17 is able to be used with Office 2013 Home Edition?

Sorry to have ask you this as I am unable to open the release notes.

Thanks a lot.

andrewdiaz2000
Active Participant
0 Kudos

Hello,

Yes you can try ..hopefully it has to work.

Regards...Andrew


Former Member
0 Kudos

Hi Andrew,

Already downloaded and try to install but the problem is the same. It requires VB for Application 2013. Is this because I am using home edition?

For your information I am using Window 7 and MS Office 2013 Home Edition.

Thank you.

andrewdiaz2000
Active Participant
0 Kudos

Hello,

I am using Window 8 with excel 2013.

but you try with the below steps.

1.go to control panel and select add remove programs.

2.hear you should be able to find your office installed on your PC

3.select your installed office and then say add remove components.

4.go to office shared features and then select vb for applications and select it to run from your pc.

Hope this will help.

Regards,

Andrew.

Former Member
0 Kudos

Dear Andrew,

I've tried but I am unable to find the add/remove button. I was informed by our IT personnel that our MS Office 2013 is click-to-run version and not retail version.

In this version I am only able to uninstall or change. Uninstall will uninstall permanently while change only have quick repair and online repair option. There is no option to go to shared features.

Please advice.

Thank you.

Zalifah.

Former Member
0 Kudos

Former Member
0 Kudos

HI Zalifa,

kindly Install the Visual C++ Runtime setup for 2013.

it will work. i tried this with Office and it worked

Regards

Bhupendra

former_member434568
Discoverer
0 Kudos
Former Member
0 Kudos

No luck yet. I verified I have .NET Framework 4.0 installed as well as having a supported version of Office - I have Professional Plus 2013. Found this error when trying to manually load it in Excel Options->Add-Ins->Manage COM Add-Ins.

former_member434568
Discoverer
0 Kudos

We have find similar errors with some computers, what we have done is:

  1. Uninstall EPM-Add In
  2. Uninstall Office
  3. Reinstall Office
  4. Update Office
  5. Install EPM-Add In

It had work in almost every case we had, but to be honest haven't tried it with Office 2013.

0 Kudos

We have BPC for Microsoft as well.

When we had that 2007 error occur some time ago as shown up above during attempting to install 64 bit add-in (bigvol), SP14 I think, Office 2010, we had luck in one instance by uninstalling and reinstalling Office and in another instance, we just reloaded the original Windows workstation image and it magically decided that was good enough - the add-in install went off without a hitch after installing the required MS components for Visual C++ 2010+ and .net 4.0 (which only ever happens on the 64 bit installs).  We figure that something in Windows had gotten corrupted.

We've found the 32 bit add-in to be much more stable than the 64 bit one, and the latest SP18 to be the best overall both for Office 2013 and 2010.  We've been recommending to our business units to install Office at 32 bit if they have a choice, regardless of what their O/S is because the BPC add-in for Microsoft Platform always works perfectly in the 32 bit Office installations.  Most casual business users will never notice a difference between the two other than BPC freezing up less frequently.

One final mention on Office 2013:  While it works fine for us at this time, it's really only with the latest SP18 +  add-in installs.  The older add-ins froze and disabled themselves frequently.  One thing our users noticed with Office 2013 is that it doesn't natively support having multiple sessions where one is connected and another not connected.  However, there's a workaround we found.  I think if I recall, it's opening up an Office app (i.e. Excel), then down in the Windows task bar, hold down Alt and right-click to open another window.  That will open up a discrete session as opposed to it's native single session.

Oh!  Also, we learned that the add-in allows you to "upgrade" or "repair" by simply reinstalling it over itself.  So if you want to updatee your add-in version, there's no need to uninstall it first.  I know this is so for the 32 bit.  Not sure on 64 bit.

Former Member
0 Kudos

Hi

Microsoft Office 2013 supported by BPC 10 / EPM Add-in in BPC 10 Service Pack 14

Present we r using  (upgrade your service pack to 14)


pls find the related note


1823786 - Does SAP BPC support Windows 8 and Office 2013?

Former Member
0 Kudos

Hey Tobias,

as of now, SAP BPC will support Windows 8, Office 2013 and IE 10 with EPM add-in for Microsoft Office SP14.

Please see SAP Note 1787849 further informations.

Hope, this information will help you.

Best Regards,

Karsten

former_member224107
Participant
0 Kudos

Hi Karsten,

we have installed the big vol. edition SP14 for windows 8, latest patch. We are running excel 2013 64 bit on windows 8.  The EPM add-in doesn't load.

Former Member
0 Kudos

I got a runtime error when I tried to manually load the EPM add-in on Excel. I am running Excel 2013 64-bit on Windows 8.1 64-bit. I am using EPM Excel Client SP16 Patch1.

praveen_jagadeesan
Contributor
0 Kudos

Hi,

Please refer note no Note 1779357 - Business Planning & Consolidation 10.0 NW SP10 Central Note

Got msg from SAP official support Office 2013 after BPC 10NW SP 10 version and above.

Regards

Praveen Jagadeesan

Former Member
0 Kudos

Hi

I just checked SAP Note - SAP Note 1855186 - ALL: Windows 8, Office 2013 and Internet Explorer 10 Support.

It stated that Office 2013 is supported for EPM add-in 10.0 SP14 onwards.

Has anyone tried that Excel 2013 works or not. I need to know.

Thanks

Jigar

Former Member
0 Kudos

Hello Tobias,

Please have a look at Note1823786 - Does SAP BPC support Windows 8 and Office 2013?

Kindest regards

Former Member
0 Kudos

Hello,

Just tried to check SAP note 1823786 and it seems it was not released yet. Is that right?

Thanks,

Joel

0 Kudos

Dear Joel, may i get your EPM Add-In Plunggin for MS2013? My e-mail address is [email address removed, not permitted]. Thank you very much!

Message was edited by: SCN moderator Reminder: All SAP files must be downloaded from the SAP Service Marketplace

Former Member
0 Kudos

Hi Marc, hi Nilanjan,

thank you very much for the answer.

Kind Regards

Tobias

Marc_Kuipers
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Tobias,

No, only Microsoft Office 2007 or 2010 is supported.

Thanks

Marc