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.



  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)


Leave a comment

%d bloggers like this: