Microsoft Excel Question:
Download Questions PDF

When I open a workbook, Excel asks if I want to update the links. I have looked everywhere, and I can not find any links in my formulas?

Answer:

I've never known Excel to be wrong about identifying links, so there's an excellent chance your workbook does contain one or more links--but they are probably not formula links.

* If you have a chart in your workbook, click each data series in the chart and examine the Series formula in the formula bar. If the formula refers to another workbook, you've identified the link. To eliminate it, move the chart's data into the current workbook and recreate your chart.
* If your workbook contains any dialog sheets, select each object in each dialog box and examine the formula bar. If any object contains a reference to another workbook, edit or delete that reference.

If these two approaches don't solve your problem, follow these steps:

1. Select Edit, Links. (In some cases, this command is not available. If you can't select it, skip to step 4.) The Links dialog box will appear.
2. Click the Change Source button and change the link to the active file.
3. Select Insert, Name, Define. Scroll down the list in the Define Name dialog box and examine the "Refers to" box. Delete names that refer to another workbook or that contain an erroneous reference (such as #REF!). This is the most common cause of "phantom links."
4. Save your workbook. When you reopen it, Excel won't ask you to update links.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How can I make text in a cell display in multiple lines?Can I write a formula that returns the number of distinct entries in a range?