Excel Add-in: Restore Connection after module rename
Hi all,
Is there a way of restoring a connection to a module via Excel Add-in after the module has been renamed? the re-map functionality does not work either (model ID is the same) .
My connection stopped synchronizing and the only change is the module name and I found below restriction on Best Practices for Excel Add-in.
https://community.anaplan.com/t5/Best-Practices/Best-Practices-About-Excel-Add-In/ta-p/65668
Thank you
Best Answer
-
Dear all,
Thank you for your input here, unfortunately none of the solutions proposed are working because what I have experienced is in fact a known issue. @anand.shekhawat @Bliayang
The bug is that Excel is crashing when performing a "send and refresh" after remapping the workbook connection. The workaround at this moment is by remapping the connection, saving and closing the workbook, and then reopening the workbook before performing the "send and refresh." Luckily this is on the roadmap to be fixe with the next release
Kind regards,
Manuela Apostol
1
Answers
-
Unfortunately No. Renaming a module is a major change I don't think there is any way to restore the connection.
#Open for inputs
~Anand
https://in.linkedin.com/in/anand-shekhawat-35645486
0 -
Is this something Anaplan support can further assist on this and re-store the broken connection?
1 -
To restore the connection after a module rename, you will need to remap the connection.
** Make a backup of your original workbook before remapping the connection
- Open the workbook with the Addin's connection which the module name had changed- Click the 'Remap" icon
- Select the module that was renamed
- Click 'Remap' button
- Click "Refresh" to confirm that the remap connection is working
- Save your updated workbook
0
