For business users of Microsoft Excel.
For business users of Microsoft Excel.

 

Home > Excel Help Portal > Excel System

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

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. Cannot Save Excel File That You Open in Microsoft Internet Explorer When you open a Microsoft Excel file from a server and you click Save As on the File menu, you are prompted for your Microsoft Windows NT credentials. If you click Cancel, the credentials dialog box closes, but the local Save As dialog box is... KB#321778. Keywords: Registry, Links

  2.  
  3. Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control When you use a RefEdit control in a user form, you cannot use keyboard shortcuts, such as CTRL+SHIFT+END, to enter a range in the RefEdit... KB#291110. Keywords: Registry

  4.  
  5. Zoomed Cells Are Not Displayed Correctly If You Freeze Panes on Outline Group In Microsoft Excel, cell contents may be not displayed correctly if your worksheet is zoomed to a magnification other than 100 percent. If the worksheet is zoomed to less than 100 percent, the characters at the edge of a cell may be truncated. If... KB#283090. Keywords: Dates, Borders, Outline, File Name, Files, Window

  6.  
  7. Processor Spikes at 100 Percent When You Click AutoFilter Arrow In Microsoft Excel 2000, when you click the arrow for a filtered list, the processor usage spikes to 100 percent. In Microsoft Excel 2002, the processor returns to its usual state when a mouse-over event occurs. However, in Excel 2000, the... KB#323785. Keywords: AutoFilter, Dates, File Name, Files

  8.  
  9. How to Display All Menu Commands When you first start a Microsoft Office program, the menus and toolbars display basic commands and buttons. As you work with an Office program, the commands and buttons that you use most often are stored as personalized settings and displayed on... KB#213398. Keywords: Toolbar

  10.  
  11. How to Create a Macro That Opens Multiple Selected Files In the Open dialog box in Microsoft Excel, you can select more than one file to open at a time. If you are using Microsoft Visual Basic for Applications with the GetOpenFileName method, you must use a macro to loop through the selected files to... KB#213635. Keywords: Arrays, Macro, VBA, File Name, Files, Web

  12.  
  13. Word or Excel File May Become Damaged When You Save the File Using HTML Format When you are logged on as a client computer connected to a computer running Windows 2000 Terminal Services, if you attempt to save a file using the HTML file type in Microsoft Word 2000 or Microsoft Excel 2000, the file may become... KB#252633. Keywords: Download, Save A File, HTML, Internet Explorer, Web

  14.  
  15. How to Access Smart Tag Menus from the Keyboard This article describes how you can use your computer keyboard to access smart tag menus, instead of using your... KB#301403. Keywords: Smart Tag

  16.  
  17. Multiple Euro Icons or "Subscript out of Range" Error When You Start Excel When you start Microsoft Excel, you may see one of the following symptoms: You see more than one Euro formatting button on the Formatting toolbar. -or- You receive the following Microsoft Visual Basic error message: Run-time error '9': Subscript... KB#257452. Keywords: Add-In, Format, Errors, VBA, Toolbar

  18.  
  19. You Cannot Reopen a File After You Save It If you save certain files in Excel 2000, you may not be able to reopen... KB#324312. Keywords: Dates, File Name, Files

  20.  
  21. Cannot Set the Orientation Property of a Pivot Field When you try to use Microsoft Visual Basic for Applications to set the Orientation property of a pivot field in a PivotTable, you receive the following error message: Unable to set the Orientation property of the PivotField class NOTE : You... KB#318063. Keywords: Download, Errors, Class, VBA, Error Message, File Name, Files

  22.  
  23. How to display or Hide the Ask a Question Box in Microsoft Office This step-by-step article describes how to display or hide the Ask a Question box in Microsoft Office XP programs. The Ask a Question box is a new feature of Office XP that allows quicker access to Help topics. This box is located in the... KB#283633. Keywords: Ask a Question box, Toolbar

  24.  
  25. Excel Stops Responding When You Drag an Item in the PivotTable Layout Wizard When you drag an item in the PivotTable and PivotChart Wizard - Layout dialog box, Microsoft Excel stops... KB#307809. Keywords: Dates, PivotChart, PivotTables, File Name, Files

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

  28.  
  29. How to use Custom Toolbars from Excel 5.0 in Excel 2000 This step-by-step article shows you how to use custom toolbars from Microsoft Excel 5.0 in Microsoft Excel 2000. When you upgrade Excel 5.0 to Excel 2000, built-in toolbars that you customize in Excel 5.0 and custom toolbars you create in Excel 5.0... KB#211963. Keywords: Toolbar

  30.  
  31. SAVE file problems Keywords: Errors, Error Message, File Name, Save A File, Web, Comments

  32.  
  33. Office files that are saved to a network drive take an unexpectedly long time to save When you are using one of the following programs to save a file to a network location, the save operation may take an unexpectedly long time to complete: Microsoft Word Microsoft Excel Microsoft... KB#329309. Keywords: Third-Party, Files, Save A File

  34.  
  35. Error Message: The Document Caused a Serious Error the Last Time It Was Opened When you try to open a file that Microsoft Excel or Microsoft Word could not open previously, you receive the following error message: The document ' Filename ' caused a serious error the last time it was opened. Would you like to continue opening... KB#286017. Keywords: Errors, Corrupted, Files

  36.  
  37. How to bypass the Text Import Wizard When You Import Files in Excel 2000 This step-by-step article describes how to bypass the Text Import Wizard when you import files in Microsoft Excel 2000. When you import text files into Excel 2000, the Text Import Wizard may automatically appear and display the first line as... KB#214295. Keywords: File Name, Files, Text Files, Parse

  38.  
  39. How to Remove Entries from AddIns Dialog Box When you click Add-Ins on the Tools menu, you cannot delete an add-in from the list of Add-Ins available in the Add-Ins dialog... KB#161439. Keywords: Add-In, Files, Registry

  40.  
  41. Support WebCast: General Corrupt File recovery techniques in Microsoft Excel 97, Microsoft Excel 2000, and Microsoft Excel 2002 Session Summary During this session, we will discuss how to use the corrupted file recovery features in Microsoft Excel. We will cover both the automatic functionality and the manual methods to invoke file recovery, how Excel displays the results... KB#325496. Keywords: Corrupted

  42.  
  43. Excel Quits Unexpectedly When You Switch Between Tab Strip and Chart on Worksheet If you insert a Microsoft Forms 2.0 TabStrip control and a chart on a worksheet, and you click between the control, the chart, and the cells on the worksheet, Excel quits unexpectedly, and you receive an application error... KB#320520. Keywords: Charts, Dates, Errors, Error Message, File Name, Files

  44.  
  45. VBA Macro Causes RunTime Error 1004 If AutoComplete Uses IME In Microsoft Excel, when you run a Microsoft Visual Basic for Applications (VBA) macro after you use AutoComplete with the Input Method Editor (IME), you receive an error message that is similar to the following: Run-time error... KB#279248. Keywords: Dates, Errors, Macro, VBA, Error Message, File Name, Files

  46.  
  47. SR1 Stops Responding When You Open a File After an Incomplete Save When you try to save a workbook that contains charts, Microsoft Excel stops responding. After this problem occurs, Excel stops responding when you try to reopen the... KB#309671. Keywords: Dates, File Name, Files

  48.  
  49. Generating a List of File Names Many users are surprised to discover that Windows does not provide a direct way to get a list of file names contained in a directory. This tip describes how to create such a list in a text file, which can then be imported into Excel.To generate a list of file names, you'll need to use a DOS command... Keywords: Charts, Dates, Format, Formulas, Printing, File Name, Files, Text Files, Window

  50.  
  51. Excel Caused an Invalid Page Fault in MSO9.DLL When Saving File When you attempt to save a file in Microsoft Excel, you may receive an error message similar to either of the following: EXCEL caused an invalid page fault in module MSO9.DLL at 0137:3092fdcd. -or- EXCEL caused an invalid page fault in... KB#248167. Keywords: Format, Errors, Error Message, File Name, Save A File

  52.  
  53. How to Bypass the Text Import Wizard When You Import Files When you import text files into Microsoft Excel, the Text Import Wizard may automatically appear and display the first line as shown using the default parse line. You can bypass the Text Import Wizard and accept the defaults by holding down the... KB#110760. Keywords: File Name, Files, Text Files, Parse

  54.  
  55. Replace Functionality Does Not Work After You Programmatically Perform a Range.Find Operation Replace functionality does not work after you programmatically perform a Range.Find operation. If you are trying to perform a replace operation manually, the Find and Replace dialog box does not appear. If you use the Replace method in... KB#322007. Keywords: Dates, Formulas, VBA, File Name, Files

  56.  
  57. How to Use Custom Toolbars in Excel5.xlb When you upgrade Microsoft Excel 5.0 to Microsoft Excel 97, any built-in toolbar you customize or custom toolbar you create in Microsoft Excel 5.0 does not appear in Microsoft Excel... KB#161322. Keywords: Toolbar

  58.  
  59. ALT+TAB Does Not Trigger Workbook_WindowActivate Event When you press ALT+TAB to switch between workbooks, Workbook_WindowActivate and Workbook_WindowDeactivate events are not... KB#305694. Keywords: Dates, VBA, File Name, Files

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

  62.  
  63. Recording VBA Macro and Fixing Excel does not record keystrokes. What is produced when you record a macro is VBA code. VBA is a programming lanuage. Only the things that make a difference are recorded. Though I suppose that is debatable since only one thing is recorded at a time so there is a lot of garbage and redundant code.... Keywords: VBA, Macro, VBE, Toolbar, Web, Comments

  64.  
  65. Embedded Charts in PowerPoint Exhibit Odd Behavior After Being Edited In Microsoft PowerPoint 2000, when you open and close a Microsoft Excel 2000 embedded chart that contains text boxes, you may experience any of the following symptoms: The text boxes may disappear. -or- The text boxes appear truncated. -or- The... KB#290570. Keywords: Charts, Fonts, File Name, Files

  66.  
  67. Error Message: No RETURN() or HALT() Function Found on Macro Sheet When you switch between two workbooks several times, you receive the following error message: No RETURN() or HALT()function found on macro... KB#316399. Keywords: Errors, Macro, AutoSave, File Name, Files

  68.  
  69. How to Import Data from Excel Workbook with More Than One Worksheet This article describes how to import data from a Microsoft Excel 2000 workbook into Microsoft Works if the Excel 2000 workbook contains more than one worksheet. Because you can only import one worksheet from an Excel 2000 workbook into a... KB#253405. Keywords: Import Data, File Name, Files

  70.  
  71. "Unable to Load the Excel Template" Error Message When You Run the Import Flowchart Data Wizard In the products listed at the beginning of this article, if you have Microsoft Excel 95 installed and you start the Import Flowchart Data Wizard, you receive the following error message: Unable to load the Excel template. Make sure the following... KB#265122. Keywords: Format, Errors, Error Message, Templates

  72.  
  73. Format Controls Are Not Available in the Command and Options Dialog Box When you save a workbook in Microsoft Office Excel 2003 as a Web page with interactivity, the worksheet controls on the Workbook's toolbar and on the Format tab in the Command and Options dialog box may be unavailable. You can see this symptom if... KB#813975. Keywords: Format, Errors, Password, Toolbar, Web

  74.  
  75. Excel Quits Unexpectedly When You Insert Object into the Worksheet When you attempt to insert an object in Microsoft Excel (click Object on the Insert menu), you receive the following error message The instruction at address references memory at address. The memory could not be written where address is a... KB#312949. Keywords: ActiveX, Errors, Object, Error Message, File Name, Registry

  76.  
  77. You Cannot Update Links to Files on Secure Web Server You may not be able to update links in a Microsoft Excel workbook that is located on a secure Web server that uses Web Folders. For example, you may experience the following behaviors: When you click Links on the Edit menu to update the... KB#811542. Keywords: Errors, Formulas, Links, Error Message, Files, Web

  78.  
  79. Drawing Objects on Charts Move After You Save and Reopen When you save a workbook, close it, and then reopen it, drawing objects on charts in the workbook may shift... KB#303809. Keywords: Charts, File Name, Files

  80.  
  81. Filename Is Not Valid" When You Quit Microsoft Excel When you quit Microsoft Excel, you may receive the Filename is not valid error message, if both of the following conditions are true: You have logged on to the computer with a user name that exceeds eight characters. -and- You have disabled the... KB#133707 ". Keywords: Errors, Error Message, Toolbar

  82.  
  83. Application Error in Module Excel.exe at Offset 0001d05f You may receive an application error message with the following attributes: Event: Application Failure Application: excel.exe Version: 10.0.3506.0 Module: excel.exe Module Version: 10.0.3506.0 Offset:... KB#321312. Keywords: Errors, Error Message, File Name, Files, Parse

  84.  
  85. Workbook Corrupted If You Delete, Copy, and Save in Macro Procedure You may receive the following error message when you open a workbook: The instruction at 0x3005ca13 referenced memory at 0x00000018. The memory could not be... KB#265305. Keywords: Errors, Macro, VBA, Corrupted, Error Message

  86.  
  87. You Cannot Activate Embedded Excel Workbook That Contains VBA Code If you activate an embedded Microsoft Excel workbook that contains Microsoft Visual Basic for Applications (VBA) code in Microsoft Word, and then save the Word document, it is not possible to activate the workbook... KB#321471. Keywords: VBA, File Name, Files

  88.  
  89. How to Add a Command to a New Toolbar In the programs listed at the beginning of this article, the steps for creating a new toolbar may differ from steps that you use in earlier versions of these programs. This article lists the steps to use when you want to add a command to a new... KB#200522. Keywords: Toolbar

  90.  
  91. You Receive a "Microsoft Excel Cannot Open or Save Any More Documents" Error Message When You Open or Save an Excel File Through a Terminal Services Session When you try to open or save a Microsoft Excel file through a Terminal Services session, you may receive the following error message: Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk... KB#830065. Keywords: Errors, Error Message, Terminal Services

  92.  
  93. Circular Reference Does Not Calculate During Range.Calculate Execution When you use the Range.Calculate method or the Rows.Calculate method in Microsoft Visual Basic for Applications (VBA), and the range contains all the cells in a circular reference, the calculation does not occur and there is no error message... KB#827990. Keywords: Errors, VBA, Circular References, Error Message

  94.  
  95. Cannot Expand PivotTable If Data Is Not Saved with Table You can only expand a PivotTable when the Save data with table layout check box is... KB#283838. Keywords: PivotTables, File Name, Files

  96.  
  97. Compare Excel Worksheets and Workbooks Keywords: Dates, Links, Files, Toolbar, Web, Comments

  98.  
  99. Templates Do Not Appear in New Dialog Box When you try to create a new document, you may be unable to view all templates from the New dialog box (on the File menu) if the following conditions are true: The templates exist in subdirectories under the main template directory. The... KB#262633. Keywords: Templates

  100.  

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

 Excel User's Home
 ExcelUser Blog      
 Site Map              
 Contact              
 Excel for Business
 Excel Dashboards   
 Excel Solutions   
 Exploring Excel   
 BI for Excel    
 Business Tools   
 Excel Catalog   
 Affiliate Program   
 Excel Help Portal
 
   
     
   
     
 


ExcelUser, Inc.
http://www.ExcelUser.com

Copyright © 2004 - 2009 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.

 


What's your greatest Excel challenge?
 

 


What's your greatest Excel challenge?