So we are still using version 3.0 and have created multiple spreadsheets that use data pulls using the Excel Add in. But now the spreadsheet always gives us "cancelling process" whenever we try to re-fresh. This happens even after logging out and then logging back in at a different time of day.
Are download sheets created with v3.0 no longer usable, even though we are still on release 3.0 and haven't upgraded to 3.1?
would you please document somewhere how to remove a connection from a sheet? Or even better add an user interface way to remove it?
There seem to be some named ranges so it seems that when deleting them and deleting the lines with the data from Anaplan would probably remove the connection but it's very hackish and non transparent way to do it.
We use SSO through Okta, and recently have had some users have issues downloading the 3.1 add-in. They successfully go through the download process, but then Excel quits and won't reopen until they remove the add-in.
We use PingIdentity and haven't been able to use the add-in since the release of v3.1. While our Excel does not crash, we cannot authenticate using SSO and it doesn't make sense for our purposes to make every user an exception user.
Our Anaplan Support team has seen previous issues with using the Excel Add-ins and PingIdentity as an SSO provider.
To successfully utilize the Excel add-in with PingIdentity, further configuration will need to take place, which can be coordinated by our Support team and your internal IT team.
Please submit a support case to Support@anaplan.com and we can begin the process of configuring everything to work with the add-in. Please also include the version of the Excel Add-in that you are currently attempting to login to with the PingIdentity SSO provider. (Example: Excel Add-in v3.0)
Our internal team has been working with support since the first day the Excel Add-in v3.1 was released, without creating exception users which defeats the purpose of SSO, we are unable to use the Excel Add-in within our organization. Excel Add-in v3.0 received too many complains around error messages that users stopped using it, and when Excel Add-in v3.1 was rolled up those users uninstalled v3.0 and installed v3.1.
We did also experience issues with SSO using Excel Add-in v3.0 which were reviewed with the Anaplan support team and resolved. New issues occurred as soon as we installed v3.1.
If there is a workbook inside of the above folder path, you can either move this workbook to your Desktop for safe keeping until v3.2 of the add-in is available, or you can delete this workbook to resolve the issue.
I recommend the first option of moving the workbook to your Desktop as this will not delete all of your macros that you worked hard to setup in Excel.
Once v3.2 of the add-in is released, the macro crashing issue should be resolved and this workbook can then be moved back to the "C:\Users\user name\AppData\Roaming\Microsoft\Excel\XLStart" folder location.
If the above information does not address your particular crashing issue, or you are still having issues with Excel and the add-in, please submit a support case to Support@anaplan.com and we can further troubleshoot the problem.