is it always necessary to open workbooks referenced in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
levie said:
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
Click to expand...
files.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Merge Multiple workbook sheets into one workbook 0
#Value replaces formula result when file is opened. But why? 8
referencing cells in different workbooks 2
Copy formulas to another workbook 4
Macro to push data to another workbook 0
summarizing data from various workbooks 3
Variations on referencing a cell in another workbook - continued 4

Back
Top