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,
ND
Hi, I'd suggest raising a support ticket. You may get lucky with someone having seen the same issue, but Support can work with you (screen share, local specificities etc) to resolve the issue. Thanks
Hi ND,
Were you able to resolve this issue? We have just upgraded yesterday and several users are experiencing the same thing. I wonder if you have found the cause and have been able to resolve this. I would like to know the fix for this before creating a case to OneStream support.
Thanks in advance.
Brgds,
Cherish
Hi Cherish,
Unfortunately, there is no magic bullet. After working with our IT and OS Support, we concluded that Office 64 bit is a must for OneStream Excel add-in to work smoothly. OS doesn't have a 32-bit compatible MSI and the documentation was confusing on 64-bit being nice to have vs mandatory. We have initiated discussion with OS customer rep to see if they can release a 32-bit version.
There is a temp workaround where users can log-off OneStream on the excel add-in before closing files OR they can keep one excel session open all the time. Though it does get annoying after a while.
Hope this helps.
Regards,
ND
Thanks ND for the quick reply. Any feedback from OS customer rep when will they release for 32-bit version?
Yup, we are currently doing the workaround as you pointed out but pretty annoying.
Brds,
Cherish
I came here looking for help with the exact same issue :)
We upgraded from 8.2.3 to 8.5.1 two days ago and I have had at least a dozen complaints from users with the same issue. I have instructed then to try logging off prior to closing the file but old habits are hard to break. I will also raise a support ticket for this. Maybe if they have tickets from both of us it will get more attention.
Our users have also noticed the reappearance of an old issue. In an older version of the add-in there was an issue where you would "save as offline copy" but it would still have the formulas. This seemed to resolve itself in a more recent version but it back again with 8.5.1
Thank you
Denise
Hi Denise,
We have also raised a ticket and just like ND, we are pushing for 32-bit version as many of our applications are compatible with 32-bit (a bit archaic).
As regards your "save as Offline copy" issue, is your settings in Preferences for Retain All Formatting when Saving Offline set to TRUE? It works for me, no issues.
In regards to the MSI, I feel like there is an issue to be corrected even without publishing a 32-bit MSI. Prior to upgrading to 8.5.1 this week, we were on 8.2.3. Installer was 64-bit and users were using it with 32-bit office with no issue. So, why does the issue all of a sudden appear when upgrading to 8.5.1? (Not expecting you to answer that). Even for me (I have 64-bit office) Excel now takes about 60 seconds to close if I do not log out of the add-in first. I do not get an error but have a long delay in Excel closing.
Denise
