Forum Discussion
Excel Formula works in desktop, but not web.
Hi Dave,
"filename"
Filename (including full path) of the file that contains reference, as text. Returns empty text ("") if the worksheet that contains reference has not yet been saved.
Note: This value is not supported in Excel Online, Excel Mobile, and Excel Starter.
https://support.office.com/en-us/article/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf
Hi Dave,
|
"filename" |
Filename (including full path) of the file that contains reference, as text. Returns empty text ("") if the worksheet that contains reference has not yet been saved. Note: This value is not supported in Excel Online, Excel Mobile, and Excel Starter. |
https://support.office.com/en-us/article/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf
SergeiBaklan I am having a similar issue with a similar formula. My formula is a IF(SUMIFS()) formula, referencing another workbook. Is there any workaround or alternative formula to solve this issue? because I need to make this a shared workbook, and although it works perfectly on desktop, I cant figure a way to make it work on web.
The formula is the following:
=IF($M3=0;SUMIFS('https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$K$6:$K100000;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$A$6:$A$100000;$J3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$F$6:$F$100000;$K3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$G$6:$G$100000;$L3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$D$6:$D$100000;N$2);SUMIFS('https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$K$6:$K$100000;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$A$6:$A$100000;$J3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$F$6:$F$100000;$K3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$H$6:$H$100000;$M3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSACTIONS'!$D$6:$D$100000;N$2))
