View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JP[_3_] JP[_3_] is offline
external usenet poster
 
Posts: 168
Default Find External Links

You may have to go through every formula in the workbook to find
links.

Hit Ctrl-G, choose 'Special' and select 'Formulas'.

Then just hit Enter to cycle through all the formulas until you find
it.


HTH,
JP

On Nov 13, 11:27 am, Mike H. wrote:
I have a spreadsheet someone else created. Upon opening, it asks what I wish
to do about external references. Here is what I want to do: I want to find
them. I can go to edit links and see that there are links, but how can I
find the cells that contain the links? Then I can make intelligent decisions
about what to do about them. Thanks....