Open a file in Excel 2007 from the MRU list and there seems to be no way to figure out where that file actually lives on the disk. How can I determine the path of the file that is opened?
2007-07-06 06:33:34 · 4 answers · asked by romulusnr 5 in Computers & Internet ➔ Software
Just do a "Save As" and it will open to the directory where the file resides. You don't actually have to save the file again, just click "Cancel".
2007-07-06 06:38:13 · answer #1 · answered by rand7263 2 · 0⤊ 0⤋
Inside of a spreadsheet: Tools | Options | General | Default file location
2007-07-06 06:38:25 · answer #2 · answered by Ms Common Cents 5 · 0⤊ 0⤋
Open the file again, then do a "save as" this will show you the path.
Alternative is to look at the properties for the file when it's open. (file/properties)
2007-07-06 06:36:50 · answer #3 · answered by I Like Stories 7 · 0⤊ 0⤋
Do "save as" There is also a way to add it to the header and footer so that will work. Also, there is a formula that you can add in the cell of the worksheet itself to display the path.
=INFO("directory") -- returns path of the current directory or folder.
2007-07-06 08:10:50 · answer #4 · answered by Nadia M 2 · 0⤊ 0⤋