| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
linked values not displayed unless source file open
i have an excel sheet with cells linked to cells in another seperate excel
file. Excel will not show the values unless I have the source file open. this always used to work with the source file closed. Now the target file shows #value. this is a major nuisance if there are 7 or 8 linked files! please help. Sandy |
|
#2
|
|||
|
|||
|
There are some worksheet functions that don't work with closed workbooks.
=indirect(), =countif(), =sumif() are a few. If you share your formula, you may find that there's an alternative that you can use. Sandyc wrote: i have an excel sheet with cells linked to cells in another seperate excel file. Excel will not show the values unless I have the source file open. this always used to work with the source file closed. Now the target file shows #value. this is a major nuisance if there are 7 or 8 linked files! please help. Sandy -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how could I import a text file with comma separated values into ex | Excel Worksheet Functions | |||
| How do you open a template at startup? | Excel Discussion (Misc queries) | |||
| Creating Linked Workbook file name using cell variables | Excel Worksheet Functions | |||
| displayed cell values | Excel Worksheet Functions | |||
| Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions | |||
Hybrid Mode
