templates

  1. B

    Use a Worksheet Template in VBA

    Hello, I've been using VBA created by Ron De Bruin (Sub Copy_To_Worksheets()), and have managed to amend it to my needs save for one part. I can't seem to be able to use a worksheet template? This is the original code that works... Else 'Add a new worksheet...
  2. C

    Excel Crashes inserting Templates

    Excel 365 kept crashing on inserting a template. I think i have tracked it down that you can no longer have more than 2-3 folders in templates. Soon as you have more it crashes Anyone know of fix or workaround
  3. G

    Can you update links on templates

    Hi I have templates and im going to insert them into a workbook. Thing is the templates once inserted need to be linked to another workbook. Is there anyway I can do that without having to create links manually.
  4. L

    VBA open populate and save word doc

    Hi all! I am having a problem with code to open several word template, populate and save the to a new folder. The folder that holds the templates is shared so that a lot of people can access the form templates. The code runs fine if nobody has any of the templates open but hangs up with an OLE...
  5. S

    Most useful Excel templates for the home user

    I am interested to know which are the most useful Excel templates for such tasks as menu planning and managing household accounts and finances.
  6. M

    Displaying Custom Templates

    Hi there! I noticed that when starting up Excel, along with the Blank Workbook option, there is a plethora of pre-made templates to choose from along with the option to search for more online. I was curious if it is possible to display and Pin your own custom-made templates on this screen as...
  7. E

    Consolidating worksheets

    Hi, I have a number of worksheets that are all identical in terms of format, structure, etc. They are templates and have numbers in them. I have created a summer sheet so I can sum all the numbers in to totals. This summary shee is simply one of the templates but blank. I there a easier way...
  8. V

    Hyperlink Template Excel Office 365

    I am trying to create a hyperlink to templates that I have created in Excel Office 365. However, when I create the link, I can only see documents, no templates to hyperlink.
  9. H

    Excel Report Templates

    Good afternoon All, Was just wondering if there are any good sites with excel report templates that I could "borrow". Looking to create some eye catching but simple reports, but cutting on the design time. Interested in both tabular formats as well as graphical presentations. Many Thanks...
  10. Y

    Drop down list within VBA

    Hi all, hope someone can assist. I have a blank template which I add to the workbook as a new event is created. I have now noticed there are three other circumstances which require different templates. So I will have Blank1, Blank2, Blank3 and Blank4 templates. Currently i just have a piece...
  11. A

    Userform Data to Populate Word Documents and Email Templates

    Afternoon All Hoping I can get some help here. I manage a team of call handlers, and want to get a process whereby they can use a userform in excel to then populate two word documents. And also based on some answers on the userform to then fire off some email templates which are partly...
  12. L

    sum() empty cells not = 0

    Hi I have seen some invoices template (File-->New--> Office Templates), in these templates they have function like this =sum(A1*B1) and both cell A1 and B1 are empty but the sum() does not return 0!! I check the cell, no other function except sum(), I thought they used iferror() or if() zero...
  13. J

    Loan amortization template-Add one time deposit amount

    Hello! So I have found a 'loan amortization schedule' template in the Excel templates section which has just about everything I need on it. What I can't work out is how to add a one time deposit amount to the template. It has an optional extra payments section, but that adds the amount to each...
  14. J

    Dependent drop down lists selection outputs filtered data

    Hello, I work in the IT department at my job and we have these large excel spreadsheets that our are "employee templates." These are to help us know which employees in which departments are to get what applications, access, etc. I am currently working on making these templates more user...
  15. C

    Force stop automatic color variance in charts

    Hi, We are trying to create a color theme to restrict the colors Excel to just our branded colors. I know how to change the first 6 colors in a series, but I don't know how to get Excel to stop auto formatting the rest of the colors and just force it to use our branded colors instead. I was...
  16. P

    Quickest access to your chart templates

    Hi i have a job to do which involves creating a large number of charts from a series of Excel 2016 data sheets and pivot tables built on this data. The process requires judgement on what to chart and so i don’t really want to get into writing macros I don’t think. I have set set up a series...
  17. S

    XL2013 Protect Sheet 'Edit Objects'

    Hi, in my work I have used .xlt templates without issues, since the business moved to xl2013 I now use .xltm templates, the edit objects check box under protect sheet will not stay set. Has anyone come across this? are you able to advise? Thank you.
  18. D

    New Excel update causes two Templates to open when I try to open one

    Hello, As of a Microsoft update around the end of September 2017, I can't get any Templates I've made and been using for years now to open properly. Instead of just Double-Clicking on either a xltx or xltm file (in Excel 2016) and seeing 1 copy of the Template open with a suffix of "1", the...
  19. M

    time calculations

    I am trying to set up a spread sheet that will calculate the number of hours based on the times employees clock in and out each day and then give me a total for the time period. I have found lots of templates but every last one of them has a problem I don't know how to overcome. If I have an...
  20. S

    path to Excel template folder

    Dear All; How do I retrieve the absolute path of the default (per user) folder where Excel stores/looks for its template files? (I need this for MS Office versions 2007, 2010, 2013 and 2016). Many thanks in advance. =S.Br.=

Some videos you may like

This Week's Hot Topics

Top