Adding Path to document by default in Excel

I can see in Excel 2010, that i can add the file path as a header in my Excel workbooks, is there a way to do this always by default rather than add this feature every time?
ItomicltdAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
Create a new blank workbook, set it up as you would like (page setup etc) then save it as a template file called book.xltx in one of your two XLSTART folders. Then any new workbook will use that template, as long as you use Ctrl+N to create it (or any method other than File-New-Blank Workbook.)
0
 
ItomicltdAuthor Commented:
I have a number of users onsite here, is this the only way to set this up or is there another more central way to do this ?
0
 
Rory ArchibaldCommented:
The only way is using templates, I'm afraid.
0
 
andrewssd3Commented:
You could do it using a global add-in that added the header to any new workbooks, but that would have exactly the same issues with distribution as rorya's template, which is the better solution anyway.  If you have a network setup you should be able to use a login script to distribute the file (subject for another question? :))
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.