| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link from other source file is not working
File 1 has a trial balance on it for May08
File 2 has a trial balance on it for June08 File 3 has a trial balance on it for July08 Separate File 4 has 3 columns representing the 3 months of trial balance numbers. using SUMIF formula - If the first 3 files are not open first, then when i open the File 4 it has #VALUE! - everywhere ? If I open the first 3 files, everything links up properly. Question: Does the source file alsways have to be OPEN for the linked sheet to work ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
link from other source file is not working
For most, if not all, functions to work on ranges in other files, the other
files have to be open. You can LINK to a cell or range of cells and Excel will pull the value in even if the other file is closed "karen-acctg" wrote: File 1 has a trial balance on it for May08 File 2 has a trial balance on it for June08 File 3 has a trial balance on it for July08 Separate File 4 has 3 columns representing the 3 months of trial balance numbers. using SUMIF formula - If the first 3 files are not open first, then when i open the File 4 it has #VALUE! - everywhere ? If I open the first 3 files, everything links up properly. Question: Does the source file alsways have to be OPEN for the linked sheet to work ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
link from other source file is not working
Thank you so much for your reply. I have been batting my head against the
wall with this thing. Many thanks, Karen "Duke Carey" wrote: For most, if not all, functions to work on ranges in other files, the other files have to be open. You can LINK to a cell or range of cells and Excel will pull the value in even if the other file is closed "karen-acctg" wrote: File 1 has a trial balance on it for May08 File 2 has a trial balance on it for June08 File 3 has a trial balance on it for July08 Separate File 4 has 3 columns representing the 3 months of trial balance numbers. using SUMIF formula - If the first 3 files are not open first, then when i open the File 4 it has #VALUE! - everywhere ? If I open the first 3 files, everything links up properly. Question: Does the source file alsways have to be OPEN for the linked sheet to work ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel #Value! Error on external link, when source file closed | Excel Discussion (Misc queries) | |||
| Pivot Table Source Link changed when file saved to SharePoint site | Excel Discussion (Misc queries) | |||
| Can I find what files link into a source file in Excel? | Excel Worksheet Functions | |||
| Link Word form to Excel source file | Excel Discussion (Misc queries) | |||
| Use a cell's value to set the source file name in link | Excel Worksheet Functions | |||
Linear Mode
