Steps: By default, new workbooks do not have any headers or footers. You need to create the header/footer 'manually' for each sheet in the workbook
- View: header and footer
- Custom header (or footer)
- Click on the open button
- You will see &[Path]&[File]
- Remove the &[Path], just leave the &[File]