Spreadsheet links not updating

Rated 4.21/5 based on 755 customer reviews

Knowing why they're there doesn't always help you find them, though.

Excel 97 doesn't provide the option of searching the entire workbook, but you can search all worksheets in a workbook by grouping them. provide the option of searching within the sheet or workbook.Create a real link between the two by opening both workbooks.Go to the problem workbook and, in any cell on any worksheet, type .First, you need to see whether you have any real external links (nonphantom) that you forgot about.If you are not sure whether you have real external links, start looking in the most obvious place: your formulas.

Leave a Reply