How can I set up automatic path/file name for new workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When opening a new book in excel or word, how can I have a path/file name be
standard on these new books? This way, people will not have to remember to
set them up in their headers and footers and we will always be able to find
where a document is located.
 
Open a worksheet and go to

-Tools - General - Default file location

and fill in the path you need. The same way works on word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I automatically print file path on documents 6
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Creating a default for all new workbooks 6
Setting up Default Headers/Footers in Excel 3
How to Display Full Path for File Diplayed at Top Of Workbook 1
Excel 2007: Default Workbook Issue 2
How do I get the default workbook settings to print the date/time/ 2
Show where worksheet is saved in the header/footer 6

Back
Top