Forum Discussion
update Excel File Name (Rename an Excel Sheet), and it auto updates a specific cell in the workbook
mtarler This worked very well, on a local drive, personal computers, etc., but it doesn't work when uploaded to sharepoint? Any ideas?
CELL("filename") is not implemented for Excel Online
SergeiBaklan That would do it! Do you know a workaround?
You may vote for this idea here CELL function added to online – Welcome to Excel’s Suggestion Box! (uservoice.com)
As for the rest I agree with mtarler , it all very depends on concrete scenario how do you work with file.
even if I did, I don't know it would work. file references in sharepoint are, let's say different.
You originally said the problem was that you were e-mailing the file to people and they would save it on their computers and often in the process they would change the name. If it is on sharepoint, why would the name change? What is it that you need this name for? For example, on the desktop you can just give an address to point to other files but in sharepoint due to it being a server and security things (and honestly I guess I don't really know the exact reasons) it isn't that easy. But regardless you are asking for the name of itself, not some other file. I still not clear why.
mtarler I made an estimating program. Each quote/job gets its own copy of this program in a unique folder. In this folder we put all customer correspondence, vendor quotes, etc.. I make these folders (that contain these workbooks) 50 to 100 at a time. They are all numbered consecutively, so I use a "Renaming Program" to do them in batches. When you open the WB, I made a reference cell that looks for that unique number in the name and it auto populates the rest of the book. 95% of our work is done on a company shared drive, and the program works well. The 5% (one specific sheet) needs to be updated real time by the field guys. For this sheet alone, I use a Sharepoint with a link that I post on our on-line scheduling program. That also works well. In the past I just simply saved a sheet, and named it manually. I was just trying to streamline the process. 95% of it works awesome. Looks as if this 5% may not work.
