This project has moved. For the latest updates, please go here.

How to refresh value of CELL("filename") function

Apr 2, 2013 at 12:41 PM
Hi, I have a set of spreadsheets stored in a repository. I read one of these using EPPlus, and to be able to locate the other spreadsheets, I need to resolve the file path to the current file.

I know it is possible to use the CELL("filename") formula to do this. My problem is that if/when the files are moved to another folder, someone has to open the spreadsheet in excel to "refresh" the value for this function.

So my question is:

Does someone knows if is possible to refresh this value without opening the spreadsheet in Excel, preferably using EPPlus. And if that is the case, please advice how to do it.

Br.
Fredrik