Excel Add-in: Restore Connection after module rename

Manuela_Apostol
Certified Master Anaplanner

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. 

 

 

Manuela_Apostol_0-1633526727057.png

https://community.anaplan.com/t5/Best-Practices/Best-Practices-About-Excel-Add-In/ta-p/65668

 

Thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
Manuela_Apostol
Certified Master Anaplanner

Re: Excel Add-in: Restore Connection after module rename

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 

 

View solution in original post

4 REPLIES 4
anand.shekhawat
Super Contributor

Re: Excel Add-in: Restore Connection after module rename

@Manuela_Apostol 

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

Manuela_Apostol
Certified Master Anaplanner

Re: Excel Add-in: Restore Connection after module rename

Is this something Anaplan support can further assist on this and re-store the broken connection?  

Bliayang
New Contributor

Re: Excel Add-in: Restore Connection after module rename

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

 

Manuela_Apostol
Certified Master Anaplanner

Re: Excel Add-in: Restore Connection after module rename

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 

 

View solution in original post