| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking formula to external spreadsheet
I am trying to link a sumif formula to an external spreadsheet and when the
external spreadsheet is open it works no problem. However, as soon as I close the external spreadsheet and refresh the data it shows only #VALUE!. This is very frustrating, is there anyway to get rid of this and have the link work properly. Where I have linked to an external spreadsheet using = and linking to a specific cell the problem does not exist. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Formula Help (new to Spreadsheet) | Excel Worksheet Functions | |||
| Formula Help (new to Spreadsheet) | Excel Worksheet Functions | |||
| How to use same formula throughout the spreadsheet?? | New Users to Excel | |||
| I want to update the formula in a spreadsheet from 04 to 05. Is . | Excel Worksheet Functions | |||
Threaded Mode
