Excel Formula works in desktop, but not web.

[Dave Galy]

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?

[#2 · Accepted solution]

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

[#3]

@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]TRANSAC...;$J3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;$K3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;$L3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;N$2);SUMIFS('https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;$J3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;$K3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;$M3;'https://d.docs.live.net/2adca01099c820b1/Documentos/JERO/Trading/MASTERS/[_MASTERSHEET_.xlsm]TRANSAC...;N$2))