First time using this Google groups, can't believe this problem is this old.. I have a spreadsheet that references a named range on another spreadsheet. I use the data validation to save entries to one page. Once completed, I copy/move the ss I made my entries in and save as a new file. Each time the spreadsheet is opened it prompts to update, was never able to get break links to work (Excel 2010). Tried the Clear All for Data Validation, Ctrl+F3 to delete names, etc, but was never able to break the link. Every time I opened the file I got the update prompt.

Until I saved the file as Excel 97 - 2003, now when I open the file, no prompt to update the link I could never break. Thank you MS for leaving this problem in existence for so long.