Home > Excel Help Portal > Excel System

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

Excel System

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

51. How to Use System, User, and File Data Sources Microsoft Office contains Open Database Connectivity (ODBC) drivers that you can use to access data from other programs. This article describes the different types of data source names (DSN) that you can install and use in Microsoft Office... KB#213772. Keywords: Query, Microsoft Access, SQL, VBA, Macro, File Name, Files, Registry, Text Files, Web

 
52. How to prevent Excel from Automatically Opening Files in the Startup Folder in Excel 2003 This step-by-step article describes how to prevent files from being opened automatically when you start Microsoft Office Excel 2003. back to the top How to prevent Excel from opening files When you start Excel 2003, all the files that are in... KB#826922. Keywords: Format, Errors, Startup, Error Message, Files, Toolbar

 
53. How to Specify Dynamic Web Query Parameters A Web query is a new feature in Microsoft Excel 97 that allows you to retrieve data stored on your intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with... KB#162051. Keywords: Query, Third-Party, Symbol, Files, Web

 
54. Office XP Proofing Tools Kit Hotfix Package: February 6, 2004 This article describes the Microsoft Office XP Proofing Tools issues that are fixed in the Office XP Proofing Tools Kit hotfix package that is dated February 6, 2004. back to the top Issues That Are Fixed in the Hotfix Package The following issue... KB#835717. Keywords: Dates, Errors, File Name, Files, Registry, Web

 
55. Using the LoadPicture Function with an Image Control In Microsoft Excel 2000, you can add an image control to a user form. There are two ways to specify which picture file is displayed in the image control; you can specify the picture when you design the user form, or you can specify the picture... KB#213732. Keywords: VBA, Macro, UserForm, File Name, Files, Web

 
56. How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer Provides a resolution for an issue that occurs when you click an HTML link to a Microsoft Office file and Internet Explorer opens the file in Internet Explorer instead of opening the file in the appropriate Office... KB#162059. Keywords: Files, Registry, HTML, Internet Explorer, Links, Web, Window

 
57. How to Save Files in Other Formats This article explains how to save files in different formats, and provides additional information to be aware of when saving... KB#166173. Keywords: Add-In, Charts, Format, Class, Macro, VBA, Files, Save A File, Templates, Toolbar, Text Files

 
58. Excel 2002 PostService Pack 2 hotfix package: October 6, 2003 This article describes the Microsoft Excel 2002 issues that are fixed in the Excel 2002 Post-Service Pack 2 hotfix package that is dated October 6, 2003. back to the top Issues that are fixed in the hotfix package The following issues are fixed... KB#829340. Keywords: Dates, Errors, File Name, Files, Registry, Hyperlinks, Web

 
59. How to send Form Results to a Microsoft Excel Worksheet Using FrontPage 2000 You can create a form in Microsoft FrontPage 2000 and have the results from the form written to a Microsoft Excel 2000 workbook. This article gives an example of how to create the workbook and form, and then how to connect them.Microsoft... KB#308692. Keywords: Text Box, Errors, Error Message, File Name, Files, Web

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

 
61. How to Delete, Restore, and Edit Menu Items Manually Microsoft Excel 97 uses a different method to edit, delete and restore menus and menu items than earlier versions of Microsoft Excel. This article explains the difference between a toolbar, a menu bar and a command bar in Microsoft Excel 97. It... KB#157769. Keywords: Format, Macro, VBA, Toolbar

 
62. Excel 2002 PostService Pack 2 Hotfix Package: September 25, 2003 This article describes the Microsoft Excel 2002 issue that is fixed in the Excel 2002 Post-Service Pack 2 hotfix package that is dated September 25, 2003. back to the top Issues that are fixed in the hotfix package The following issue is fixed in... KB#827984. Keywords: Dates, File Name, Files, Registry, Hyperlinks, Internet Explorer, Web, Window

 
63. Excel 2002 PostService Pack 2 Hotfix Package: August 28, 2003 This article describes the Microsoft Excel 2002 issues that are fixed in the Microsoft Excel 2002 Post-Service Pack 2 Hotfix package that is dated August 28, 2003. Issues that are fixed in the hotfix package The following issue is fixed in this... KB#827143. Keywords: Dates, Circular References, File Name, Files, Registry, Web

 
64. How To Add the Workbook Path to the Title Bar This article provides a sample Microsoft Visual Basic for Applications macro that adds the workbook path and file name to the title bar of a workbook when opening or saving a... KB#272717. Keywords: VBA, Macro, File Name, Save A File, Toolbar, Web, Window

 
65. Pictures in Earlier Office Documents Appear Flipped In Microsoft Office XP, when you open a document that was created in an earlier Microsoft Office 97 or Microsoft Office 2000 program, the images in the document may appear flipped horizontally, vertically, or in both... KB#312838. Keywords: Registry

 
66. Excel 2000 PostService Pack 3 Hotfix Package: July 12, 2003 This article describes the Excel 2000 issues that are fixed in the Excel 2000 Post-Service Pack 3 Hotfix package that is dated July 12, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package.... KB#823809. Keywords: Dates, Errors, Error Message, File Name, Files, Registry, Web

 
67. Sample Macros for Customizing Menus and Submenus In Microsoft Excel 2000, toolbars, menu bars, and shortcut menus are considered a single type of object, called a command bar. This behavior is different from versions of Excel earlier than Excel 97. Although most Visual Basic for Applications... KB#213550. Keywords: Format, VBA, Macro, Object, Menu Command, Toolbar, Web

 
68. Warning Message When You Start an Office Program with Adobe PDFMaker Addin When you start or quit one of the Microsoft Office XP programs listed at the beginning of this article, you may receive an error message that is similar to the following Microsoft program name has detected that your computer has a version of... KB#302596. Keywords: Add-In, Download, Third-Party, Errors, Error Message, File Name, Files, Templates, Web

 
69. How to Index Data in a PivotTable The INDEX function in a PivotTable calculates a weighted average by using the following formula: (value in cell) x (Grand Total)) / ((Grand Row Total) x (Grand Column Total)) When you use PivotTables to compare the relative importance of your row... KB#151515. Keywords: Query, Sales, Format, PivotTables, Toolbar, INDEX, ROW

 
70. Cannot Remove Entries from AddIns Dialog Box In Microsoft Excel version 5.0, when you choose Add-Ins from the Tools menu, you cannot remove an entry from the Add-Ins Available list in the Add-Ins dialog... KB#110076. Keywords: Add-In, Errors, Error Message, Files, Registry

 
71. How to Prevent File Corruption The More Information section of this article discusses features available in Microsoft Excel that are designed to help prevent data loss. It also discusses ways to prevent file... KB#149235. Keywords: Third-Party, Startup, AutoSave, Files, Templates

 
72. How to Use the RefEdit Control with a UserForm This article describes the RefEdit control and provides information about how to use it in a... KB#213776. Keywords: ActiveX, DLL, Patterns, Formulas, Command Button, VBA, Object, UserForm, File Name, Toolbar, Web, Window

 
73. Excel Worksheet Object with Color Text Is Printed Black When you copy text that has been formatted to a color other than black from a Microsoft Excel 2002 document, and then paste the text into a Microsoft Word document as an Excel Worksheet object, the text prints as black. This problem also occurs if... KB#331492. Keywords: Dates, Colors, Printing, Object, File Name, Files, Web, Window

 
74. Multiple Documents Opened or Errors When Excel Starts When you start Microsoft Excel, Excel attempts to open multiple documents and you may receive one or more of the following error messages: This file is not in a recognizable format. If you know the file is from another program which is... KB#258781. Keywords: Add-In, Format, Errors, Startup, Error Message, Files, Templates

 
75. Clip Organizer 2002 postService Pack 2 hotfix package: October 24, 2003 This article describes the Microsoft Clip Organizer 2002 issues that are fixed in the Clip Organizer 2002 post-Service Pack 2 hotfix package that is dated October 24, 2003. back to the top Issues that are fixed in the hotfix package The... KB#829341. Keywords: Dates, File Name, Files, Registry, Web

 
76. Excel Stops Responding When Subtotals Are Removed When you try to remove subtotals from a cell range in Excel 2002, the program may appear to stop responding (hang) with Excel consuming 100 percent of the processor... KB#324557. Keywords: Dates, Download, Format, File Name, Files, Registry, Web, Validation

 
77. How to Share a Collection on a Network This article explains how to share Microsoft Clip Organizer clips among people who have access to the same network.NOTE: Sharing clips across the Internet or an intranet is not... KB#300859. Keywords: File Name, Files

 
78. "Unable to Read File" Error Message When You Open Excel File That Contains a PivotTable Report When you open an Excel workbook that contains a PivotTable report, you may receive the following error message: Unable to read file. When you click OK , you receive the following error message: Errors were detected in ' filename .xls', but... KB#819853. Keywords: Dates, Errors, Password, PivotTables, AutoSave, Corrupted, Error Message, File Name, Files, Web

 
79. Open Button in Dialog Disabled When You Browse or Redirect to .rtf or .csv Files When you browse to either a Rich Text Format (.rtf) file or to a Comma Separated Value (.csv) file that is located on a Web server, Internet Explorer may prompt you with a File Download dialog box to confirm whether you want to open the file or... KB#318761. Keywords: Download, Format, File Name, Registry, Internet Explorer, Web

 
80. Incorrect file origin is listed when you open a text file in Excel 2002 When you open a text file (*.txt) in Microsoft Excel 2002, the Text Import Wizard may list an incorrect file origin (for example: Chinese Simplified, Japanese, or... KB#821456. Keywords: Dates, Download, File Name, Files, Registry, Text Files, Web

 
81. Excel Appears to Stop Responding While Converting Text to Columns in Earlier Version Worksheet After you open an Excel worksheet that was created in an earlier version of Excel (for example, Microsoft Excel 97 for Windows), you may experience one of the following scenarios. Note In both of these scenarios, Excel uses 100 percent of your... KB#812668. Keywords: Dates, Arrays, Macro, File Name, Files, Web, Scenarios

 
82. Office 2003 Input Method Editor (Chinese Traditional) hotfix package: March 5, 2004 Describes an issue that occurs when you use the Self-learning feature in the Input Method Editor (Chinese Traditional) and repeatedly type the same Chinese... KB#835740. Keywords: Dates, Download, Errors, Error Message, File Name, Files, Registry, Web

 
83. How to remove Template Listings in Excel This article describes how to remove recently used templates from the most recently used (MRU) files list on the File menu and from the Recently used templates list in the New Workbook task pane. back to the top Save Existing Registry... KB#822644. Keywords: Export, Sales, File Name, Files, Registry, Templates

 
84. How To Convert a Single Column of Addresses to a CSV Text File This article describes how to convert a single column of addresses in a Microsoft Excel worksheet into a comma-separated value (CSV) file that you can import into another program (for example, Microsoft Access). Note For the address example in... KB#819964. Keywords: Format, File Name, Files

 
85. Copying Worksheet Programmatically Causes RunTime Error 1004 In Microsoft Excel, when you run a macro that copies worksheets, and then places the worksheets into the same workbook that they originated from, you may receive the following (or similar) run-time error message: 1004: Copy Method of Worksheet... KB#210684. Keywords: Charts, Errors, Defined Name, Class, VBA, Macro, File Name, Templates, Web

 
86. Printer Name Not Listed in Print Dialog Box When you try to print your workbook, the printer name does not appear in the Name box in the Print dialog box. However, the same printer does appear in the Print dialog box of other Microsoft Office programs. This problem may occur when you have... KB#211391. Keywords: Printing, Setup, Corrupted, Files, Registry

 
87. How to Assign a Macro to an ActiveX Worksheet Control In Microsoft Excel 97, there is no menu command that allows you to assign a macro to an ActiveX control that is on a worksheet. This article provides an example that demonstrates how to create an ActiveX control and assign a macro to the... KB#157416. Keywords: ActiveX, Command Button, VBA, Macro, Menu Command, Toolbar, Web

 
88. How to remove Template Listings in Excel This article describes how to remove recently used templates from the Most Recently Used (MRU) files list on the File menu and from the New from template list in the New Workbook task pane.WARNING: If you use Registry Editor incorrectly, you may... KB#288363. Keywords: Export, Sales, File Name, Files, Registry, Templates

 
89. How to Assign a Macro to an ActiveX Worksheet Control Microsoft Excel does not have a menu command that allows you to assign a macro to an ActiveX control that is on a worksheet. This article provides an example that demonstrates how to create an ActiveX control and assign a macro to the control. NOTE... KB#213578. Keywords: ActiveX, Command Button, VBA, Macro, Menu Command, Toolbar, Web

 
90. Pivot Table Fields Do Not Function After Excel Repairs and Recovers File When you open an Excel workbook that contains a large pivot table, Excel may repair and recover the file. After the repair and recovery operation is completed, you receive the following message: Errors were detected in Filename.xls , but... KB#322238. Keywords: Dates, PivotTables, File Name, Files, Web

 
91. How to use Excel Startup Folders in Excel 2002 This step-by-step article explains how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways: The actual startup folder locations can vary depending on which version of Excel you use. For more details about Excel... KB#291218. Keywords: Add-In, Format, Errors, Startup, Macro, Error Message, Files, Save A File, Templates, Toolbar

 
92. Custom Toolbars Are Lost After You Quit Excel After you add custom toolbars to Excel 2002, quit Excel 2002, and then restart Excel 2002 either manually or from embedded Excel OLE objects, the custom toolbars may not... KB#330345. Keywords: Dates, OLE, File Name, Files, Registry, Toolbar, Web

 
93. Office 2003 cannot run in "Windows 98/Windows Me" compatibility mode When you work in one of the programs that are listed in the Applies to section of this article, you may receive an error message that is similar to the following (where program name is one of the programs that is listed in the Applies to... KB#837130. Keywords: Errors, Error Message, File Name, Files, Links, Web, Window

 
94. Excel 2000 postService Pack 3 hotfix package: February 26, 2004 Describes an issue that occurs if you click a hyperlink on a Web page in Internet Explorer that opens an Excel workbook in Excel 2000 that contains external links, Internet Explorer may appear to stop... KB#837242. Keywords: Dates, Links, File Name, Files, Registry, Hyperlinks, Internet Explorer, Web, Window

 
95. Rescue your messages from AOL cd .. cd AOLLeave java MailBox mrexcel MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic... Keywords: Years, Download, Export, VBA, File Name, Files, Web

 
96. Excel Data Changes Font Format After You Edit the Excel Data in Word If you paste Excel data in a Microsoft Word document, and then you edit the Excel data, the font format of the data may... KB#814020. Keywords: Dates, Download, Fonts, Format, Object, File Name, Files, Registry, Web

 
97. How to Modify the Number of Undo Levels By default Microsoft Excel 97 keeps track of 16 undo levels, which provide an undo history for most actions you perform in Microsoft Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry.... KB#162944. Keywords: Macro, VBA, Files, Registry, Window

 
98. How to use TexttoSpeech in Excel 2002 This article describes how to use the buttons on the Text To Speech toolbar. This article also describes the default behavior of Text-to-Speech (TTS).Enable Text-to-Speech To turn on the Text-to-Speech (TTS) feature in Microsoft Excel, do one of... KB#288986. Keywords: Formulas, Speech, Toolbar

 
99. Excel 2002 Series.ApplyDataLabels Method Generates Error on MFC Clients When you use DISPID binding that is based on an earlier version of the Excel type library to automate Excel 2002, you may receive the following error message when the program calls the ApplyDataLabels method of a Chart Series object:... KB#306659. Keywords: Charts, SERIES, Errors, Class, Object, Error Message, File Name, Files

 

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