[Excel]Storage name and path of a spreadsheet

Last update on June 19, 2009 11:01 AM by jak58
Published by netty5

[ExcelStorage name and path of a spreadsheet







The tip below will show you how to automatically show the storage path and the name of any spreadsheet

Enter in a cell (E.g cellA1) the following formula:

=cell("filename", A1)


Upon this, at each backup and/or moving files on your computer (or another), this formula will indicate the full path, file name and name of your worksheet sheet.

This line can be included in the repeated lines in your printer settings to find the digital version of an impression, and this is valid even if the file has been saved several months ago.
Best answers for « Storage name and path of a spreadsheet » in :
[LAN] - Finding another computer’s name using IP Show[LAN] - Finding another computer’s name using IP Issue Solution Issue I need to find the computer name of one PC connected in LAN (joined to domain). I have the IP address of terminal. How to find the computername? Solution To...
Restrict display user name on login screen ShowRestrict display user name on login screen Under Windows XP, if you log on classic session without the welcome screen, the open window will request the username and password. As default, the name of the last user of the computer will...
Forcing a domain name with the hosts file Show[Networks]Forcing a domain name with the hosts file Intro Locating the hosts file Tips Intro The hosts file primarily allow you to manually set the IP address for a host present on the network spotted by a domain name.
Download HP USB Disk Storage Format Tool ShowHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable). This software works with all keys and readers MP4 of the market. To make work this utility under Windows...
Download USB Mass Storage Show
Download Intel Matrix Storage Manager ShowThe driver Intel ® Matrix Storage Manager supplies a high capacity RAID support high and tolerates mistakes (RAID-5 and RAID-10) for ATA Serial disks of machines on base of chipsets Intel ® P965, 975X, 955X and 945. It also supplies the support...
Motherboard ShowIntroduction to motherboards The primary component of a computer is the motherboard (sometimes called the "mainboard"). The motherboard is the hub which is used to connect all of the computer's essential components. As its name suggests,...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
DNS (Domain Name System) ShowWhat is DNS? Each computer directly connected to the Internet has at least one specific IP address. However, users do not want to work with numerical addresses such as 194.153.205.26 but with a domain name or more specifically addresses (called...
They need your help