Professor Excel

Comments 4

  1. Bob Fleming

    I get my filename and path by inserting

    =cell(“filename”) and it put it right where I want it (next to bottom row in spreadsheet so it shows when I print) . However, as I am working with several spreadsheets, the filename changes to the last spreadsheet worked with, so I constantly need to re-insert the correct filename. Very frustrating.

    Any solutions to stop my filename from changing. It should always reflect the corret filename for the spreadsheet I am working on, once I have inserted after the first time.

    Kindest,

    Bob

  2. Ben Moy

    Move the formula down 1 line; then, copy and ‘paste values’ in the original cell before you print.

  3. Khoder Seif

    I’ve made a reference in one cell to another one which is in another file (this file is located in another place).
    the Problem is ( sometimes it refer it as in harddisk H:, othertimes as //EVA/EAR) so it couldn’t make the update of the data (and it doesn’t complain that he didn’t find the path)

    Vlookup(TV$2;’\Eva\EAR\Daten\……….
    Vlookup(TV$2;’H:\Daten…….

Leave a comment