H Hamish Member Oct 20, 2014 #1 I have a workbook that I cannot break links to. I have removed all formatting, defined names etc. Even tried some VBA code to no avail. If anyone has any idea how to fix this please let me know. Thanks
I have a workbook that I cannot break links to. I have removed all formatting, defined names etc. Even tried some VBA code to no avail. If anyone has any idea how to fix this please let me know. Thanks
Smallman Excel Ninja Oct 20, 2014 #2 Hi Hamish Do you have charts in the workbook. After trying all the above it is usually the charts that are the issue. Can you post a file if this is not the case? Take care Smallman
Hi Hamish Do you have charts in the workbook. After trying all the above it is usually the charts that are the issue. Can you post a file if this is not the case? Take care Smallman
H Hamish Member Oct 20, 2014 #3 Hi Smallman, No Charts. Workbook Attached. Attachments Unbreakable Links.xlsm 137 KB · Views: 8
Smallman Excel Ninja Oct 20, 2014 #4 Hi Hamish Your problem is on the Sales Estimates sheet. Take that sheet out and the links go away. So copy the values of that sheet make a new sheet and paste the values. Now delete old Sales Estimates tab. Take care Smallman
Hi Hamish Your problem is on the Sales Estimates sheet. Take that sheet out and the links go away. So copy the values of that sheet make a new sheet and paste the values. Now delete old Sales Estimates tab. Take care Smallman
Smallman Excel Ninja Oct 20, 2014 #6 Hi Hamish Sometimes Excel just corrupts and I just accept that a workaround is the only way. I suspect this is what happened to your file. Smallman
Hi Hamish Sometimes Excel just corrupts and I just accept that a workaround is the only way. I suspect this is what happened to your file. Smallman
