Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


Remove Phantom Links Excel

Phantom links are a common problem in Excel. There are a number of method to try and most involve using the DATA, EDIT LINKS tool to find the links. If you can’t find them then look in the named ranges or in graphs, pictures etc.

However, even after all of this you can still have some phantom links. We did lots of searching and found an interesting tool from Microsoft which did the job for us. However, it appears to be an old tool in that it can’t handle the new type of excel file e.g. xlsx. In order to make it work we have to save our file down to Excel 2003, run the tool and then save it back to the correct format. This has risks but it ended our frustration.

You can find the tool at;EN-US;Q188449&

The tool seems to look for

  • Master Formula Links
  • Defined Name Links
  • Hidden Name Links
  • Chart Links
  • Microsoft Query Links
  • Object Links

How to find cells with external links in Excel