|
|
#3
01-19-2023, 03:33 PM
|
||||
|
||||
The Edit Links dialog shows the links in formulas that are easy to find.
Unfortunately there are other places that links can hide that are WAAAYY harder to track down. Also unfortunately, those sneaky links can get added by copy/pasting ranges from other workbooks without first making sure those features are not being used in the copied ranges. The other places that external links might be hiding are in: - Named Ranges - Validation Lists - Conditional Formats
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatic link creation, after writing: Link text in main body (multiple instances) | mike_302 | Word VBA | 2 | 07-05-2021 12:28 AM |
 Converting html link to ms word link
|
myUserNamez | Word | 2 | 01-04-2017 10:47 PM |
| Trying to link page numbers in the footer, but refuses to link after new section | fl0shizzle | Word | 7 | 05-06-2014 12:15 PM |
| How to link an object to a URL link to update automatically | expert4knowledge | Excel | 1 | 06-11-2012 09:30 AM |
| MarkAsFinal - 'Edit Anyway' edit popup issue | GovindRS | PowerPoint | 1 | 06-20-2011 06:43 AM |
Windows 10 
Office 2016
Threaded Mode