Hey all! I was wondering if any of you came in contact with this "error" when using excel.
I have named cells in another sheet within this workbook. They reference a salary level for each type of class. Each class is also a separate sheet within the workbook.

If I want to run 2 classes with the same name, but different dates, I simply copy the sheet and change the info (date and day and pay month) while having certain fields automatically set.

When doing the copying of the sheet, I always run into this popup. Since I have 20 named references that it goes back to, I get the same popup 20 times, and I'm sick of clicking "yes" on it.

stupid popup image.jpg

Does anyone know of a way to "set" this so that it will automatically "yes"?
I've tried searching about named cells, but nothing tells me about this particular box. And after years of dealing with this nonsense, I'm really quite put out.

Any advice is very welcome! Thank you!!!