a printing date and time, or a path in one sheet:

1. Select Page Layout -> Print Titles (in Page Setup Group) -> Header/Footer tab.
2. Select Custom Footer.
3. Select a section and click the Tab, File, Path, Time and Date commands, and then click OK.


or a path to all the sheets in a workbook:

1. Select a sheet tab, right click and select Select All Sheets.
2. Follow the steps above.
3. Select the sheet tab, right click and select Ungroup Sheets.