vanhunk
10-26-2012, 12:30 AM
Hi There,
I have discovered something very interesting and I would like someone to explain it to me.
What I have discovered is, that as long as there is a formula, any formula, somewhere in a workbook that has a result of "#REF!", formulas that use "cell("filename",A1)" anywhere in the formula will be updated before the file is saved under a new name, while saving.
In other words the "cell("filename",A1)" formula is already updated with the new name in the saved version. Without the "#REF!" formula, the saved version still has the old file name and only updates when the file is opened again. :think:
It is actually quite useful.
Thanks
I have discovered something very interesting and I would like someone to explain it to me.
What I have discovered is, that as long as there is a formula, any formula, somewhere in a workbook that has a result of "#REF!", formulas that use "cell("filename",A1)" anywhere in the formula will be updated before the file is saved under a new name, while saving.
In other words the "cell("filename",A1)" formula is already updated with the new name in the saved version. Without the "#REF!" formula, the saved version still has the old file name and only updates when the file is opened again. :think:
It is actually quite useful.
Thanks