Data Analysis in Excel 6 - Fix Broken Links in Excel and Check Data Connections to Other Files
HTML-код
- Опубликовано: 11 ноя 2009
- Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.
This Excel Video Tutorial shows you how to diagnose, check, and repair external data connections between multiple workbooks in Excel. You will learn how to check the status of a connection to see if it needs to be repaired or updated and then how to search your computer to find the correct Excel workbook to which you need to link in order to fix the original workbook.
This is a great tutorial to view if you often work with workbooks that reference external workbooks for information and you need help troubleshooting some problems. In essence, this tutorial teaches you how to edit the links within your workbooks.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!
Thank you. It was so helpful
I learn something new each time i saw your videos. Thanks!
How to completely remove any reference (if attached) ?
Hey, great work on here. I also wanted to ask how to navigate the teach excel website so I could download the files for your videos, I am having an issue finding them, thank you.
@photastegood The worksheet might just be protected. That could prevent you from editing it. If you're in Excel 2007 go to the Review tab and click the button "Unprotect Sheet." If that doesn't work just private message me on here and I'll see what I can do.
I have yearly files in separate folders by year. Once the year is over, how can I save the linked data, so that in no longer has to refer to the link? As the previous years will no longer be changing. (am I wording this correctly?)
@photastegood Yes, that would also cause the problem you mentioned. After the trial the software only views files.
Great work
useful
By any chance, could it be locked because my Microsoft Office Trial could have ended?
I have a bad link. I cannot break link, change source, nothing to remove from the workbook. The old file is probably deleted. I've attempted to ctrl + f after revealing formulas in the workbook to locate any cells with that original source to no avail.
Are there any methods to just get rid of old links? I have to click through the update pop up box everytime I open this file which will equate to hundreds of times in the coming year alone.
im also facing the same problum but no one is helping here plz help
Hi there,
And what if the link is on a SharePoint? How can I select it when it is not located on my PC?
Thanks in advance.
My Excels was working perfectly yesterday, but when I uploaded it to add more information, it says the modification is not allowed because the selection is locked. So now I can't type anything. Mind helping me?
Status is no showing okk even after applying this
When i try to open link on excel onedeive i get the message : "Sorry, we couldn't open this link. The link address may be invalid, or you may not have permission to open it."
Please help me
Good video but tiring in reading because of rapidity.
Slow down.