In Sheet Action Buttons Disappearing/Greyed Out
Good afternoon, I was wondering if anyone has had the issue of In-Sheet Action Buttons turning grey and not working within the excel add in. The environment is 8.5.1, using the 64 bit version of excel, and has the updated excel add in. When using the in sheet actions within the spreadsheet tool, there are no issues with the Buttons and the DM steps run as expected. When opening up in Excel, the first button is greyed out and does not initiate any tasks, while the green button still works. If anyone has any resolutions, I would appreciate it. Thanks, Ben81Views0likes2CommentsMicrosoft 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/devices44Views0likes3CommentsHELP! 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, ND493Views2likes14CommentsExcel 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!78Views1like1CommentXFGETCELL #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.68Views1like1CommentNarrative 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!!30Views0likes0CommentsExcel 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.4KViews1like5CommentsSave 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.188Views0likes4Comments