View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Martin
 
Posts: n/a
Default Ascertaining whether external data sources or hyperlinks exist

Hi all

Is there an easy way to ascertain whether an Excel workbook has
external data sources through the Excel interface? I can, for example,
ascertain that a workbook has links because Links is enabled on the
Edit menu.

Similarly, is there a way to ascertain whether an Excel workbook uses
any hyperlinks?

I know how to do each of the above through VBA, but I want a means for
non-technical users to ascertain.

Thanks in advance

Paul Martin
Melbourne, Australia