This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am trying to give users access to SAP BPC over Remote Desktop but struggling with the EPM Excel add-in. It causes Excel to crash.
I am testing it on Windows Server 2016 Datacenter (ver. 1607). First I tried to use it on the Office 365 32-bit and later switched to x64-bit.
I tried the EPMEXCLCLNT33P_3-10011004 version of the EPM (as it supports Windows 2016 Terminal Services). I have also tried the EPMEXCLCLNT38P_6-10011004 with the same results.
There are no add-ins in Excel enabled. In the Excel Trust Center -> Add-ins I do not require Application add-ins to be signed by Trusted Publisher.
I have installed the .NET Framework v 4.8
The Excel was crashing with the application event "Excel is running into problems with the 'fpmxlclient.connect' add-in". I followed the solution at https://launchpad.support.sap.com/#/notes/0002513587.
After I added the <add key="MultiThreadingCalculation" value ="false"/> in the FPMXLClient.dll.config file under the appSetting tag/node, the excel was running OK, but the add-in was not loaded. When I tried to activate the add-in several times in the File -> Options -> add-ins -> Manage COM Add-ins, I got "Not Loaded. A runtime error occurred during the loading of the COM Add-in" information.
I found the symptom described in the KB article at https://launchpad.support.sap.com/#/notes/1681042, but the solution (reinstallation and making sure the registry key is properly set) didn't help. Checked the "Load Behavior" at FPMXLClient.Connect Window’s registry. It was set to 3 as it should.
Surprisingly when I add the user to the local administrators group on the server and the user runs the Excel as administrator (elevated mode), the EPM loads without any problems.
So my suspicion turns into access rights, but cannot find out what and where is missing.
As bonus information, when the user opens the BPC web portal and tries to launch excel from there the "Save file" windows pop up asking where to save the LaunchSAPAO.sapaox file. Even if I associate the sapaox extension with the C:\Program Files\SAP BusinessObjects\EPM Add-In\EpmLauncher.Office.exe it does the same. We use Edge browser v92.0.902.78 x64-bit
Do you have any suggestions which I could use to troubleshoot the issue?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
We encountered this issue, but even when I ran Excel as administrator the EPM would not load. I opened a ticket with SAP support, and their suggestion was to do a full uninstall and reinstall of MS Office. This worked for loading the EPM 38.4 add-in (64 bit).
EPM now launches from SAP BPF without issues in IE. However, I can't launch from the Edge browser as well.
Please let me know if you have any updates to your issue
Hi anonymous user,
As your said this problem will work fine with runs the Excel as administrator, I suggest you check the permission for users access the Add-in source folder, you can go to File- Options- Add-ins and check the location for each add-in:
Make sure users have permission for the folder. Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
HI @Emi Zhang-MSFT Thank you for the suggestion. I have already checked that. 1. Identified the add-in folder: C:\Program Files\SAP BusinessObjects 2. In the folder's properties -> Security - I have given full control permission to Everyone in the domain and Users group on the local server. 3. When running the Excel without elevated permissions it crashed again. In the Event Application log I can see two Errors: Event ID 1026 coming from .Net Runtime > Application: EXCEL.EXE > Framework Version: v4.0.30319 > Description: The process was terminated due to an unhandled exception. > Exception Info: System.UnauthorizedAccessException > at System.IO.__Error.WinIOError(Int32, System.String) > at System.IO.FileSystemEnumerableIterator1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].CommonInit() > at System.IO.FileSystemEnumerableIterator1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.String, System.String, System.String, System.IO.SearchOption, System.IO.SearchResultHandler`1<System.__Canon>, Boolean) > at System.IO.Directory.GetFiles(System.String, System.String) > at FPMXLClient.Logging.ConfigurationFileHelper.DeleteOldFiles() > at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) > at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) > at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) > at System.Threading.ThreadHelper.ThreadStart() Event ID 1000 coming from Application Error: > Faulting application name: EXCEL.EXE, version: 16.0.14131.20360, time stamp: 0x610c3804 > Faulting module name: KERNELBASE.dll, version: 10.0.14393.3085, time stamp: 0x5d1d7c66 > Exception code: 0xe0434352 > Fault offset: 0x0000000000034c48 > Faulting process id: 0x24b8 > Faulting application start time: 0x01d79d81e884674e > Faulting application path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE > Faulting module path: C:\windows\System32\KERNELBASE.dll > Report Id: 26df2e38-0975-11ec-91d0-005056073f99 > Faulting package full name: > Faulting package-relative application ID: I also got an Event from Windows Error Reporting with the following report > Fault bucket 1329130408388434634, type 5 > Event Name: CLR20r3 > Response: Not available > Cab Id: 0 > > Problem signature: > P1: EXCEL.EXE > P2: 16.0.14131.20360 > P3: 610c3804 > P4: mscorlib > P5: 4.8.4410.0 > P6: 60d670fc > P7: 1694 > P8: 12f > P9: System.UnauthorizedAccess > P10: > > Attached files: > \?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER422D.tmp.WERInternalMetadata.xml > > These files may be available here: > C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_EXCEL.EXE_9cce3a694595c183cfb4a4f1c2958820645553bc_00000000_045553ff > > Analysis symbol: > Rechecking for solution: 0 > Report Id: 26df2e38-0975-11ec-91d0-005056073f99 > Report Status: 0 > Hashed bucket: b7731a114cdd64ebe27205107c299aca See attached report. [127508-report.txt][1] [1]: /api/attachments/127508-report.txt?platform=QnA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Hi mziemba,
One thing that's been helpful for debugging access issues in the past for me has been to use ProcMon (https://learn.microsoft.com/en-us/sysinternals/downloads/procmon) to see what's being blocked.
it turned out that there was a C:\temp\%username% folder and users haven’t got access to them. I didn’t investigate why this has been created but giving an access to this folder for each user during login process solved the issue.
Thank you all for great support