Where did I save this file???

One day, a colleague suddenly asked me: “do you know where I saved this file?” by showing me her monitor with the file opened…

Well, the first thing came to my mind was…… well……, input this formula in any blank cell: =INFO(“directory”)

Image

See!  So simple…  But I didn’t do that because that could be too advanced???

There are many other (simple) ways to see the path where the file is saved at.  Just to name two here:

1) File Tab –> Info.  The workbook name and its location are right there, on the top of the Info page.  You may also open the file location as shown in the lower right.

Image

2) File Tab –> Recent (You can see the most recent files and their location)

Image

Do you have other way to do so?  Pls leave your comments.

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Basic, Excel Tips and tagged . Bookmark the permalink.

2 Responses to Where did I save this file???

  1. Anantha says:

    There is another way which gives more information including file name, sheet name along with path
    Try : =cell(“filename”) and enter

    Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.