How to know the location of open excel?

Use below formula to know path of open excel file.

=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

Just copy the above formula and paste into your excel file

and see the Magic

• Here is my folder named "Excel Trick" containing my excel file where we will apply the formula

• Here is excel screen shot - Magic Applied