Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2022-07-06 12:07:26 | ![]() 38,687 Views |
When Using formulas in Excel and then copying sheets and creating additional versions of files. Over time we can end up with redundant links. Normally these can be removed by clicking Break Link in the Edit Links dialog.
Sometimes Break Link does not work. This video provides a solution.
The timings of the video.
00:00 – Introduction to break links in Excel
00:12 – Links cannot be updated message
01:24 – Break Link not working
02:49 – Finding the external links
04:59 – Break links to external workbooks
06:12 – Test if the external links exist
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Please take the opportunity to connect and share this video with your friends and family if you find it useful.