HI everyone,

I added code in the "Advanced Excel" module that allow me to create/update/delete named ranges.

These functions are working sometimes but apparently they aren't if I have a pivot table that has a named range as a reference. If i try to update/change/delete the named range that is used by the pivot table, the file gets corrupted and can't be openned by Excel.

here is my code : 

I saw related post on stackoverflow, i have exactly the same issue and the given solution is not working for me.

My excel template is stored in the resources in the "DATA" tab.

If anybody can help me ! 

Kind Regards


Hi Lucas

I am looking into this issue for you.