- #How to find external links in excel mac 2011 mac os
- #How to find external links in excel mac 2011 install
- #How to find external links in excel mac 2011 update
#How to find external links in excel mac 2011 install
I have kept the ….dmg files for both hence a clean install was possible. I also clean installed Microsoft Office 2011 and applied the latest update.
#How to find external links in excel mac 2011 mac os
I have certainly loaded Excel and all appears to work, but I mostly use Word.Īlso in case this is relevant to anyone I clean installed Mac OS Mojave. If this is the case, you will need to either remove the graph or chart, move it to the other workbook, or copy the source data back into the current workbook.Greetings to you all and please accept my apologies for the late reply. 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 data on a worksheet you moved to another workbook. The only solution here is to delete the PivotTable, copy the source data back to the current workbook, or move the PivotTable to the external workbook.įinally, you should check graphs and charts. If you later move that source worksheet to a different workbook, your PivotTable will be linked to the external data source.
When you create a PivotTable, it can refer to data on a different worksheet in your workbook. Still another possible location for wayward links is in PivotTables. If you delete the button or graphic, or change the macro assignment, the link problem should go away. If you do, this is a good indication that the button or graphic is linked to a macro contained in a different file. Click on any custom toolbar buttons or graphics and see if you get an error. It is possible to assign macros to toolbar buttons (older versions only) or to graphics in a worksheet. Delete or change any that refer to other workbooks.Īnother place to check is your macros. Then step through each defined name, examining the address to which it refers. Choose Insert | Name | Define to display the proper dialog box. The defined names, rather than pointing to a cell range in the current workbook, could be pointing to a range in a different workbook. This is a particularly common place for links if you are working with a workbook that contains worksheets that were copied or moved from other locations. Make sure that you search each worksheet in your workbook.Īnother place to look for links is in the defined range names maintained by Excel.
When you find links similar to the above, all you need to do is delete them.
For instance, this is a link to an external file, as it would appear in a cell: The brackets are used by Excel when putting together the links to other files. When you later save and again open your workbook, Excel will recognize the self-referential links and delete them.Īnother way you can find links is to search for either the left bracket () in your workbook. (It will only be available if Excel recognizes explicit links in the workbook.) From the resulting Links dialog box you cannot delete links, but you can change the links so that they point to the current workbook. If you want to get rid of links in a workbook, there are several things to try.įirst, choose Links from the Edit menu, if the option is available.
#How to find external links in excel mac 2011 update
It can be frustrating to open an Excel file and be continually asked if you want to update linked information, particularly if you are not sure what information is linked.
0 kommentar(er)
