Hi guys,
I'm having a little trouble with excel and would appreciate if anyone could help me out! I'm trying to reference a cell in a pivot table in another spreadsheet with a =GETPIVOTDATA funtion. My forumla currently looks like this:
=GETPIVOTDATA("Products",'D:\cc68\Desktop\[report1.xls]Daily store ordering SUMMARY'!$C$90,"RO_NAME","UŞAK ","State","n/a","Division2","GIDA DIŞI BAKKALİYE","Percent of shelf full (at time of order calc)","a. 0% to 5%")
The problem is the spreadsheet I'm looking the data up from needs to be open in order for the formula to work, even after i've referenced the file directory name. Does anyone know how the formula can work when the lookup spreadsheet is closed?
Any help would be great
I'm having a little trouble with excel and would appreciate if anyone could help me out! I'm trying to reference a cell in a pivot table in another spreadsheet with a =GETPIVOTDATA funtion. My forumla currently looks like this:
=GETPIVOTDATA("Products",'D:\cc68\Desktop\[report1.xls]Daily store ordering SUMMARY'!$C$90,"RO_NAME","UŞAK ","State","n/a","Division2","GIDA DIŞI BAKKALİYE","Percent of shelf full (at time of order calc)","a. 0% to 5%")
The problem is the spreadsheet I'm looking the data up from needs to be open in order for the formula to work, even after i've referenced the file directory name. Does anyone know how the formula can work when the lookup spreadsheet is closed?
Any help would be great