Forum Discussion
Link part of file name to Excel cell
I would like to link part of the filename to part of a cell. The name of the Excel file is Excel Mar Sample. The string in an Excel cell is "MTD Mar CY2021". I would like to like the Mar in the filen...
Dear Hans, When I save the filename say to Apr, the output still shows Mar.
Unfortunately, that formula isn't updated automatically, you have to do that manually.
Here is another version. It uses a helper cell.
This time it is an ordinary workbook (not macro-enabled).
HansVogelaar Even though I saved as Apr, the link could not be updated.
- Excel recalculates prior to saving the workbook, not immediately after (if it did, and something changed, then it would prompt the user to save it again before closing because it changed since the last save operation and could create a confusing cycle for the user). But, it will update when next excel calculates (if you save the workbook, then enter a value in any cell you will see it update). Also, it should update when the file is closed/reopened.
Excel in Teams is actually Excel for web. It doesn't support VBA and GET.DOCUMENT function, as well as cell("filename"). Moreover, link on the current file, if check it in File->Info, starts from "https://...".
So far I don't know the way to receive the filename in Excel Online, if maybe with Office Scripts.
I cannot explain that, sorry.
And I don't know anything about SharePoint, so I cannot help you with that.
- This will basically reside is Sharepoint/MS Teams. Can it still run?
