Software

Ask something
Discussion Locked

Excel File Location bar

0 helpful
11 replies

by lkkjr258

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please help - - - is there a way in Excel to show a location
>bar so you know which drive you are on. I save spreadsheets
>with the same file name on the hard drive and on a diskette as a backup. I open both
to make changes and save.
>I sometimes get confused which one I am on. Is there
>a setup or preferences place where I can set that to show.
>Please help. (I LOVE LOTUS)
>

11 replies

by don christner

If the diskette is only for backup purposes, I do not understand why you would want to open that file to make changes. Open the file on the harddisk, make your changes and then copy that file to the floppy. Why open both?

Don

by lkkjr258

I always start with the hard drive file. Sometimes disk is shared. When I get sidetracked by phones, meetings, etc., I forget which file I am on. Many times changes are intense and I like to back up as I do them.

by syscokid

I think the best you can do is click on File, Properties, and look on the General tab. It shows the location of the file.

by troubleshootergurl

You can create a macro, using MS Excel's Visual Basic. Thats just an idea, good luck with that one. It may be real simple if you have someone start you off.

by sparent

Insert a blank row at the top, then enter the following formula in cell A1:

+CELL("filename")

by kirill lozovatsky

Just add the Web toolbar(View/Toolbars/Web), so in address dropdown list you'll always see the full path to yor file.

This discussion is closed to new replies.