Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Links to other sheets only work if the sheet is opened
When I link cels to another excel spreadsheet the links stay alive as long as
the othe sheet is open. If not opened the cell consisting the link show #VALUE! How come ? |
#2
|
|||
|
|||
Hi
what is your exact formula -- Regards Frank Kabel Frankfurt, Germany Arnold de Lange wrote: When I link cels to another excel spreadsheet the links stay alive as long as the othe sheet is open. If not opened the cell consisting the link show #VALUE! How come ? |
#3
|
|||
|
|||
Hi,
Unlike Lotus, Excel only likes links when files are open. When creating the link, have source file open and select the cell to link with, this way the full path of the file / cell are captured. Using this method does ensure that when the file that contains the links is open, the option to retain the link is given. Rob "Arnold de Lange" <Arnold de wrote in message ... When I link cels to another excel spreadsheet the links stay alive as long as the othe sheet is open. If not opened the cell consisting the link show #VALUE! How come ? |
#4
|
|||
|
|||
I don't think this is true.
If you link to a closed file, the value should be returned ok. (Although I do like your suggestion to build the formula link (it's easier than getting the syntax correct by hand).) But there are functions that won't work with closed workbooks. =sumif() and =offset() come to mind. Rob wrote: Hi, Unlike Lotus, Excel only likes links when files are open. When creating the link, have source file open and select the cell to link with, this way the full path of the file / cell are captured. Using this method does ensure that when the file that contains the links is open, the option to retain the link is given. Rob "Arnold de Lange" <Arnold de wrote in message ... When I link cels to another excel spreadsheet the links stay alive as long as the othe sheet is open. If not opened the cell consisting the link show #VALUE! How come ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do you have a work in progress sheet | Charts and Charting in Excel | |||
Printing separate sheets on one paper sheet | Excel Discussion (Misc queries) | |||
Updating Automatic links doesn't work with arrays | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |