This window can also be found in File -> Info -> Edit Links to Files. Edit Links windowįrom the Data Ribbon click Edit Links button. When opening an Excel file which contains links to other files the following message will be displayed.Ĭlicking Update will update all the links in the workbook, whilst Don’t Update will not retrieve the linked values. If both the linking and linked files are open at the same time, the values will update automatically when a recalculation occurs. Having created a link, the next question is how to update it. That means Excel files can be read without opening them, pretty cool eh? Though, Excel will ask for the password when updating the link to a protected file. Provided you can remember the syntax, it is possible to create a link without even opening a file. When you close the linked file the address will change to include the full file path of the linked file. The formula will look something like this. In a cell type the equals symbol ( = ), click on a cell in another workbook, then press return. Setting a link to a cell in another file is easy, it’s just like linking to any other cell in a workbook. Or if not, at the very least, you’ll be aware of the possible issues. Let’s explore this area and hopefully by the end you will see why it’s so risky. If they knew the risks they might not be so quick. “Look, I’ve linked this so that I don’t have to update a cell, isn’t this cool!”.
So many things can go wrong with linked files, yet unsuspecting users tend to use them with pride. One of the things which scares me in Excel is seeing this message:
0 kommentar(er)
