ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using external references as hyperlinks (https://www.excelbanter.com/excel-discussion-misc-queries/141436-using-external-references-hyperlinks.html)

Jo

Using external references as hyperlinks
 
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

John

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



All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com