jeffmoseler
Well-known Member
- Joined
- Jul 16, 2004
- Messages
- 540
I have an Excel spreadsheet linked to another spreadsheet that is giving me errors. The formula looks like this:
=IF(E3="","",(SUMIF('C:\Documents and Settings\Jeff\My Documents\B & G\[QB Report.xls]2006 Sales'!$K$3:$K$1000,E3,'C:\Documents and Settings\Jeff\My Documents\B & G\[QB Report.xls]2006 Sales'!$U$3:$U$1000)))
If I open the spreadsheet it asks if I want to update the data and I say yes. All the other formulas update with out a problem, but this one gives me a NAME error. When I open the connected spreadsheet the error goes away and the data fills in. If I close the connected spreadsheet, the error does not come back and the data stays there. How do I make this work without having to open and close the spreadsheet?
=IF(E3="","",(SUMIF('C:\Documents and Settings\Jeff\My Documents\B & G\[QB Report.xls]2006 Sales'!$K$3:$K$1000,E3,'C:\Documents and Settings\Jeff\My Documents\B & G\[QB Report.xls]2006 Sales'!$U$3:$U$1000)))
If I open the spreadsheet it asks if I want to update the data and I say yes. All the other formulas update with out a problem, but this one gives me a NAME error. When I open the connected spreadsheet the error goes away and the data fills in. If I close the connected spreadsheet, the error does not come back and the data stays there. How do I make this work without having to open and close the spreadsheet?