| 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 ? |
| 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 | |||
Threaded Mode
