If I may add two cents that might help someone reading this elderly post, I got the message to not appear by deleting a couple of hidden broken names.

Also, for the less experienced like me, additional to named ranges, look into conditional formatting and data validation settings, if you have any. Often when we copy from other workbooks we forget that those cells might contain these, even if it is from one of our own workbooks, which was my case.