how can you find the discover the automatic links to information in another excel2000 workbook?
Please Note: This commodity is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If y'all are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Uncovering and Removing Links.
Please Note: This commodity is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If y'all are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Uncovering and Removing Links.
Uncovering and Removing Links
It tin can be frustrating to open up an Excel file and be continually asked if you want to update linked information, particularly if you are not sure what information is linked. If y'all want to get rid of links in a workbook, there are several things to try.
Kickoff, choose Links from the Edit menu, if the option is available. (It will only be available if Excel recognizes explicit links in the workbook.) From the resulting Links dialog box you cannot delete links, just you can alter the links so that they point to the electric current workbook. When you afterwards save and once again open your workbook, Excel will recognize the self-referential links and delete them.
Another way y'all tin find links is to search for either the left bracket ([) or correct subclass (]) in your workbook. The brackets are used by Excel when putting together the links to other files. For instance, this is a link to an external file, as it would appear in a jail cell:
=[Book1.xls]Sheet1!$D$7
When you observe links like to the above, all you demand to practice is delete them. Make sure that yous search each worksheet in your workbook.
Some other place to wait for links is in the defined range names maintained past Excel. This is a peculiarly common place for links if you are working with a workbook that contains worksheets that were copied or moved from other locations. The defined names, rather than pointing to a cell range in the current workbook, could be pointing to a range in a different workbook. Choose Insert | Proper noun | Define to display the proper dialog box. Then footstep through each defined name, examining the address to which it refers. Delete or alter any that refer to other workbooks.
Another identify to check is your macros. It is possible to assign macros to toolbar buttons (older versions but) or to graphics in a worksheet. Click on any custom toolbar buttons or graphics and see if you get an error. If y'all practise, this is a good indication that the button or graphic is linked to a macro independent in a unlike file. If you delete the push or graphic, or change the macro consignment, the link trouble should go away.
Still another possible location for wayward links is in PivotTables. When you create a PivotTable, information technology can refer to data on a different worksheet in your workbook. If you later motion that source worksheet to a different workbook, your PivotTable will be linked to the external data source. The but solution here is to delete the PivotTable, copy the source data back to the current workbook, or move the PivotTable to the external workbook.
Finally, y'all should bank check graphs and charts. If you recently moved worksheets out of your current workbook into another workbook, it is possible that charts and graphs remaining in your current workbook now refer to information on a worksheet y'all moved to another workbook. If this is the example, you will need to either remove the graph or chart, move it to the other workbook, or copy the source information dorsum into the electric current workbook.
ExcelTips is your source for toll-effective Microsoft Excel training. This tip (1925) applies to Microsoft Excel 97, 2000, 2002, and 2003. You lot tin find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Uncovering and Removing Links.
Source: https://excel.tips.net/T001925_Uncovering_and_Removing_Links.html
Posted by: smithelifuldn2000.blogspot.com
0 Response to "how can you find the discover the automatic links to information in another excel2000 workbook?"
Post a Comment