Breaking SharePoint link in Excel not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1405285%22%20slang%3D%22en-US%22%3EBreaking%20SharePoint%20link%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405285%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20user%20who%20has%20a%20workbook%20stored%20in%20SharePoint.%26nbsp%3B%20She%20made%20a%20copy%20of%20it%20for%20a%20new%20year%20but%20the%20new%20one%20keeps%20saying%20there%20are%20links%20to%20the%20old%20sheet.%26nbsp%3B%20It%20doesn't%20specify%20cells%20just%20the%20SharePoint%20path.%26nbsp%3B%20I%20can't%20find%20any%20linked%20cells%20and%20if%20we%20break%20the%20link%20it%20comes%20back%20next%20time%20she%20opens%20the%20new%20sheet.%26nbsp%3B%20I%20have%20a%20workaround%20(to%20refresh%20the%20links%20to%20an%20empty%20SS)%2C%20but%20it's%20not%20great.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20ideas%20why%20it%20does%20this%20and%20how%20to%20stop%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1405285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1405291%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20SharePoint%20link%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405291%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F256434%22%20target%3D%22_blank%22%3E%40kathryndillon_4693%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20to%20check%20the%20named%20ranges%2C%20data%20validation%20lists%20and%20conditional%20formatting%20options%20also.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1453180%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20SharePoint%20link%20in%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F232473%22%20target%3D%22_blank%22%3E%40erol%20sinan%20zorlu%3C%2FA%3EThat%20worked%2C%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKathryn%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a user who has a workbook stored in SharePoint.  She made a copy of it for a new year but the new one keeps saying there are links to the old sheet.  It doesn't specify cells just the SharePoint path.  I can't find any linked cells and if we break the link it comes back next time she opens the new sheet.  I have a workaround (to refresh the links to an empty SS), but it's not great.

Any ideas why it does this and how to stop it?

 

Thanks

2 Replies
Highlighted

@kathryndillon_4693 

You can try to check the named ranges, data validation lists and conditional formatting options also.

Highlighted

@erol sinan zorluThat worked, thanks.

 

Kathryn