Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,341
I have an xlsm workbook which uses code to create some new worksheets. The code then removes all links with the other sheets, then moves these sheets to a new workbook. It then removes all names in the new workbook. When I check for links in the original workbook I find unbreakable links to the newly created workbook. This means that when I try to save it I'm warned that it contains references to unsaved documents. This not a problem for me, but it will be a problem if I distribute the workbook. The links can only be broken by closing the workbook and reopening it. The imaginary links have then disappeared. I can also import a sheet from another workbook then remove all the original worksheets and the imaginary links still show. If anyone else has come across this issue and found a solution I'd be most grateful to hear it.