Microsoft excel is waiting for another application to complete an OLE action
Hi, We are transitioning over to OneStream version 9.0.1. As part of the transition, we are running validations on the data we have copied over from our previous environments. We are running reports like quickviews & XFGETCELLs to retrieve data. However, after clicking on Refresh Sheet/Workbook, we are prompted with the error message: Microsoft excel is waiting for another application to complete an OLE action Does anyone have a solution to this resolve this issue? This is holding us back with our validations, ultimately affecting our go-live date if this issue persists. We would not feel confident going live if this Microsoft Excel error continues to impact our user base from running their reports. For additional context: Microsoft Excel is 64-bit version Excel Add-in version 9.0.1 is installed. Tested on multiple reports along with recreating reports Tested with multiple users/devices34Views0likes3CommentsHELP! Microsoft excel is waiting for another application to complete an OLE action after 8.5 Upgrade
Hello Experts, We have a few users that are getting below error while trying to close Excel windows after OneStream upgrade. Error text "Microsoft excel is waiting for another application to complete an OLE action" Can someone share any insights or guidance on resolution here? Regards, ND488Views2likes14CommentsExcel Crashing-OneStream Add-in
We’ve been getting reports from our users that the Excel add-in is crashing. It happens most often when working with files on shared drives, files that contain links to other files, or larger workbooks. The behavior is inconsistent, sometimes everything runs fine, and then the same test will crash another time. When the same files are stored locally on their machine, the issue is seen less often. However, this isn't a feasible work around with our group. The issue feels more widespread since our upgrade to 8.5.1. We’re currently on Excel add-in version 8.5.1.17017. Curious if anyone else in the community is seeing the same pattern with their users? Would be great to compare notes and see if this might be a broader issue. Thanks for any feedback or suggestions!74Views1like1CommentXFGETCELL #REFRESH
Certain users aren't able to refresh sheet containing XFGETCELL. Only shows #REFRESH. In OneStream task activity, it shows that the task has failed with an error message "Summary: Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1." This should not be related to access since I was able to refresh sheet using another profile with the same roles.64Views1like1CommentNarrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!27Views0likes0CommentsExcel XF() functions - problems with Save Offline Copy feature
All, Does anyone out there have users with massive (thousands of rows and dozens of columns) XFGetCell() workbooks that are seeing issues with the "Save Offline Copy" feature? (and yes, I know.. they should not be creating these massive workbooks in the first place - that's not what XF() is meant to do) Here are the symptoms we're having: Regardless of what the seconds setting is (and I'm not even sure this setting applies to anything other than CV connections or quick views) and for some of these users, it's set to the max allowable, the 'save offline copy' often just spins and spins and never completes or eventually the user just has to 'kill' Excel and try again. Happens at different times so no idea what server activity might be going on at the same time. Save Offline Copy appears to finish but the saved file now contains "#REFRESH" rather than the values Unable to keep Formatting (this has to be set to False) - loses things like superscript or subscript fonts. I have a feeling this has something to do with the built-in behavior with this addin that it wants to refresh everything before saving the offline copy and I suspect it doesn't get to finish that before the save starts to run, but I have no proof of this. Coupled with this is the fact that many of the cells containing the XF() function ALSO contain vlookup() functions which doesn't help I'm sure. We have raised a ticket with OS but it's hard to provide them with a replicated sample given the size of these workbooks. I'm just wondering if anyone else has seen this and what workarounds or resolutions you may have discovered and might be willing to share. Much thanks in advance for any tips.Solved4.3KViews1like5CommentsSave Offline Copy
I'm getting the below error message regarding location when trying to save a file with multiple XFGetCell formulas offline. I've updated my preferences that an earlier question showed as a solution and refreshed the workbook (again) before attempting to save...but am unable to save the file without the formulas. I've tried directly to my desktop, various folders, where downloads go.... I can't find an acceptable location. Any help would be appreciated.184Views0likes4CommentsAlias Dimension Property in V9.1
The newest release (9.1) of OneStream introduces the Alias property for just about all of the dimensions. The only place so far where I have found the Alias as being useful is in search. I have not been able to figure out the correct syntax to be able to use the alias in Cube Views, Quick Views or any business rule. My guess is that we are going to have to create a custom business rule that will allow us to call the Alias name and present in a viewable format. Does anyone have an example of where they have been able to display an Alias value in a Cube View or Quick view instead of displaying the default member name and/or description?Solved101Views0likes4Comments