happyhungarian
Active Member
- Joined
- Jul 19, 2011
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hi, my current workbook is saying that it contains a data link to an old sheet. I want to remove all previous connections. However, I've Ctrl+F the whole document and find no reference to the worksheet anywhere. I also tried to break the link to it but excel is refusing to. I'm assuming that the link is within a cell that's been Data Validated to a List where the list is contained in the old sheet (from a former copy/paste). Is there a way to find and destroy this old link?!!?
Thanks
Thanks