Home > Excel Help Portal > Excel System

<<  (Page 4)  Previous              Next  (Page 6)  >>

Excel System

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

201. Workbook Is Slow to Open When you open an Excel 2002 workbook, it may take a long time before the workbook... KB#327365. Keywords: Dates, Formulas, File Name, Files, Web, VLOOKUP

 
202. Excel Support Center Keywords: Download, XML, Errors, Error Message, Templates, Links, RAND, RANDBETWEEN, INTERCEPT, FORECAST

 
203. How to Programmatically Save a File to a Network Drive In Microsoft Excel, you can save a file to any drive to which you have write and delete privileges. In addition, you can use a Microsoft Visual Basic for Applications macro to save the active workbook and use a variable for the file name. You can... KB#213641. Keywords: VBA, Macro, File Name, Save A File, Web

 
204. How to work with an HTML Table That Contains Merged Cells in Excel 2000 This article describes how to import a Hypertext Markup Language (HTML) table and unmerge any cells, so that Excel 2000 can filter and sort the data. Although you can import HTML tables into Excel, many HTML tables use merged cells that prevent... KB#275611. Keywords: Sorting, Format, Errors, Error Message, File Name, Files, HTML, Internet Explorer, Web

 
205. How to a Make Spinner with a Minimum Value Less Than Zero In Microsoft Excel, the spinner control that is on the Forms toolbar has a minimum value of zero. The Microsoft Excel Visual Basic for Applications macro example in this article demonstrates how you can use a spinner control that appears to... KB#213303. Keywords: Format, VBA, Macro, Toolbar, Web

 
206. Objects May Not Be Displayed Correctly When You Use ThirdParty Magnification Software When you use third-party magnification software with the Microsoft Office XP products that are listed at the beginning of this article, objects may not be displayed correctly. Some of the third-party products that are affected include the... KB#316618. Keywords: Third-Party, File Name, Files, Web

 
207. Text Overlaps When You View Excel Spreadsheets That Are Saved as HTML Files If you use Internet Explorer 6 to view Microsoft Excel 2000 or Microsoft Excel 2002 files that are saved as HTML files, you may see overlapping... KB#318727. Keywords: Dates, File Name, Files, HTML, Internet Explorer, Web

 
208. How to copy an Office File to a Disk This step-by step article describes how to copy a file from the My Documents folder on your computer hard disk to a 3.5-inch disk, and how to copy a file from a 3.5-inch disk to the My Documents... KB#812072. Keywords: Files

 
209. How To Share a Custom AutoFill List In Microsoft Excel 2000, custom lists are stored in the Microsoft Windows registry. You can exchange custom lists from one computer to another by using a macro that creates the custom list from a spreadsheet. The More Information section of... KB#213796. Keywords: VBA, Macro, Registry, Toolbar, Web

 
210. How to Force ReEntry of the Product Identification Code To troubleshoot activation or licensing issues, you may have to force the re-entry of your Office XP product identification code. This article describes how to force your computer to prompt you for your Office XP product identification code. NOTE... KB#325081. Keywords: Registry

 
211. Error Message When You Open an Excel 2000 File in the Exchange Public Folder When you open a Microsoft Excel 2000 file in an Exchange 2000 public folder and close the file without making a change, you may receive the following error message: Unable to save changes to the document. Your changes will be placed in the... KB#831229. Keywords: Errors, Error Message, Registry

 
212. Error Message When You Open an Excel 2002 File in the Exchange Public Folder When you open a Microsoft Excel 2002 file in a Microsoft Exchange 2000 public folder and close the file without making a change, you may receive the following error message: Unable to save changes to the document. Your changes will be placed in... KB#831111. Keywords: Errors, Error Message, Registry

 
213. Hyperlink Syntax Does Not Save Correctly When You Save an Excel File as an HTML Page If you open an Excel workbook that contains cross-sheet hyperlinks, and then save the workbook as a Hypertext Markup Language (HTML) page, the hyperlink syntax does not save correctly. When you use a Web browser to open the HTML file where you... KB#324125. Keywords: Dates, File Name, Files, HTML, Hyperlinks, Web

 
214. Excel Quits When You Click an ActiveX Control When you click a Microsoft ActiveX control immediately after you click another ActiveX control on a worksheet, Excel may... KB#330157. Keywords: Dates, ActiveX, File Name, Files, Web

 
215. Macro to Open the Most Recently Used File In Microsoft Excel 2000, if you click to select the Recently used file list check box (on the General tab of the Options dialog box on the Tools menu), the files that you used most recently are listed on the File menu. This article contains a... KB#213758. Keywords: Errors, VBA, Macro, Error Message, File Name, Files, Web

 
216. How to Recover a Lost Worksheet or Lost Version of a Worksheet If you mistakenly delete, lose, save over the top of, or do not save an Excel 2002 worksheet, you may be able to recover it. Excel 2002 has an AutoRecover feature that automatically saves worksheets in the case of accidental loss of power or... KB#324521. Keywords: File Name, Files

 
217. Error Message: This File Is Not in a Recognizable Format When you open a file in Microsoft Excel, the following error message appears: If you are opening an Excel workbook file, the file may be damaged. For suggestions on how to recover data contained in a damaged workbook, please see the following... KB#224135. Keywords: Download, Export, Format, Errors, Error Message, Files, Links, Web

 
218. Index Server 3.0 Does Not Correctly Index Some Excel Files Index Server may not correctly index some Excel files because of problems parsing certain character... KB#327012. Keywords: Dates, File Name, Files, Index Server, Web

 
219. Edits to PivotTables Do Not Bring Back New Columns If you create a PivotTable that contains grouped data, you may not be able to edit the data. You can go into query by means of the PivotTable Wizard and add or delete fields of data to be returned to the PivotTable. However, when you return the... KB#325207. Keywords: Query, Dates, PivotTables, File Name, Files, Web

 
220. Errors When Using ODBC to Insert Microsoft Excel Worksheet When you attempt to insert a Microsoft Excel worksheet into a Word document or when you attempt to attach a Microsoft Excel worksheet as a data document to a mail merge main document using the Excel Files via ODBC (*.xls) driver, one of the... KB#245652. Keywords: Query, SQL, Errors, Setup, Error Message, Files, Toolbar

 
221. A description of the way that Excel saves files Describes the process Excel uses when you save a... KB#814068. Keywords: Errors, Error Message, File Name, Files, Save A File

 
222. Using the Discussion Feature in Internet Explorer This article explains how to use the Discussion feature in Microsoft Internet Explorer when you are viewing files created in a Microsoft Office 2000... KB#255085. Keywords: Files, Toolbar, Internet Explorer, Web

 
223. Macro to Place Filenames in Given Directory on Worksheet The sample macros in this article place the names of all specified file types (specified by file name extension, for example .XLS) for a specified directory into a column on a... KB#74493. Keywords: Add-In, VBA, Macro, File Name, Files, Web

 
224. How to Use Data Validation to Prevent Duplicate Entries This article explains how to use data validation to prevent you from making duplicate entries in a... KB#189005. Keywords: Styles, Errors, Formulas, Error Message, Toolbar, Validation

 
225. Index Service Stops Responding When Filtering Japanese Excel File Indexing Services may loop infinitely when it tries to index certain Microsoft Office documents. Currently, the only case where this is found to occur is with a Japanese Microsoft Excel spreadsheet on the Japanese version of Windows 2000. No... KB#321073. Keywords: Query, Errors, File Name, Index Server, Web

 
226. How to Create a Loan Amortization Schedule The purpose of this article is to demonstrate how to create a basic loan amortization schedule in Microsoft... KB#816643. Keywords: Format, Symbol, Formulas, Templates, Web, PMT

 
227. Cannot Disable ToolTips Directly from Microsoft Query You cannot disable ToolTips from within Microsoft Query. If you do not want ToolTips to be displayed, do the following according to the version of Microsoft Query you are using: Microsoft Query for Windows 95, version 2.0 WARNING: Using... KB#107254. Keywords: Query, Files, Registry

 
228. Files Corrupted on Save: How to Troubleshoot Source of Problem Files that you save to a floppy disk or to a network drive may intermittently become corrupted or... KB#213951. Keywords: Startup, Corrupted, Files

 
229. How to Restrict Numeric Entry to Only One Cell in a Range This article shows you how to use data validation to ensure that a number can be entered into only one cell in a range that you... KB#188661. Keywords: Errors, Formulas, Error Message, Toolbar, Validation

 
230. Arrowheads in Drawing Line in Embedded Object Appear Much Larger Than Expected When you use the Drawing toolbar to draw a line with arrowheads in an embedded object in a Microsoft Office document, the arrowheads may appear much larger than... KB#825005. Keywords: Fonts, Format, Object, Registry, Toolbar

 
231. How to Recover a Lost Workbook or a Lost Version of a Workbook If you delete, lose, save over, or do not save an Excel 2003 workbook, you may be able to recover it. Excel 2003 has an AutoRecover feature that automatically saves workbooks when you have an accidental loss of power or similar... KB#827298. Keywords: File Name, Files

 
232. When You Click a File Icon, Excel Starts but the File Does Not Open as Expected When you double-click the icon for a Microsoft Excel (.xls) file (or right-click the icon, and then click Open ), Excel starts but the file does not open as expected. However, you are able to open the workbook when you click Open on the File menu... KB#304424. Keywords: Errors, Error Message, File Name, Registry

 
233. How to Obtain a New Product Key for Office Program Setup This article describes how to obtain a new product key for your Microsoft Office program setup if your product key label is damaged or is... KB#823570. Keywords: Setup, CD-ROM, Registry

 
234. How to display All Menu Commands in Office XP Programs This step-by-step article describes how to display all menu commands in a Microsoft Office XP program. When you first start an Office program, the menus and toolbars display basic commands and buttons. As you work with an Office program, the... KB#290374. Keywords: Toolbar

 
235. Drawings in Files That Are Created in Versions of Excel Before Excel 97 Are Not Displayed Correctly Embedded metafiles in Excel 2000 spreadsheets may not be displayed properly on a Windows 2000-based system. The layering may appear jumbled, hiding parts of the drawings. If the problem objects are manually ungrouped, large areas of... KB#321244. Keywords: Metafiles, Dates, File Name

 
236. How to use the AutoRepublish Feature in Excel 2002 This step-by-step article explains how to use the AutoRepublish feature. Microsoft Excel 2002 has a new feature, AutoRepublish, which allows you to automatically update a Web page as the workbook from which it was created is updated. AutoRepublish... KB#289262. Keywords: Charts, Errors, Macro, Error Message, File Name, Links, Web

 
237. Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution When you print a slide in Microsoft PowerPoint, borders around the far right column of embedded Microsoft Excel objects may not print... KB#316070. Keywords: Borders, Printing, File Name, Files

 
238. Error Trying to Quick View Microsoft Excel Workbook When you use the Quick View command in Microsoft Windows 95 to view a Microsoft Excel workbook file, you may receive the following error message There is no viewer capable of viewing Microsoft Excel Worksheet files. and you are unable to view... KB#150366. Keywords: Charts, Errors, Error Message, Files

 
239. How To Recover MS Excel File If Unwanted Changes Are Made In Microsoft Excel, if you save unwanted changes to a file, you may be able to recover the original... KB#150368. Keywords: Third-Party, Errors, Error Message, File Name, Files, Macintosh , Save A File

 
240. "Open Clip In" Command Opens the File Instead of the "Open With" Dialog Box In Microsoft Clip Organizer, when you click the drop-down arrow to the right of the clip, and then click Open Clip In on the Properties menu, the clip opens in whichever program that is associated with the clip file type. It does not display the... KB#285628. Keywords: Errors, Error Message, Files

 
241. Combo Box Control on a Worksheet Returns to Its Original Value After Refresh A combo box control on a worksheet displays the original value, rather than the new value, after you change the focus from the control to another area of the screen, or after you refresh the display. For example, if a combo box is initialized with... KB#311749. Keywords: ActiveX, Combo Box, File Name, Files, Toolbar, Hyperlinks

 
242. Contents of PivotTable Disappear When Data Is Updated in a Different Language Version of Excel In Microsoft Excel, if you create a PivotTable that is based on multiple consolidation ranges, open the file in a different language version of Excel, and then update the data, the contents of the PivotTable... KB#316479. Keywords: PivotTables, File Name, Registry

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

 
244. You Receive a "Cannot Open Protected File" Error Message When You Open a TabDelimited Text File If you try to open a tab-delimited text file that begins with the letter C in Microsoft Excel 2002, you may receive the following error message: Cannot open protected... KB#831959. Keywords: Errors, Error Message, Registry, Text Files

 
245. 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#141574. Keywords: Arrays, Macro, VBA, File Name, Files, Web

 
246. How to Assign a Macro to an Option Button In Microsoft Excel, you can assign a macro to a custom option button so that when the option button is selected, the macro is... KB#141689. Keywords: Outline, Macro, Toolbar

 
247. How to specify Trusted Sources for Digital Certificates in Excel 2002, PowerPoint 2002, and Word 2002 If you open a document that contains a digitally signed macro, you are prompted to select whether to trust the source if the following conditions are true: The digital certificate has not previously been trusted. -and- The security for your program... KB#308983. Keywords: Macro, Files, Templates

 
248. How to handle Corrupted Excel Files by Saving Them in the SYLK Format This step-by-step article describes how to use the SYLK format to save corrupted files. If you suspect that you have a corrupted Microsoft Excel file and you can open the file, you can use the method in this article to filter the file. This... KB#300639. Keywords: Graphic, Format, Corrupted, Files

 
249. Excel -- Sorting Data The Basics Sort by One Column Sort by Two or Three Columns Using the Sort Buttons Sort by Four or More Columns In Excel, it's easy to sort your data by using the Sort buttons on the toolbar. But, be careful, or one column may be sorted, while others are not. Occasionally, you may need to sort by... Keywords: Sorting, Toolbar

 
250. Excel 2000: Excel Quits When GetPivotData Function Is in Second Workbook If you create a GetPivotData function in Microsoft Excel 2000, Excel may quit unexpectedly. This problem occurs if: The PivotTable is in one workbook, and the GetPivotData function is in another workbook. The PivotTable contains a date... KB#324391. Keywords: Dates, Format, Formulas, PivotTables, File Name, Files

 

<< (Page 4)  Previous              Next  (Page 6) >>