Now In the end I tracked this down to the conditional formatting rules. Would you like to answer one of these unanswered questions instead?Clicking on "Home - Conditional Formatting - Manage Rules" brings up the following dialog, which is relatively easy to look through and replace the external references. This chapter takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.In This Chapter Understanding Formula Basics Understanding Operator Precedence Controlling Worksheet Calculation Copying and Moving Formulas Displaying Worksheet Formulas Converting a Formula to a Value Working with Range Names in Formulas Working with Links in Formulas Formatting Numbers, Dates, and Times that perform calculations and produce results.You do this by following these steps: is your source for cost-effective Microsoft Excel training.This tip (7556) applies to Microsoft Excel 2007, 2010, 2013, and 2016.Somehow the link between the 2 has broken and won't update.I have tried to relink the 2 workbooks but still no luck.
The timesheet contains filters which work in alphabetical order and only update until the letter T. Thanks, Brit I've made an excel-file that has many hyperlinks to word-documents.Normally, if you have linked information in your workbook, the information is updated whenever you open the workbook.There may be times when you need to update the links manually, however." when I opened a file How do you stop the current version automatically updating on opening?I always said "no" when I opened a file (File A) then opened the files that I thought File A was linked to.How can I set it so the updates are done automatically.