I'm needing to create a default in Excel so that every new workbook that is
created up in my department, automatically has the path & file name displayed
in the footer of every sheet.

I've tried setting up a template, but I can't seem to make it work.