Your original post did not state that you were trying to put the full path in a
header or footer for printing.

That is why I asked for more detail.

You should be able to group the sheets and get the full path on all sheets.

If you save as a new name and folder your header/footer will update.


Gord

On Fri, 4 May 2007 08:59:04 -0700, Roxy wrote:

I tried it and did a print preview on one of the sheets and it didn't work.
I also tried grouping the sheets and just Inserting full path once. It only
worked on the first tab. Unfortunately, I'm going to have to keep on
inserting full path on every sheet in this workbook
Thanks for your help!

"Gord Dibben" wrote:

More detail please Roxie.

If you are going through FileSave As and entering a new name, the path will be
the same.


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 08:45:00 -0700, Roxy wrote:

Do I need to Insert Full Path again if the spreadsheet I opened and re-saved
with a new one already has that?