So, I've got a pretty serious workbook going on with some calculations for pricing of one of our product lines....All was great until yesterday.

I created a Quote sheet for the user to fill out with drop down boxes, then proceeded to use the "move/copy" function to add additional sheets.....what I noticed is that when I filled out say sheet 10, it would have adverse effects (fill out) other sheets......So, I then deleted all the copied sheets, inserted new blank sheets, and only copied over the pertinent information for each new sheet.....I find though that I'm still getting this.....Please see the Snippets below if they help. I'm wondering if there is some general setting for this?

Thanks in advance!

Quote error.JPG


Quote Error 2.JPG