Threads Replies Last Post 4 Pages: 1  2  3  4   Looking For an Answer: "cannot open template wizard" in Excel A few months ago someone posted a similar question about this situation, but no one replied Thus, I'm really hoping someone may now have an answer (llama, llama, llama) HERE Goes: I have Excel 2003. Downloaded the Excel's add-in 'Template wizard with data tracking...' which sort of works. i.e. I can successfully create an excel database and template (xlt) files using the add-in. Howev... 4 17.01.2006 15:56:37 strange behavior excel templates (in comparison word templates) Hello, I have a question, In word there is the possibility to attach a template to a *.doc file. That template is specific for that doc (attached template). If you open the doc the macros in the dot will be executed. In excel there's no such thing as attached template beneath a xls (workbook). I made an Addin application and placed a template in the templates directory or another start file ... 1 05.01.2006 23:02:00 propagating next available space Hi there, We have a two sheet spreadsheet. The first sheet has all the information on particular recruitment jobs to be filled. The 2nd sheet is where the successful applicant information is stored. We want to be able to complete the data on the first sheet of successful applicants name etc, and this transpose on to 2nd sheet automatically. The issue we have is that some jobs have... 1 04.01.2006 23:54:02 consumer debt manager I downloaded the consumer debt manager and some of the cells have statements that I am not familiar with. 1) Personal Installment loans 2) Safe Ration and Safe Monthly Payment. And I need a general understanding of the debt manager.... 1 28.12.2005 19:36:05 Earn money Online - without risk! Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Then you should take yourself a couple minutes time. You happily will be that you ... 1 25.12.2005 01:57:10 THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < Would store / would copy this text or side before the administrator could remove this letter. This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro ... 1 22.12.2005 22:52:06 Saving values Hello. I have a template that I populate from another workbook using formulas. As any template, when you double click the template it renames it appends a 1 to the end of the filename and treats it as a .xls file. I need code that will change all formulas to values and need to know where this code goes in the template so that the forumlas in my template don't get overwritten with value... 1 19.12.2005 19:59:02 PivotTable Filter Values It seems that as I remove/add data to the source of the pivot table the filters remember all previous values in addition to adding newly found values. Even when I refresh the pivottable the invalid values still remain. Is there a way to remove those values that aren't available in the data source?... 2 17.12.2005 22:35:03 Trending with variables Hi all, I need to trend "Customer Complaints" and because each complaint can have upto two variables I'm not sure how to attempt this with the "Trend" function. Any assistance would be greatly appreciated. Yo ... 1 17.12.2005 18:05:38 summing multiple row/column calculations Hi - I'm trying to sum the results of calculations across several cells as follows.... cells A1 to H1 contains numbers of pages cells A2:H9 contain values 1,2, or 3 that represent types I want to determine how many pages there are of each type, for instance in column A if the first cell contains 8, and the next 4 cells contain 1, the and the last 4 contain 2,2,3,3 then type 1 should ... 3 14.12.2005 08:56:02 Use filename as parameter in formula This is in conjunction with the "Convert formulas to values..." post in excel.programming. In a template I have formulas that reference another workbook. However the name of the workbook changes daily (ddmmyy.xls). Is there a way, when opening the template, to prompt the user to select the 'parent' file, then have that filename be refected in all formulas --- eg =[ddmmyy.xls]Sheet1!$A$1 ... 2 13.12.2005 05:54:46 calculating formulas for template I want to create a formula for a dilution. It needs to be able to take an amount of product and calculate how much water I need to make the dilution. Everytime I tried to make a formula, it would give me a circular reference error. Anyone have any ideas on how to fix?... 3 02.12.2005 21:59:21 Creating a custom cell style When I go into Excel 2003 help, under "Formatting Cells", it gives the following instructions: 1. On the Sheet tab, in the Quick Formatting group, click Cell Styles. 2. Click New Cell Style. .... Now, I've been using Excel for years, but try as I might, I can't for the life of me figure out where the "Quick Formatting group" is, or what "Sheet tab" to look for. Can anyone help ... 5 25.11.2005 18:51:44 Opening Excel Sheet in IE and then opening link in Excel in new wi Hi All, I have a very particular requirement in which I would like to have following achieved: - I have one excel sheet with one hyperlink e.g. MySheet.xls - I will open the MySheet.xls with IE instead of Excel - Now if I will click on hyperlink in MySheet.xls then the link will open in the same instance window if IE. INSTEAD I want to open that link in a new window. What is the solutio... 2 24.11.2005 00:56:09 food recipe cost how can i create a tenmplate to work with my recipes... 3 19.11.2005 01:36:08 Projectcontrol in excel Hello I am looking for a document for projectcontrol in excel (whith flowcharts for planning for example). I want a lot of information like planning, budget, workhours etc in one document(like microsoft project). I dont want to use software for this but a excel document so i can make i like i want. Does anybody make something like this or know where to find something on the inter... 1 18.11.2005 18:14:43 FLOATING CELLS Hi, Please can anyone help. I would like to have a part of table that stays in same position. (floating) I don't want to make split of freeze, I just wan't to want that part of table is fixed. So when I scroll up/down left part of table is fixed and that right part is moving. thanx ... 2 17.11.2005 21:36:11 filename in cel how can i get the filename of the excelsheet with a formula in a cel? It has to change automaticly when the filename changes. thanks math ... 2 15.11.2005 19:51:29 no blanks Can someone please help me to make this formula =SUMA(SI(S!D4:D1000=S!G4:G1000,1,0)) not to count blanks i need to count nubers that are the same in the same row Example: D4 G4 300.00 300.00 Count like one Thanks in Advance ... 2 14.11.2005 06:45:14 Help ? Here ? I need some help with a macro or something in Excel. I have a xls mail list. Col A Name, Col B, Last Name, Col C Email Address. We just sent out our Newsletter and over half the 2000 email addresses are invalid. SOO. How can I take a list of the successfull email addresses only (txt file with just the addresses in a long list) and have them matched aganist the master list and delete all... 4 12.11.2005 09:56:04 Checkboxes automatically formating for new rows I am making a spreadsheet template. In this template, some of the columns require checkboxes. I need these checkboxes to autmatically appear in the appropiate columns when a new row is added. For example, if there are 5 rows filled in with data, then when the sixth row is started, the cells in columns C-F need to have checkboxes appear in the cells C6,D6,E6,and F6. The same for each succ... 1 08.11.2005 21:55:02 Excel Can anyone tell me how to make the results of a cell change color and blink on and off? ... 3 05.11.2005 23:11:27 Urgent help needed... Template Wizard with Data Tracking??? This function has disappeared after Excel 2000. Is there another way to do the same thing in 2003? Cheers ... 2 27.10.2005 17:34:24 4 Pages: 1  2  3  4