I'am looking for following problem I have.
When copying an excell sheet in the same excell map I encounter the following problem:
Excell 2010 is asking if the same name(s) used for the formulas is also to be used for the new sheet. And because I used names a lot in the formulas I used, I have to address every single name before the sheet is copied. This can take a long while and continuous clicking for "yes".

How can I solve this. Or How can I avoid these requests by Excell?
Does anyone know the answer?