• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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?
0
Itomicltd
Asked:
Itomicltd
  • 2
1 Solution
 
Rory ArchibaldCommented:
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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now