Bill Herde
asked on
Excel link hell
I am having a problem with Microsoft Excel not opening links to a network location.
The cell contains the following.
=SUMIFS('\\servername\9 - FOLDER\P P G, Inc\Billing Invoices and Settlement\1809\[UUT PPG-201810.xlsx]UUT Details'!$J:$J,'\\serverna me\9 - FOLDER\P P G, Inc\Billing Invoices and Settlement\1809\[UUT PPG-201810.xlsx]UUT Details'!$A:$A,RIGHT(A47,2 ),'\\serve rname\9 - FOLDER\P P G, Inc\Billing Invoices and Settlement\1809\[UUT PPG-201810.xlsx]UUT Details'!$D:$D,RIGHT(H1,10 ))
And it will not work.
However if I open the file being referenced in the link in the same excel instance, the cell contents automatically change to
'=SUMIFS('[UUT PPG-201810.xlsx]UUT Details'!$J:$J,'[UUT PPG-201810.xlsx]UUT Details'!$A:$A,RIGHT(A47,2 ),'[UUT PPG-201810.xlsx]UUT Details'!$D:$D,RIGHT(H1,10 ))
and it starts working.
Any ideas what would keep it from working with the file still closed? Path is verified correct. Tried full quotes on pathname.
The cell contains the following.
=SUMIFS('\\servername\9 - FOLDER\P P G, Inc\Billing Invoices and Settlement\1809\[UUT PPG-201810.xlsx]UUT Details'!$J:$J,'\\serverna
And it will not work.
However if I open the file being referenced in the link in the same excel instance, the cell contents automatically change to
'=SUMIFS('[UUT PPG-201810.xlsx]UUT Details'!$J:$J,'[UUT PPG-201810.xlsx]UUT Details'!$A:$A,RIGHT(A47,2
and it starts working.
Any ideas what would keep it from working with the file still closed? Path is verified correct. Tried full quotes on pathname.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for quick response.