Home > Excel Help Portal > Excel System

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

Excel System

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

1. Backup your files, always take backups See Workbook Recovery for files left behind from Excel without a file extension such as 7655D900 or 2CB4D900 with a file type of "File" instead of "Microsoft Excel Workbook", Immediate solutions -- Backup on Demand -- Excel oriented (#demand) Don't forget to check if UNDO will work for you, but you... Keywords: Add-In, AutoCorrect, Months, Download, Export, OLE, Colors, Fonts, Format, Styles, Errors, Formulas, Links, Password, Sounds, Startup, Printing, VBA, Macro, UDF, AutoSave, CD-ROM, Corrupted, Error Message, Files, Registry, Save A File, Toolbar, HTML, Web, Comments, Window, LEFT

 
2. How to customize menus and menu bars in Excel Describes how to use the Microsoft Visual Basic Editor to customize menu bars, menus, menu items, submenus, and shortcut menus in Excel. Provides step-by-step instruction and code... KB#830502. Keywords: Charts, Combo Box, VBA, Macro, Object, Menu Command, Toolbar, Web, Window

 
3. Clip Gallery General Troubleshooting Tips Part 1 of 2 This article contains information to help you troubleshoot problems you may encounter when you start Microsoft Clip Gallery from another program. This article covers the following types of errors: Server Application or Source File cannot be... KB#162124. Keywords: Query, Dates, DLL, Export, OLE, Colors, Errors, Startup, Object, CD-ROM, Corrupted, Error Message, Files, Registry, Window

 
4. How to create an Office XP Smart Tag DLL by Using Visual Basic .NET Smart Tags are a technology that was introduced with Office XP that provides Office users more interactivity with the content of their Office documents. A Smart Tag is an element of text in an Office document that is recognized as having... KB#306058. Keywords: Add-In, Download, DLL, XML, Arrays, Errors, Class, VBA, Macro, Object, Registry, Smart Tag, Templates, Web, Window

 
5. How to troubleshoot errors when you save Excel files Describes how to troubleshoot issues that may occur when you try to save Excel... KB#271513. Keywords: Add-In, ActiveX, Third-Party, Format, Errors, Formulas, Startup, PivotTables, Object, VBA, Error Message, File Name, Files, Save A File, Templates, HTML, Web

 
6. Internet Explorer Right-Click Menus Depending on where you right-click in IE you will get different menus. Logo to Left of Title bar Title bar -- Restore, Move (Alt+Space,M, drag with mouse), Size, Minimize, Maximize, Close Menu & Toolbars -- Customize menus and toolbars, Lock Toolbars to prevent theft of homepage & control Menu Bar... Keywords: Add-In, Sorting, Download, Colors, Fonts, Format, Errors, Links, Startup, Printing, Clipboard, User Defined Function, VBA, Error Message, Files, Registry, Toolbar, Text Files, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window

 
7. How to Embed and Automate Office Documents with Visual Basic When developing an application that uses data in an Office document, it might be beneficial to have that data presented directly within your Visual Basic application so that the user can see and edit the data without having to switch to the... KB#242243. Keywords: ActiveX, OLE, Sales, Borders, Fonts, Format, Styles, Arrays, Errors, VBA, Object, Files, Toolbar, Internet Explorer, Window

 
8. How to Deploy the Office 2003 Web Components in an Office 2003 Program When a user who does not have the Microsoft Office 2003 Web Components installed on their computer accesses a Web page that contains an Office 2003 Web Component, he or she may receive a message that is similar to the following: To use this Web... KB#828950. Keywords: Charts, Download, ActiveX, PivotTables, Object, Setup, File Name, Files, Registry, HTML, Internet Explorer, Links, Web

 
9. Overview of Excel 2002 Update: June 19, 2002 Microsoft has released an update to Microsoft Excel 2002. This update includes several security updates and other issues that are corrected in the update. This article describes how to download and install the Excel 2002 Update: June 19, 2002. NOTE... KB#323548. Keywords: Charts, AutoShapes, Query, Dates, Download, DDE, XML, Borders, Styles, Errors, Speech, PivotTables, Printing, Combo Box, Macro, Object, VBA, AutoSave, CD-ROM, Error Message, Files, Hyperlinks, Internet Explorer, Web

 
10. How to deploy the Office XP Web Components in an Office Program When a user who does not have the Office XP Web Components installed on their computer accesses a Web page that contains an Office XP Web Component, he or she may receive a message similar to the following: To use this Web page interactively, you... KB#288732. Keywords: Charts, Download, ActiveX, Microsoft Access, PivotTables, Object, Setup, File Name, Files, Registry, HTML, Internet Explorer, Links, Web

 
11. How to dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET When you are automating an Office application from Visual Basic .NET, the Office application may display a dialog box. The dialog box causes the Visual Basic .NET application to appear to stop responding (hang) because the Visual Basic... KB#307292. Keywords: Errors, Password, Printing, VBA, Object, Error Message, File Name, Templates, Web, Window

 
12. Description and Examples of Data Validation Data validation is a feature available in Microsoft Excel. It allows you to do the following: Make a list of the entries that restricts the values allowed in a cell. Create a prompt message explaining the kind of data allowed in a cell.... KB#211485. Keywords: Format, Styles, Errors, Formulas, Error Message, Toolbar, Auditing, Validation

 
13. IE6 -- Internet Explorer 6.0 *.doubleclick.com *.doubleclick.net *.engage.com *.engageaudience.net *.enliven.com *.enliven.com *.eu-adcenter.net *.eu-adcenter.net *.flycast.com *.focalink.com *.free4all.com *.hitbox.com *.hyperbanner.net *.imgis.com *.link4ads.com *.linkexchange.com *.linksynergy.com *.livestat.com... Keywords: Sorting, Months, Download, ActiveX, Colors, Links, Printing, User Defined Function, VBA, Files, Registry, Toolbar, Text Files, HTML, Hyperlinks, Internet Explorer, Web, Comments, Window

 
14. Fullfile version update may request Office source files Describes an issue where you may be prompted to provide the Office source files when you install a full file version of an Office hotfix or... KB#840169. Keywords: Criteria, Dates, Download, CD-ROM, File Name, Files, Registry, Templates, Web

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

 
16. How to Troubleshoot Startup Problems in Microsoft Excel There are several reasons why you may experience problems when you start Microsoft Excel. This article discusses how to troubleshoot the cause of the startup problem, and possible remedies to correct the problem. The article also contains links... KB#280504. Keywords: Errors, Links, Startup, Corrupted, Error Message, File Name, Files, Menu Command, Registry, Toolbar, Web

 
17. How to Find Technical Information About Microsoft Excel When you use Microsoft Excel, you may have questions regarding how to perform a task or how to troubleshoot a problem. This article discusses resources that you can use to find answers to your questions. The following resources contain useful... KB#146197. Keywords: Solver, Text Box, Criteria, Query, Sales, Formulas, VBA, Setup, Files, Setup Program, Toolbar, Web

 
18. How to manage Office XP Templates in Office Programs This step-by-step article describes the location of templates in Microsoft Office XP, how the Templates dialog box (click General Templates in the task pane) displays available templates, and the registry settings that control where to find... KB#290232. Keywords: Files, Registry, Templates

 
19. Excel 2000 SR1 Eurotool Addin Update Admin To help you deploy the Excel 2000 SR-1 Eurotool Add-in Update within your organization, Microsoft is providing an update for Office 2000 administrative installations. This update is contained in a self-extracting file available in the... KB#295685. Keywords: Add-In, Dates, Download, Setup, File Name, Files

 
20. How to use the Forms Controls on a Worksheet in Excel 2000 This step-by-step article describes how to use the forms controls in a worksheet in Microsoft Excel 2000. Microsoft Excel provides several controls for dialog sheets. These controls can be used on worksheets to help you select data. For... KB#214262. Keywords: Format, Formulas, Combo Box, Object, VBA, Toolbar, Links, INDEX

 
21. Using a field alias in Query does not work with some thirdparty databases When you try to use Microsoft Query to return data from some third-party databases into Microsoft Excel, apostrophes (') around alias names can cause the query to fail. The error message that you receive depends on the data source that you... KB#298955. Keywords: Query, Dates, Download, SQL, Third-Party, Errors, PivotTables, Error Message, File Name, Files, Registry, Web

 
22. How to Force Installation of All Office Assistants This article explains how to configure the Microsoft Office 97 Setup program so that the character (.act) files for all of the Office Assistants are copied to your hard disk when you install Microsoft Office 97 from an administrative... KB#162048. Keywords: SERIES, Format, Errors, Setup, Corrupted, File Name, Files, Setup Program, Parse, Window

 
23. How to use the Forms Controls on a Worksheet in Excel 2002 Microsoft Excel provides several controls for dialog sheets. You can use these controls on worksheets to help select data. For example, drop-down boxes, list boxes, spinners, and scroll bars are useful for selecting items from a list. By adding... KB#291073. Keywords: Format, Formulas, Combo Box, Object, VBA, Toolbar, Links, INDEX

 
24. How to Programmatically Perform a Web Query A Web query is a new feature in Microsoft Excel 97 that allows you to retrieve data stored on an 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#162080. Keywords: Query, Symbol, VBA, Macro, Object, Files, Toolbar, Web

 
25. How to use the Template Wizard with Data Tracking AddIn in Excel 2000 This step-by-step article describes how to use the Template Wizard with Data Tracking add-in for Microsoft Excel. With the Template Wizard, you can transform a workbook into an online template or form, and link it to a designated database.... KB#214246. Keywords: Add-In, Consolidate, Format, Links, Macro, Files, Templates

 
26. How to how to Apply Different Passwords or Permissions to Separate Ranges in Workbooks in Excel 2003 This article discusses how to apply different passwords to protect specific ranges of a worksheet in Microsoft Office Excel 2003. In Microsoft Excel 2002 and later versions, you can use passwords to protect specific ranges in your worksheet. This is... KB#826924. Keywords: Errors, Formulas, Password, Error Message, Files

 
27. How to Use the Template Wizard with Data Tracking AddIn The Template Wizard with Data Tracking is an add-in for Microsoft Excel. The Template Wizard allows you to transform a workbook into an online template or form, and to link it to a designated database. The Template Wizard walks you through a... KB#148314. Keywords: Add-In, Consolidate, Format, Links, Macro, Files, Templates

 
28. How to Use Microsoft Query to Merge Two Excel Files This article describes how to use Microsoft Query to merge two Microsoft Excel 2000 files. You may want to do this so that you can combine related information into a single file and use it in a Microsoft Word mail... KB#211802. Keywords: Query, Format, Files, Toolbar, Links

 
29. Summary of Methods to Recover Data from Corrupted Files There are several methods that you can use to recover information from damaged or corrupted files. This article discusses those methods and points you to other Microsoft Knowledge Base articles that discuss the methods in greater detail. Methods... KB#142117. Keywords: Add-In, Charts, Download, Format, Formulas, Class, Macro, VBA, CD-ROM, Corrupted, Files, Links, Web

 
30. How to troubleshoot Custom Smart Tags in Office This article describes how to troubleshoot a custom-created smart tag that does not work as you expect. Smart tag technology gives Microsoft Office programs the ability to recognize data that you enter. Office then offers on-the-spot access to... KB#300950. Keywords: AutoCorrect, DLL, Class, VBA, File Name, Registry, Smart Tag, Templates, Internet Explorer, Links, Web

 
31. How to Use a Web Data Source for a PivotTable Microsoft Excel 97 contains many Internet-related features, including Web queries, hyperlinks, and .htm file support. However, when you create a PivotTable, you cannot directly refer to data that is on an Hypertext Transfer Protocol (HTTP) Web... KB#164020. Keywords: Query, SQL, Defined Name, PivotTables, Setup, File Name, Files, Text Files, Web, ROW

 
32. How to Pass Variables in Visual Basic for Applications Macros In Microsoft Excel, when you use a Microsoft Visual Basic for Applications macro or procedure, you can retain the value of a variable by doing any of the following: Pass the variable to another workbook. (This way you can retain the value of... KB#213365. Keywords: VBA, Macro, File Name, Toolbar, Web

 
33. Excel COM Addins and Automation Addins Microsoft Excel 2002 supports Automation Add-ins in addition to Component Object Model (COM) Add-ins. This article explains the differences between these two types of... KB#291392. Keywords: Add-In, ActiveX, Formulas, Startup, Object, VBA, Registry, Toolbar, Web

 
34. Internet Explorer keyboard shortcuts, mouse shortcuts You can use shortcut keys to view and explore Web pages, preview pages before printing, use the Address bar, work with favorites, and edit. Copied from IE Help shortcuts, to be able to use FIND. Click a heading, or press the TAB key to highlight a heading, and then press... Keywords: Download, Fonts, Links, Printing, Clipboard, Files, Toolbar, Internet Explorer, Web, Comments, Window, FIND

 
35. Changes Made to Excel CommandBars Through Automation Are Not Saved When you make changes to the Microsoft Excel CommandBars through Automation, the changes are applicable only in the instance of Excel that is being automated. The changes made do not appear in later instances of... KB#241652. Keywords: VBA, Macro, Object, Toolbar

 
36. How to Record a Macro Using Relative Cell References In Microsoft Excel 97, unlike in earlier versions of Microsoft Excel, there is no menu command to record a macro that uses relative cell references. However, you can click Relative Reference on the Stop Recording... KB#161677. Keywords: VBA, Macro, Menu Command, Toolbar, Web

 
37. Securing Visual Basic Code in Microsoft Excel In Microsoft Excel 97, unlike earlier versions of Microsoft Excel, you cannot hide Visual Basic for Applications modules. If you want to prevent users from seeing Visual Basic code, you can lock the Visual Basic project in the workbook and... KB#167909. Keywords: Add-In, Arrays, VBA, Macro, File Name, Toolbar, Web

 
38. Overview of the Excel 97 Security Patch: November 11, 2003 Microsoft has released a patch to Microsoft Excel 97 for Windows. This patch fixes a vulnerability under certain scenarios where an Excel file can be modified in such a way that a macro that includes Microsoft Excel 4.0 Macro Language (XLM)... KB#830356. Keywords: Download, Errors, Macro, Object, CD-ROM, Error Message, File Name, Files, Hyperlinks, Scenarios

 
39. How to save Files in Other Formats in Excel 2000 This article explains how to save Excel 2000 files in different formats and provides additional information to consider when you save files. Save a File in a Different Format By default, Excel saves files in the Microsoft Excel Workbook format.... KB#212174. Keywords: Add-In, Charts, Format, Class, Macro, VBA, Files, Save A File, Templates, Text Files, Web

 
40. How to Record a Macro Using Relative Cell References In Microsoft Excel 2000 and Excel 97, unlike versions of Microsoft Excel earlier than Microsoft Excel 97, there is no menu command to record a macro that uses relative cell references. However, you can click Relative Reference on the Stop... KB#213740. Keywords: Formulas, VBA, Macro, Menu Command, Toolbar, Web

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

 
42. How to Help Protect Visual Basic Code in Excel In Microsoft Excel 2000, unlike versions earlier than Excel 97, you cannot hide Microsoft Visual Basic for Applications modules. If you want to prevent users from seeing the Visual Basic code, you can lock the code in the workbook and thereby... KB#213903. Keywords: Add-In, Arrays, VBA, Macro, File Name, Toolbar, Web, Window

 
43. How to customize the My Places Bar in the "Open" and "Save As" Dialog Boxes This article describes how to customize the My Places bar in Microsoft Office XP. The My Places bar appears in the left pane of the Open and Save As dialog boxes in Office XP programs. The following customizations are available for the My Places... KB#282087. Keywords: Sorting, Export, File Name, Registry, TYPE

 
44. Overview of Office XP Clip Organizer Update: June 19th 2002 Microsoft has released an update to Microsoft Office XP Clip Organizer. This update includes several security updates and other fixes. Note This Public Update is part of the Microsoft Office XP Service Pack 2 (SP-2), but for your convenience... KB#324110. Keywords: Dates, Download, CD-ROM, Files, Internet Explorer, Links, Web

 
45. How to Customize the Places Bar This article explains how to add user-defined entries to the Places Bar in the Office 2000 Save As and Open dialog boxes. If you want to do this, you must modify or add the registry keys and entries described below. Office 2000 applications... KB#205041. Keywords: Sorting, Format, CD-ROM, Registry, Web

 
46. How to Customize the My Places Bar in Both the Open and the Save As Dialog Boxes in Office 2003 This article describes how to customize the My Places bar in Microsoft Office 2003. The My Places bar appears in the left pane of both the Open and the Save As dialog boxes in Microsoft Office programs. The following customizations are available... KB#826214. Keywords: Sorting, Export, File Name, Registry

 
47. How to Activate a Perpetual License in Office 2003 Programs This step-by-step article describes how to activate the perpetual license version of Microsoft Office 2003. The same procedure can also be used for any stand-alone version of Microsoft Office Access 2003, Microsoft Office Excel 2003, Microsoft... KB#828958. Keywords: Files, Web

 
48. DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update Client applications can use Dynamic Data Exchange (DDE) to issue a macro RUN command to Excel 2002. This command may stop working after the user updates to Service Pack 2. To the client application, the method call appears to succeed, but the... KB#821136. Keywords: Dates, DDE, Errors, Macro, VBA, Error Message, File Name, Files, Web, Window

 
49. How to save Files in Other Formats in Excel 2002 This article explains how to save Microsoft Excel files in different formats, and provides additional information to consider when you save files. How to Save a File in a Different Format By default, Excel saves files in the Microsoft Excel... KB#291064. Keywords: Add-In, Charts, XML, Format, Class, Macro, Files, Save A File, Templates, Toolbar, Text Files, Internet Explorer, Web

 
50. Excel 2002 PostService Pack 2 Hotfix Package: August 10, 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 August 10, 2003. Issues that are fixed in the hotfix package The following issue is fixed in this hotfix... KB#823969. Keywords: Charts, Text Box, Dates, Fonts, Format, Object, File Name, Files, Registry, Hyperlinks, Web

 

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