Nov 17, 2015 Re: Save 'myfile. xls' with references to unsaved documents? Did you try and paste values only, or is that not an option? Plus if you delete cols they will still exsist in the ctrl end until the workbook is saved then Excel will recognize the new end.