View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Using external references as hyperlinks

Check toolsautocorrect optionsautoformat as you type tab and make sure
there is a tick in the 'internet and network paths with hyperlinks'
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Jo" wrote:

Hi,

Some cells have formulae in them which bring in data from another workbook.
I've seen people open the appropriate workbook just by double-clicking on the
cell. But when I double-click on mine, it just opens up the cell to edit the
formula. Anybody got any ideas?

Cheers
Joe