| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is it always necessary to open workbooks referenced in a formula
Most of the time I'm building workbooks with formulas referencing to other
workbooks, in order that I have the accurate values, all workbooks linked should be open at the same time, is this how it really works? is there a better way of doing this; that is, an option of not opening the other files. |
|
#2
|
|||
|
|||
|
Here is an example.
'=SUMPRODUCT((MONTH('C:\yourfolderl\[yourfile.xls]CHECKS'!$A$7:$A$1000)=MONT H(A119))*(LEFT('C:\yourfolderl\[yourfile.xls]CHECKS'!$C$7:$C$1000,4)="10yr") *'C:\yourfolderl\[yourfile.xls]CHECKS'!$D$7:$D$1000) -- Don Guillett SalesAid Software "levie" wrote in message ... Most of the time I'm building workbooks with formulas referencing to other workbooks, in order that I have the accurate values, all workbooks linked should be open at the same time, is this how it really works? is there a better way of doing this; that is, an option of not opening the other files. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
| Is there a way to tab between open workbooks? | Excel Discussion (Misc queries) | |||
| open multiple workbooks at startup | Excel Discussion (Misc queries) | |||
| Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
| Excel does not display workbooks open | Setting up and Configuration of Excel | |||
Linear Mode
