Sharepoint Linked File Causing #Value Error
I should explain better... HEre is what one of my cell formulas looked like
when it was first created:
=SUMIFS('[Program Tracker.xlsm]Detail'!$M:$M,'[Program
Tracker.xlsm]Detail'!$A:$A,"="&$D$6,'[Program
Tracker.xlsm]Detail'!$O:$O,"=No",'[Program
Tracker.xlsm]Detail'!$F:$F,"="&$C30,'[Program
Tracker.xlsm]Detail'!$U:$U,""&$D$2,'[Program
Tracker.xlsm]Detail'!$U:$U,"<="&$D$3)
Here is what it looked like after I saved the first file, then re-opened it:
=SUMIFS('C:\Documents and Settings\pklocke\My Documents\01-IT
Optimization\Planning\[Program Tracker.xlsm]Detail'!$M:$M,'C:\Documents and
Settings\pklocke\My Documents\01-IT Optimization\Planning\[Program
Tracker.xlsm]Detail'!$A:$A,"="&$D$6,'C:\Documents and Settings\pklocke\My
Documents\01-IT Optimization\Planning\[Program
Tracker.xlsm]Detail'!$O:$O,"=No",'C:\Documents and Settings\pklocke\My
Documents\01-IT Optimization\Planning\[Program
Tracker.xlsm]Detail'!$F:$F,"="&$C30,'C:\Documents and Settings\pklocke\My
Documents\01-IT Optimization\Planning\[Program
Tracker.xlsm]Detail'!$U:$U,""&$D$2,'C:\Documents and Settings\pklocke\My
Documents\01-IT Optimization\Planning\[Program
Tracker.xlsm]Detail'!$U:$U,"<="&$D$3)
Figured a "picture" might explain better than I did...thanks!
Patk
|