External links

%3CLINGO-SUB%20id%3D%22lingo-sub-1274734%22%20slang%3D%22en-US%22%3EExternal%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1274734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20creating%20an%20excel%20sheet%20which%20has%20links%20to%20an%20external%20sheet%2C%20but%20when%20I%20re-open%20the%20external%20sheet%20the%20links%20are%20broken.%26nbsp%3B%20The%20spreadsheet%20tab%20name%20being%20reference%20is%20changed%20to%20%23ref.%3C%2FP%3E%3CP%3EI've%20a%20new%20laptop%20with%20a%20new%20version%20of%20excel%20and%20so%20I%20think%20its%20one%20of%20the%20settings%20but%20which%20one%3F!%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1274734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1274909%22%20slang%3D%22en-US%22%3ERe%3A%20External%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1274909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F606081%22%20target%3D%22_blank%22%3E%40Oliverb115%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20you%20can%20check%20the%20links%20below%20on%20how%20to%20fix%20that%20problem%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffind-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffind-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffix-broken-links-to-data-84f494f9-1da9-460a-aa83-aba07108bc97%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffix-broken-links-to-data-84f494f9-1da9-460a-aa83-aba07108bc97%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1274993%22%20slang%3D%22en-US%22%3ERe%3A%20External%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1274993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F606081%22%20target%3D%22_blank%22%3E%40Oliverb115%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlaces%20to%20check%3A%3C%2FP%3E%3CP%3E1.%20formulas%3C%2FP%3E%3CP%3E2.%20Named%20ranges%20in%20Name%20Manager%3C%2FP%3E%3CP%3E3.%20Data%20Validation%20list%20sources%3C%2FP%3E%3CP%3E4.%20Macros%20(in%20another%20workbook)%20assigned%20to%20objects%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275021%22%20slang%3D%22en-US%22%3ERe%3A%20External%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275021%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F606081%22%20target%3D%22_blank%22%3E%40Oliverb115%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFindLink%3C%2FA%3E%20is%20quire%20reliable%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

I'm creating an excel sheet which has links to an external sheet, but when I re-open the external sheet the links are broken.  The spreadsheet tab name being reference is changed to #ref.

I've a new laptop with a new version of excel and so I think its one of the settings but which one?!

Thank you

3 Replies
Highlighted

@Oliverb115

 

Places to check:

1. formulas

2. Named ranges in Name Manager

3. Data Validation list sources

4. Macros (in another workbook) assigned to objects

Highlighted

@Oliverb115 

FindLink is quire reliable