Forum Discussion
Excel Formula works in desktop, but not web.
Hello -
I have a formula that automatically pulls the Excel tab name into a call. It works great in the desktop program, but I get a Value error when using the formula in Excel on the web. Here is the formula: =MID(CELL("Filename",I7),SEARCH("]",CELL("Filename",I7),1)+1,32)
Thoughts?
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
2 Replies
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))
