Home > Excel Help Portal > Excel Add-Ins

<<  (Page 1)  Previous              Next  (Page 1)  >>

Excel Add-Ins

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses add-ins available for
Microsoft Excel.

51. How to Install an Excel AddIn (XLA or XLL) with Automation This article illustrates how to install an Excel Add-in (xla or xll) with... KB#280290. Keywords: Add-In, Errors, Class, Object, VBA

 
52. Automation Calls to Excel from an XLL May Fail or Return Unexpected Results If an XLL that is loaded in Excel attempts to automate Excel by using its Visual Basic for Applications Object Model, rather than the Excel4() C API for which XLLs were designed, method calls may return unexpected results, or may crash... KB#301443. Keywords: Add-In, API, Macro, Object, VBA, Templates

 
53. Wrong Workbook Is Printed or Previewed When you print a workbook or or use the Print Preview command to preview a workbook, the wrong workbook is printed or... KB#236408. Keywords: Add-In, Printing, Object

 
54. How to use AutoSave in Excel 2000 This step-by-step article explains how to use the AutoSave feature in Microsoft Excel 2000. Excel includes an AutoSave feature that periodically saves your file as you work on it. AutoSave does not save data in a separate file; therefore, the... KB#213943. Keywords: Add-In, AutoSave, Corrupted, Files

 
55. How to Find Resources on Microsoft Excel Solver You can find more information about Microsoft Excel Solver in the following resources: For detailed information about the algorithm Microsoft Excel Solver uses, please see the following article in the Microsoft Knowledge Base: 82890 XL: Solver... KB#146606. Keywords: Solver, Third-Party, Web

 
56. Format Painter Causes Excel to Stop Responding If Date Watch Addin Is Enabled When you double-click the Format Painter button, Excel stops responding, and you may receive either of the following error messages: DateMigration: Run-time error 28 Out of Stack Space -or- DateMigration: Run-time error '-2147417848(80010108)':... KB#264658. Keywords: Add-In, Format, Errors, Class, Object

 
57. Valid Geographic Names for Microsoft Map In Microsoft Excel 2000, you can use Microsoft Map to graphically represent data associated with a geographic area. For Microsoft Map to recognize a territory, such as a country or province, the name must be a valid name or... KB#214385. Keywords: Microsoft Map

 
58. How to Use the Virus Search Addin for Microsoft Excel (WE1280) The Application Note Virus Search Add-in (WE1280) is now available from Microsoft. The disk included with this Application Note includes versions 1.2 and 2.0 of the add-in. You can use the add-in to remove the Excel Macro/Laroux concept virus,... KB#150990. Keywords: Add-In, Download, Macro, Files

 
59. How to obtain and Install the Excel 2000 SR1 Eurotool AddIn Update Microsoft has released an update to the Microsoft Excel 2000 SR-1 Eurotool Add-In. This article describes how to download and install the Excel 2000 SR-1 Eurotool Add-In Update. Note For information about how to download and install the Excel... KB#295681. Keywords: Add-In, Download, File Name

 
60. How to create an Addin Application Name and Description in Excel 2000 This step-by-step article demonstrates how to create a name and description for an add-in application. In Microsoft Excel, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom... KB#214298. Keywords: Add-In, Comments

 
61. Formulas That Return the Last or First Day of a Month This article describes how to create a formula that returns the last or first day of the current... KB#214101. Keywords: Add-In, Analysis ToolPak, Months, Errors, Formulas, EOMONTH

 
62. Graduated Symbol Is the Only Symbol Available in Microsoft Map When you create a Microsoft Map object in Microsoft Excel, the only symbol that is available in the Microsoft Map Control dialog box is the Graduated symbol (five-pointed... KB#214387. Keywords: Microsoft Map, Format, Symbol, Object

 
63. Solver Limits for Constraints and Adjustable Cells The maximum number of adjustable cells and constraints that a Solver model can use are listed in the following table. Microsoft Excel Adjustable cells Constraints version --------------------------------------------------- 3.x 200 299 4.x 200 500... KB#75714. Keywords: Solver, Errors

 
64. Help using Excel spreadsheet financial functions The following example shows the results of various financial calculations based upon both Annual and Monthly values. Note that the cells C4:D8 have all been given names ending with '_A' (annual) or '_M' (monthly). The names have been used in the formulae rather than the cell references. Business... Keywords: Analysis ToolPak, Months, Years, Formulas, FV, IPMT, PPMT

 
65. Valid Geographic Names for Microsoft Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to graphically represent data associated with a geographic area. In order for Microsoft Map to recognize a territory, such as a country or province, the... KB#168691. Keywords: Microsoft Map

 
66. Macrofun.exe File Available on Online Services To display help topics for Microsoft Excel 4.0 macro functions, you must first install the complete Macro Function help file (Macrofun.hlp). The following file is available for download from the Microsoft Download Center: Download... KB#128185. Keywords: Solver, Download, Errors, Macro, Files

 
67. Perform math operations without formulas Spreadsheets, by their nature, rely on formulas to manipulate numbers. But creating formulas isn't always the most efficient way to modify a range of values. For example, suppose that you have a worksheet containing a column of prices for various products, and you need to increase all prices by 5... Keywords: Add-In, Charts, Sorting, Download, Format, Formulas, Printing

 
68. Contextures - Excel Functions These files were created by Microsoft Excel MVP Norman Harker, an Australian academic specialising in real estate appraisal, investment analysis and real estate financial feasibility studies. The files are provided "AS IS" with no warranties. They can be freely distributed and used without a... Keywords: Add-In, Download, Files

 
69. Change cell values using Paste Special Q. I have a price list stored in a worksheet, and I need to increase all prices by 5 percent. Can I do this without reentering all the prices? Excel provides two ways to accomplish this. The "traditional" technique goes something like this: The other, more efficient approach also uses the Paste... Keywords: Add-In, Charts, Format, Formulas, Printing

 
70. Button Editor Addin This add-in allows you to edit button images....To install the add-in use the Tools Add-ins menu and then browse for the ButtonEditor.xla file. This will add a new menu item to the Tools... Keywords: Add-In, Links, VBA, Toolbar

 
71. Select Custom Header Custom Dialog box and Visual Basic for Applications procedure provides a choice of three custom headers that can be assigned to a worksheet. You can have Excel store frequently used custom headers and choose them from a menu option in a worksheet. A Visual Basic for Applications procedure and... Keywords: Add-In, Download, Format, Printing, Object, VBA

 
72. Use MathEasy Add-In to simplify entering math formulas The product is straight forward; a "Math" button is visibly added to the Excel toolbar, performing "Addition", "Subtraction", "Average", etc. No prior Excel experience is required. Hopefully beginners can use Math Easy as a stepping-stone to learning more advanced math. Visit... Keywords: Add-In, Download, VBA, Web

 
73. Working with pre-1900 dates In the eyes of Excel, the world began on January 1, 1900. Excel is not capable of working with dates earlier than that. People who use Excel to store historical information often need to work with pre-1900 dates. The only way to create a date such as July 4, 1776, in Excel is to enter it into a... Keywords: Add-In, Charts, Dates, Format, Formulas, Printing

 
74. A Formula to Calculate a Ratio Excel provides no direct way to display the ratio between two values. For example, assume cell A1 contains 3, and cell B1 contains 24. The ratio between these two values is 1:8. Following is a formula, contributed by Douglas J. Roach, that displays the ratio between the values in cells A1 and B1:... Keywords: Add-In, Analysis ToolPak, Charts, Ratio, Format, Formulas, Printing, GCD

 
75. Answer to Challenge of the Month Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of Tickling Keys, Inc. All contents Copyright 1998-2004 by MrExcel... Keywords: Add-In

 
76. Graphics Exporter Addin This add-in will allow you to export pictures, shapes, charts and more to image files.......Last updated 8th January... Keywords: Add-In, Charts, Export, Links, VBA, Files, Comments

 
77. Polar plots The add-in helps you to create a polar plot of your angle and distance data....This workbook contains examples on polar plots....v1.1 Removal of unnecessary library... Keywords: Add-In, Charts, Plot, SERIES, Links, VBA

 

<< (Page 1)  Previous              Next  (Page 1) >>