Report is cleaning content of my template

Hi,

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…

Regards,
Gent

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!

Thanks!

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.