Report is cleaning content of my template


Do you know if there is a way to prevent removing the content on my template excel, like the content on other sheets ?
This is very inconvenient when I use other sheets for static data to do calculation on my excel…


Hi Gent,

You can create an empty band and named region for the band. Band/named region should be created for each sheet with static data.

Hi Andrey,

Yes, it works!
Ok, everything without a band/named region will be deleted!


Normally, as a users, I would except that everything within the band/named region should except to be changed, everything/region not named should remain the same, especially in other sheets.