First of all, I would like to thank you all on using my templates and giving me feedback. There are plenty of comments and emails sent to me everyday which are needed to be answered. Many of them are asking same questions, so I try to compile all similar questions into this Frequently Asked Questions (FAQ). You can read this FAQ below before submitting your questions.
1. How can I download your template ?
I put links for downloading templates at the middle or the end of each post. Usually they are bold words with filename/icon or word “here”. You click it or right-click and save-as to start download the file.
2. Why can’t I download the file ?
Check your browser settings. You have to make it to allow pop-ups window, or you can try to download from other browser.
3. What excel version I need to run your template ?
Based on my experience, my templates will working properly in excel 97 – 2007 version. Start from year 2010, most of my templates are created using Excel 2010 version. They are will work properly in excel 2007 and above version, where you can see the excel file extension is difference (.xlsx).
4. Why the excel function not working properly ?
Many of my excel templates require a minimum Excel 2007 version running on Windows. It means, if you are using with other OS and Excel, it could be some incompatibility functions where they are not supported in lower Excel version or OpenOffice calc (conditional formatting formulas, a few array functions), Excel for Mac (button, slider or selection box function). Some are still working well when you convert it to your Excel version some are not.
5. Why your template shows “#name” in some of its cells ?
I made many templates that required the analysis toolpak add-ins to be active. You should activate the analysis toolpak add-ins to make all the excel formulas working well. You can activate the analysis toolpak by following several steps below :
Excel 2003 > Menu > Tools > Add-Ins > Tick Analysis Toolpak > Ok
Excel 2007 > Menu > Excel Options > Add-Ins > Select Analysis Toolpak > Go > Tick Analysis Toolpak > Ok
You probably need the original microsoft office installation if you have problem on activating the add-ins. If the add-ins is active and you see that there is no change happened, close your microsoft excel and open it again.
6. Why you protect some of your templates ?
There are two reasons why I protect my templates. First, to protect the formula inside the template to be changed unintentionally. Second, to protect the template to be used by other parties without permission. Almost all of my formulas are original, where it took several hours to find the correct excel functions to implement the logic. I know that some of you will need to see the function for learning purposes, but there are others that will use my templates to be claimed as their creation without giving me any credits. You will find some templates that have similar layout and function like my templates but claimed by other parties.
7. Can I have the password ?
8. Can I pay you for the password ?
No. Except for those that have options to pay for password or pay for the unlocked versions.
9. Can you help me with excel problem ?
I will help if I could. Just send me email and I will answer and try to solve your problem. The main issue is time, since I cannot read and answer it directly due to my time limitation.
10. Can I pay you to do some excel projects ?
Not this time. I just don’t want to be bounded by some order obligation because of my time limitation. But, I will probably do it for a fee if it is based on my current templates and need a minor modification which require a few hours to complete it.
11. Can you do some modification ?
12. Can I pay you to do some modification ?
I have a very limited time on doing this excel template. If the modification will be useful for all users, I will make it. If it is not, I will see the possibility, depend on its complexity, for a fee but I can’t give you a promise.
13. Why it takes so long for you to answer my comments ?
I am sorry guys. The reason is the same, my time limitation. But, if you need urgent help, just mail me, I will answer and try to solve your problem.
14. Can I have the English Premier League Fixtures template ?
FA has protected everything about English Premier League including its fixtures. So, if I want to use their fixtures and distribute it, FA required me to pay for a license which is not cheap. Even yahoo has to pay FA for displaying the fixtures in Yahoo site. So, I am really sorry that I cannot make and distribute it for free.
15. Can I advertise on your site ?
16. Can we exchange links ?
Thank you for your interest, but at this point of time, I do not exchange links.