External links

[Oliverb115]

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

[#2]

@Oliverb115 

Hello, you can check the links below on how to fix that problem

https://support.office.com/en-us/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-...

https://support.office.com/en-us/article/fix-broken-links-to-data-84f494f9-1da9-460a-aa83-aba07108bc...

[#3]

@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

[#4]

@Oliverb115 

FindLink is quire reliable