Home > Excel Help Portal > Excel Downloads

<<  (Page 2)  Previous              Next  (Page 2)  >>

Excel Downloads

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses Microsoft Excel
downloads.

1. Overview of the Office 2003 Critical Update: November 4, 2003 Microsoft has released an update for Microsoft Office 2003. This update fixes a problem that occurs when you try to open or to save a Microsoft Office PowerPoint 2003 file, a Microsoft Office Word 2003 file, or a Microsoft Office Excel 2003 file... KB#828041. Keywords: Dates, Download, Errors, CD-ROM, Corrupted, Error Message, File Name, Files, Web

 
2. How to redirect Clip Organizer file paths in Clip Organizer 2002 You cannot modify the location where Microsoft Clip Organizer 2002 saves its catalog files (.mgc files). Clip Organizer 2002 always creates catalog files in the \Microsoft\Clip Organizer folder under the Application Data... KB#827672. Keywords: Download, Errors, Error Message, Files, Registry, Web

 
3. Illegal Operation Error When You Attempt to Format Cells When you attempt to format a cell (by using toolbar buttons or menus), you may receive the following error message: This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor. If... KB#285347. Keywords: Download, Format, Errors, Error Message, Files, Registry, Toolbar

 
4. Latest Information About How to Use Microsoft Office with the Norton AntiVirus Microsoft Office PlugIn The Norton AntiVirus plug-in for Microsoft Office scans documents for macro virus infections in Office products. This plug-in may cause performance issues, the inability to open files within Office, or the inability to install some... KB#329820. Keywords: Third-Party, Macro, Files, Web

 
5. Internet Explorer Prompts User to Open/Save Office File Streamed from ASP When you use an Active Server Pages (ASP) page to stream back the binary contents of an Office file, such as a Microsoft Word document or a Microsoft Excel workbook, you may be prompted to specify whether to open the file directly or save the file... KB#296717. Keywords: Download, Links, Registry, Internet Explorer

 
6. How and Why Unique Identifiers Are Created in Office Documents When you create a document in any of the programs listed above, a unique identifier may be created within the document. This article explains how and why these unique identifiers are created in documents, and provides two methods you can use to... KB#222180. Keywords: Download, Third-Party, Setup, Web

 
7. How to Obtain and Install the Excel 97 SYLK File Security Update Microsoft recently identified two potential security issues that malicious macro authors could exploit. The Excel 97 SYLK File Security Update addresses these issues. This article describes how to download and install the Excel 97 SYLK File... KB#242209. Keywords: Download, Macro, File Name, Files, Web

 
8. You receive the "File is not available" error message when you try to open an Office 2003 document Describes a problem that occurs when you try to open an Office document and the document is not allowed to open because of a compatibility problem, the antivirus program is out-of-date, or your document is infected with a... KB#835404. Keywords: Download, Errors, Corrupted, Error Message, Files, Web

 
9. How to obtain and Install the Excel 2000 SYLK File Security Update in Excel 2000 Microsoft recently identified two potential security issues that malicious macro authors could exploit. The Excel 2000 SYLK File Security Update addresses these issues. This article describes how to download and install the Excel 2000 SYLK... KB#242144. Keywords: Download, Macro, Setup, File Name, Web

 
10. No Thumbnails Are Displayed When You Search for Clips in Web Collections When you use Microsoft Clip Organizer to search Web Collections for clips, you may be unable to view the thumbnail images of the clips as expected. A generic Windows icon, or another program icon, is displayed in the thumbnail instead of a preview... KB#305211. Keywords: Download, Third-Party, Errors, Files, Web, Window

 
11. Visual Basic Equivalents for Lotus Macro Commands (WE1277) Microsoft offers an Application Note titled Visual Basic for Applications Equivalents for Lotus 1-2-3 Macro Commands (WE1277). This Application Note contains equivalent macro code in Visual Basic for Applications for most Lotus 1-2-3... KB#148240. Keywords: Download, Macro, VBA, Files, TEXT

 
12. How to Find the Installation Path of an Office 2000 or an Office XP or an Office 2003 Application This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office or an Office XP or an Office 2003... KB#234788. Keywords: Download, Links

 
13. How to Automate Excel from Java This article illustrates how to call a COM object like Excel from Java. It provides code samples that show how you can make an Excel application visible and open an existing Excel file. There are two code samples. One illustrates how to invoke... KB#169796. Keywords: Download, Object, Internet Explorer, Web

 
14. How to save a Workbook as a Web Page in Excel 2002 This step-by-step article explains how to save your Microsoft Excel workbook as one of the following types of Web pages: Save Workbook as Web Page To save your workbook as an interactive Office Web Component, follow these steps. NOTE: To save... KB#289260. Keywords: Download, PivotTables, Object, File Name, HTML, Web

 
15. Issues Fixed in Excel 2002 by Office XP Service Pack 2 Microsoft has released Microsoft Office XP Service Pack 2 (SP-2). This article describes the issues that are fixed for Microsoft Excel 2002. about how to download and install the Office XP SP-2 325671 OFFXP: Overview of the Office XP Service Pack... KB#325668. Keywords: Add-In, Solver, Download, Borders, Errors, PivotTables, Printing, VBA, Files

 
16. IF THEN in worksheet functions and in VBA Help does not put the = in front of the worksheet formulas, because they can be stacked inside one another, but this can lead to confusion. Look at the syntax in Excel HELP for IF... Keywords: Dates, Download, Formulas, VBA, Web, Comments, VLOOKUP

 
17. How to Block Linked HTTP Images in Office XP Documents You can configure Microsoft Office to block linked Hypertext Transfer Protocol (HTTP) images that are placed in Office documents as an added security feature in Microsoft Office XP. This article describes how to configure Office XP to block... KB#327635. Keywords: Download, Registry

 
18. Cannot Find Program.exe When Downloading Clip Art Images When you attempt to open a clip art image from the Microsoft Clip Gallery live Web site, you receive an error message similar to the following: Windows cannot find program.exe. This program is needed for opening files of clip art gallery... KB#173824. Keywords: Download, Errors, CD-ROM, Corrupted, Error Message, Files, Web

 
19. How to Obtain the Excel 97 Auto Recalculation Patch In Microsoft Excel 97 and Microsoft Excel 97 Service Release 1 (SR-1), worksheet values may not be recalculated correctly when certain conditions are true. To correct this problem, Microsoft has developed the Excel 97 Auto-Recalculation Patch for... KB#174868. Keywords: Charts, Download, Formulas, Files

 
20. The "Pictures in Earlier Office Documents Appear Flipped" White Paper Is Available In Microsoft Office XP, many users see flipped images in their documents. These images may be inverted, upside-down, or both inverted and upside-down. Most users can fix this issue quickly if it occurs in only a handful of their documents.... KB#822228. Keywords: Download, Files, Templates, Scenarios

 
21. Clip Organizer Cannot Read Design Gallery CIL Files When you are prompted to select a program to open a downloaded Clip Gallery Package file (CIL) from the Microsoft Office Online Clip Art Web site and you select Clip Organizer, a new instance of Clip Organizer runs. It behaves as though it is... KB#297224. Keywords: Download, Format, Files, Web

 
22. Ole_samp.exe to Microsoft Excel, Word, & PowerPoint Ole_samp.exe is a sample extracting file that provides an introduction to the concepts of OLE Automation using Visual FoxPro as the OLE client and Microsoft Word for Windows version 7.0, Microsoft PowerPoint for Windows 95 version 7.0, and... KB#148474. Keywords: Download, OLE, Files

 
23. 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

 
24. 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

 
25. Using a Pivot Table as Source for Chart which is also Pivot Table source range. Chart on "Pivot Table and... Keywords: Charts, Download, Format, PivotTables, Links

 
26. ActiveX Control Samples for Microsoft Office 97 Developer Edition (ODE) The self-extracting file described in this article contains a Microsoft Excel 97 workbook with 15 ActiveX Control examples and a Readme.txt file. IMPORTANT : To use the examples in this workbook, you must install the ActiveX Controls that are... KB#252911. Keywords: Download, ActiveX, Files

 
27. 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

 
28. How to use Small Business Financial Manager in Excel 2002 The Microsoft Small Business Financial Manager (SBFM) is not included with Microsoft Office XP Small Business Edition. However, with Microsoft Excel 2002, you can use the SBFM that is included with the Microsoft Office 2000 Small Business Tools.... KB#292187. Keywords: Download, Web

 
29. Custom Visio Application Design and Development Downloading Tips 1) Excel 95 Examples Excel 95 examples can be downloaded directly to your hard drive as an "xls" file. If you right click on the link to the example and choose option "Save Target As", then you can specify the folder on your hard disk where you would like the free example to be... Keywords: Download, Password, Files, Links

 
30. Macro Virus Warning Does Not Appear When Opening SYLK File That Contains XLM Code When you open a workbook that contains macros, you may not be warned that the workbook contains... KB#241901. Keywords: Download, Format, Macro, Links

 
31. Excel -- Pivot Tables -- Data Fields Data Field Layout 1. Arrange Multiple Data Fields 2. Rename Data Fields Arrange Multiple Data Fields If you place two fields in the Data area of a Pivot Table, they appear vertically arranged. To make the data easier to read, you can rearrange the table. Rename Data Fields When you add fields to... Keywords: Download, PivotTables

 
32. Comparative Ratio Analysis Example of comparing actual data to standard ratios from Robert Morris Associates(RMA). RMA comparative ratios are available in the reference section of most business libraries. See the sheet named RMA for more information. Lending institutions use the RMA ratios as one measure of a business that... Keywords: Download, Ratio, Ratio Analysis, RMA, Format, Formulas, Goal Seek

 
33. 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

 
34. Importing Text Files into Open Workbook Use either the OpenText or Dialogs methods to import text into an open workbook. Select the file to import from a built-in dialog box. You can use either of two Visual Basic for Applications methods to automate the process of importing text into a workbook. The OpenText method controls all of the... Keywords: Download, Format, VBA, Files, Text Files

 
35. Custom Dialog and List Box Create a custom dialog to select items from a master list and enter a value in a worksheet cell. You can use a simple Visual Basic for Applications procedure to display a custom dialog and list box. If you use worksheet ranges to control the list box, it is easy to return the selected value to a... Keywords: Download, Sales, Format, VBA

 
36. Using a List Box to Change Data Displayed in a Workbook Learn to use a List Box to update values displayed on your worksheet. Use the OFFSET function to return values from a table. Select an item in the List Box and see values for that item appear on a worksheet. Download File: Click Here to download a copy of the example in Excel 95 format. Click Here... Keywords: Download, Format, VBA, OFFSET

 
37. List Box Lookup Select items from a List Box by entering the first few characters of the item’s name. The first matching item in the List Box is automatically highlighted. You can look up entries in a list box by entering the first few letters of the entry in an edit box. With a Visual Basic for Applications... Keywords: Download, Format, VBA

 
38. Pop Up List box Example of Visual Basic for Applications procedure that draws a list box aligned with the active cell and inserts value selected from list box into active cell. You can create a Visual Basic for Applications procedures that creates a new list box "on the fly" when a command button is clicked. The... Keywords: Download, Format, Command Button, VBA

 
39. Chart Controlled With List Box This example uses a list box and worksheet formulas to change a chart's source range using a list box. You can use a list box to change the values in a chart by using the list box control ranges and the Indirect function. When the list box selection changes, the value of the reference used by the... Keywords: Charts, Download, Format, Formulas

 
40. PivotTable Tutorial PivotTable, VLookup and Excel List Tutorial based on "Building Profits with Excel-lent Tools" by John F. Lacher, Maximize Magazine Special #1 November 1995 You can link named ranges and PivotTables. If you name the range "Database", you can add new records to the range with the built in Data Form... Keywords: Download, Format, PivotTables, Links

 
41. Entering Time Without the Colon This workbook demonstrates the use of a VBA macro to speed data entry of time. You can use an OnEntry procedure to speed entry of time values. Each time you enter data in a cell, a VBA procedure can be run which converts the entry to a valid time value. For example, you can enter the value "1300"... Keywords: Download, Format, Macro, OnEntry, VBA

 
42. Using Built-In Workday Calculation Functions Example of using workday and networkdays functions You can use Excel's built in Workday and Networkdays functions to perform calculations with dates taking into account weekends and holidays. Workday returns a date some number of workdays in the future. Networkdays calculates the number of workdays... Keywords: Dates, Days, Holidays, Networkdays, Download, Format

 
43. Force Uppercase Entry Example Visual Basic for Applications procedure converts lowercase text entered in a column to uppercase. You can use an OnEntry procedure to run a Visual Basic for Applications procedure each time that data is entered into the worksheet. The procedure can convert lowercase text to uppercase is the... Keywords: Download, Format, OnEntry, VBA

 
44. Plotting a Time Series of Data An XY scatter chart can be used to plot time series data. Chart options can be used to control display of lines between points. You can use the Chart, Options menu choices to control the look and feel of an XY scatter chart. In this example, the option Interpolate between cells is used to connect... Keywords: Charts, Plot, SERIES, Time Series, Download, Format

 
45. User Defined Function for Week Number Example of UserDefined function that returns the week number of any date. You can use the "ww" value of the Format function to return week number. This value is not available in the user interface. If you include it in a User Defined Function, you can use it to calculate week number in worksheet... Keywords: Download, Format, Formulas, User Defined Function

 
46. Stacked side by side column chart The download contains a step by step example of how to create side by side stacked column chart.......I have added an additional example to this chart for use with xl97. The built-in formatting of the category labels is not as smart as it is in xl2000. The xl97 version requires the use of dummy... Keywords: Charts, SERIES, Download, Format, Links, VBA

 
47. Gauge chart This gauge chart is constructed on an XY Scatter chart. The dial, numbers and needle positions are calculated using some simple math functions. The dial number labels are linked to text values. The download also includes a variations which will allow for the construction of a dashboard... Keywords: Charts, Download, Links, VBA

 
48. Fireworks The download contains vba code to generate a Firework display, well rockets to be precise. The user can control the number of rockets in a display, the number of sparks a rocket contains and the effect of gravity. The animation is displayed through use of an xy scatter chart. I have not posted a... Keywords: Charts, Download, VBA

 
49. Conditional line chart This chart displays a line that changes colour depending on whether it is above or below a control line. It is based on a xy-scatter chart, it does require the use of some vba code to update the dummy series used. The download contains a example and brief notes on functions and data... Keywords: Charts, SERIES, Download, Colors, Links, VBA

 
50. 3d xy-scatter chart The chart uses worksheet functions to calculate the rotated positions for the users XYZ values. The download file contains scroll bars which allow you to rotate the chart in the XYZ planes. It also includes a step by step explanation of how to create a chart from the calculated... Keywords: Charts, Download, Links, VBA

 

<< (Page 2)  Previous              Next  (Page 2) >>