If you don't want it to change then copy the cell with the formula and paste
special as values...

"Constantly Questioning" wrote:

I can get the filenames and paths to show in cells, but I want the filename
and path as proof that a certain spreadsheet was used from a specific
location. All the codes that I have tried change the path as soon as the
spreadsheet is saved to reflect the new location. I need it to stay as a
snapshot of where it was originally, regardless of where it is saved.

Is this possible?

Thanks to anybody who can help.