I have a spreadsheet that has the whoami function in a
cell that enters the file name and path into the cell on
the spreadsheet. The function reads "whoami0" when I
select the cell. When I move the file to a new folder the
file name and path are not updating. What am I doing
wrong ?

Dave

Dave,

There is no built in WhoAmI function in Excel. I assume it is a
function written in VBA. Why it returns the incorrect information
depends on what the code is. There is a built in function that
will return the complete filename and sheet name:

=CELL("filename",A1)

Leave "filename" in the function as shown; don't change it to any
specific file name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dave the architect" <(E-Mail Removed)> wrote
in message news:ca2d01c438ed$76e3ed30$(E-Mail Removed)...
> I have a spreadsheet that has the whoami function in a
> cell that enters the file name and path into the cell on
> the spreadsheet. The function reads "whoami0" when I
> select the cell. When I move the file to a new folder the
> file name and path are not updating. What am I doing
> wrong ?
>
> Dave