File Location No Longer Displayed Under File Name on File/Info Page

jimsinoregon

New Member
Joined
Jun 23, 2019
Messages
2
Morning,

I'm hoping the title of my post explains my questions. If not, maybe my attachment will. In short, on older versions of Excel the location of the file used to be displayed under the file name. Knowing that helps me to decide if I want to click "Save" or "Save As". Small issue, but big pain when I have to do it many times a day. Any idea how to have the "Info" page display the file location as well as the file name?

Thanks....Jim

Link to photo attachment: https://www.dropbox.com/s/381s1ngu3o61zn9/info page.JPG?dl=0
 

jimsinoregon

New Member
Joined
Jun 23, 2019
Messages
2
Morning Dave,
It's part of Microsoft Professional Plus 2019 and it says it's Microsoft Excel 2019.
Thanks,
Jim
 

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
3,819
I do not have Excel 2019; consequently, I may not be able to help too much.

You could consider a possible workaround.

On any or all sheets in your workbook, use a formula that shows the full filename in a cell.

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">D:\Excel14\[T201906a.xlsm]3c</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:1.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">3c</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F1</th><td style="text-align:left">=CELL(<font color="Blue">"filename",A1</font>)</td></tr></tbody></table></td></tr></table><br />
 

Forum statistics

Threads
1,085,838
Messages
5,386,265
Members
401,989
Latest member
romandavis

Some videos you may like

This Week's Hot Topics

Top