Many a times we open the file but don’t know where the file was actually been saved or need complete location of the file… to able to do this pls rfer below formula
very simple formula which can be very useful for you..
Just type >>>>> =CELL("filename") <<<<< in any cell and
it will give you the complete address in the file itself
likewise you can use many functions with this formula (refer image below)