?
Solved

Adding Path to document by default in Excel

Posted on 2011-09-27
4
Medium Priority
?
183 Views
Last Modified: 2012-05-12
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
Comment
Question by:Itomicltd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 1000 total points
ID: 36708822
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
 

Author Comment

by:Itomicltd
ID: 36708831
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36708862
The only way is using templates, I'm afraid.
0
 
LVL 17

Expert Comment

by:andrewssd3
ID: 36708992
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question