Excel 2003 Solution Center

Troubleshooting - Excel 2003

• How to troubleshoot startup problems in Excel
  Describes how to troubleshoot startup problems that you may experience when you start Excel. Provides links to other Knowledge Base articles that discuss known startup problems in more detail.
• Error message in Office when a file is blocked by registry policy settings
  Describes an issue that occurs when you try to open or to save a file type that is blocked by your registry policy setting in one of the programs in Office 2013, Office 2010, the 2007 Office system, or Office 2003.
• The link source for a defined name is not available in Excel
  Describes a behavior in which a defined name in an Excel workbook is not available as a workbook link as it was in earlier versions of Excel.
• Microsoft Office stops responding when you try to open or save a file
  Using Save, Save As or Open causes Office to hang or freeze for a long period of time. Office can hang or freeze when trying to open or save files on a mapped network device or drive.
• You receive a "Too many different cell formats" error message in Excel
  In Microsoft Excel 2003, when you format a cell or a range of cells, you may receive the following error message: In Microsoft Excel 2013, 2010, or 2007, files may produce the following error message: Other scenarios that are associated with styles are:...
• "SYLK: File format is not valid" error message when you open file
  When you try to open a text file or a comma-separated variable (CSV) file, you may receive the following error message:
• Nothing happens when you try to use the "Export to Microsoft Excel" command in Internet Explorer
  Describes an issue in which nothing happens when you try to use the "Export to Microsoft Excel" command in Internet Explorer.
• MS10-105: Description of the security update for the Microsoft Office 2003 File Converter Pack: December 14, 2010
  Resolves a security vulnerability that exists in the Microsoft Office 2003 File Converter Pack that could allow arbitrary code to run when a maliciously modified image is opened.
• External links may be calculated when you open a workbook that was last saved in an earlier version of Excel
  External links may be calculated when you open a workbook that was last saved in an earlier version of Excel
• Text box margins are lost in an Excel workbook when the workbook is saved as "Excel 97-2003 Workbook" and then reopened in Excel 2003
  Describes a problem in which the margins in a text box are lost in an Excel 2013, 2010 or 2007 workbook when the workbook is saved as "Excel 97-2003 Workbook" and then reopened in Excel 2003. A workaround is provided.
• Calculated field returns incorrect grand total in Excel
  Describes an issue that calculated field returns incorrect grand total in Excel.
• "Not enough memory" error messages when you copy formulas over large area in Excel
  Describes error messages that you may receive when you fill or copy formulas into a large area of a worksheet, or when you add formulas to a large worksheet. Provides steps to work around the source cell limit.
• Blank pages are unexpectedly printed in Excel
  Discusses a problem in which the blank pages are unexpectedly printed in Excel.
• "Save changes in <filename>" prompt even if no changes are made
  When you close a workbook in Microsoft Excel, you may be prompted to save changes to the workbook even if you have not made any changes
• Excel 2003 error: Excel cannot complete this task with available resources.
  Provides information about this error and various steps you can take to resolve it depending on the scenario.
• Columns in a text box do not generate a compatibility conflict in the Compatibility Pack for Word, Excel, and PowerPoint 2007/2010 File Formats when you open an Excel 2007 or 2010 workbook in Excel 2003
  Describes a problem that occurs because the text box Columns setting in Excel 2007 or 2010 is not flagged by the compatibility checker in the Compatibility Pack for Word, Excel, and PowerPoint 2007/2010 File Formats.
• MS11-073: Description of the security update for Office 2003: September 13, 2011
  Resolves security vulnerabilities in Microsoft Office 2003 that could allow arbitrary code to run when a maliciously modified file is opened.
• MS10-057: Description of the security update for Excel 2003: August 10, 2010
  Resolves a security vulnerability that exists in Microsoft Office Excel 2003 that could allow arbitrary code to run when a maliciously modified file is opened.
• XL: GETPIVOTDATA Function Displays #REF! Error If External Reference Is Closed
  When you create a GETPIVOTDATA function that refers to a PivotTable in another file that is closed, the function displays a #REF! error when you attempt to update the link.
• MS10-057: Vulnerability in Microsoft Office Excel could allow remote code execution
  Resolves a security vulnerability that exists in the affected versions of Microsoft Excel that could allow arbitrary code to run when a maliciously modified file is opened.
• Excel workbook is not held or stored on the printer when the whole workbook is printed to the private or secure area of the printer
  Describes a problem in which the printout goes to an output bin of a secure printer instead of to the private or secure area. The problem occurs when you print the entire workbook.
• You may receive a "Run-time error 1004" error message when you programmatically set a large array string to a range in Excel 2003
  Explains that if you use code to set a range value with an array that contains a large string in Excel 2003, you may receive a runtime error. To work around this problem, reduce the string to contain fewer than 911 characters.
• Excel 97-2003 workbooks (.xls) display #N/A! for Analysis Toolpak functions when opened in Excel 2003, Excel 2007 or Excel 2010
  An Excel 97-2003 workbook that contains Analysis Toolpak functions displays #N/A! in the formula bar or as the result of the formula in the cell.
• MS10-036: Description of the security update for Office 2003: June 8, 2010
  Resolves a security vulnerability that exists in Microsoft Office 2003 that could allow arbitrary code to run when a maliciously modified file is opened.
• MS10-080: Vulnerabilities in Microsoft Excel could allow remote code execution
  Resolves a security vulnerability that in the affected versions of Microsoft Excel. This vulnerability could allow arbitrary code to run when a maliciously modified file is opened.