Forum Discussion
Automatic update of Cell filename Worksheet name value from one sheet to the other
I've had this issue before. It'll give me the same Value in all the sheets.... But, reference the cell that you're using this for. I have different tabs for different dates and they all USED TO have the same dates until I used Formula Below: ("B1" is the cell I used for this formula) All sheets will update in accordance with your tab name.
=RIGHT(CELL("Filename",B1),LEN(CELL("Filename",B1))-FIND("]",CELL("Filename",B1)))
Hello, everyone, I have the same issue. I am trying to get file name with CELL("filename"). It is working fine, until I save any other file. Then it gives me the name of that other (just saved) file. Was this behavior expected or is it a bug?
I wanted to use date stamp from name of the file in some additional formulas. Like this, I am not able to do that.
Thank you in advance.
Lucia
Windows 10, 64 bit, Version 20H2
You have to rephrase the formula.
Example: Instead of =SUM(BE3:BE37), but = SUM(Sheet1!BE3:BE37).
If your worksheet is called "Sheet1".
There was still an old trick, I don't know if it still works.
In the first worksheet I mark the cells that I want to transfer to another worksheet and press Ctrl-C. Then switch to the target worksheet and mark the target position by clicking in the cell.
Then right mouse button -> paste content
... Now click on the "Link" button at the bottom right in the "Paste content" selection menu.
Then the contents are there, but all cells are references to their origin in the other worksheet.
Create or change a cell reference
A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. Click on the upper Link for more Informations.
Note: Formulas that use CELL have language-specific argument values and will return errors if calculated using a different language version of Excel. For example, if you create a formula containing CELL while using the Czech version of Excel, that formula will return an error if the workbook is opened using the French version. If it is important for others to open your workbook using different language versions of Excel, consider either using alternative functions or allowing others to save local copies in which they revise the CELL arguments to match their language. More informations on the upper Link.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
