In Excel desktop you can use the formula =CELL("filename",A1) to extract the filename of the workbook. However when the workbook is opened in Excel Online, it only returns #VALUE .
I have already had to modify the complete formula I use so it caters for Excel desktop opening a local file (C:\USERS\...\filename.XLSX") and when opening it on Onedrive (uses forward slashes and starts "http....").
Does anyone know a way to extract the spreadsheet's filename when opened in Excel Online? Or even better - one formula that handles all 3 "filename" constructs?
I have already had to modify the complete formula I use so it caters for Excel desktop opening a local file (C:\USERS\...\filename.XLSX") and when opening it on Onedrive (uses forward slashes and starts "http....").
Does anyone know a way to extract the spreadsheet's filename when opened in Excel Online? Or even better - one formula that handles all 3 "filename" constructs?
