| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External References in Functions | Excel Worksheet Functions | |||
| References to external XLS files | Excel Discussion (Misc queries) | |||
| External References in Excel | Setting up and Configuration of Excel | |||
| External References | Excel Discussion (Misc queries) | |||
| External References not working right. | Excel Worksheet Functions | |||
Linear Mode
