sparky2205
Active Member
- Joined
- Feb 6, 2013
- Messages
- 481
- Office Version
- 365
- 2016
- Platform
- Windows
Hi folks,
I have the following formula in a template:
Each time the template is used it is given a sequential number by the system.
I download two of these documents to a network folder, which are now called, let's say, File1 and File2.
I open the two documents in the order File1, File2.
Now they both have the document number File2 in the field where the formula is.
If I open them in the order File2, File1 they both have the number File1 where the formula is.
i.e. whichever document is opened last both documents will take that document number.
It doesn't matter how many documents you have open all documents will take the number of the last document opened.
I feel like I'm missing something simple but I don't know what.
I have the following formula in a template:
Excel Formula:
=MID(@CELL("filename"),SEARCH("[",@CELL("filename"))+1, SEARCH("(",@CELL("filename"))-SEARCH("[",@CELL("filename"))-2)
I download two of these documents to a network folder, which are now called, let's say, File1 and File2.
I open the two documents in the order File1, File2.
Now they both have the document number File2 in the field where the formula is.
If I open them in the order File2, File1 they both have the number File1 where the formula is.
i.e. whichever document is opened last both documents will take that document number.
It doesn't matter how many documents you have open all documents will take the number of the last document opened.
I feel like I'm missing something simple but I don't know what.