Home > Excel Help Portal > Excel System

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

Excel System

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

151. How to Customize a Custom Toolbar Button This article explains how to create a custom button on a toolbar and how to assign a macro to that custom... KB#213754. Keywords: VBA, Macro, Toolbar, Web

 
152. How to use Excel Startup Folders in Excel 2003 This step-by-step article explains how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways: To load Excel files at startup. -and- As a reference location for templates. The actual startup folder locations vary,... KB#822107. Keywords: Add-In, Format, Errors, Startup, Macro, Error Message, Files, Save A File, Templates

 
153. How to Create a Report Template In Microsoft Excel 97 there is a new feature called a report template. A report template is a Microsoft Excel template that includes one or more queries or PivotTables based on external data. When you save a report template, the external data is... KB#156449. Keywords: PivotTables, File Name, Templates

 
154. Comments Appear in the Wrong Place in Workbook Saved As Web Page When you save an Excel workbook as a Web page, and then view the Web page in your Web browser, comments may appear in the wrong place. For example, a comment may appear in a lower place on the page, where the next comment should... KB#820432. Keywords: Dates, File Name, Files, Web, Comments

 
155. You Receive Error Messages When You Delete Multiple Columns from a Graph If you try to delete multiple columns from a Microsoft Graph file that is embedded in a Microsoft PowerPoint presentation slide, you may receive the following error message: CiceroUIWndFrame: GRAPH.EXE - Application Error The instruction at... KB#323613. Keywords: Dates, Errors, File Name, Files, Web

 
156. Links in OLE Object Do Not Automatically Update When You Open a File in Windows Explorer When you open an Excel file in Windows Explorer that contains an OLE object with links to another file, the OLE object's link may not update. This symptom may occur although you click Update to update the... KB#812647. Keywords: Dates, OLE, Links, Object, File Name, Files, Web

 
157. Workbook Does Not Print When You Use Excel on a Tablet PC When you use Microsoft Excel on your Tablet PC and you print an Excel workbook, some text in the workbook may not print. Note When you use the Print Preview feature to view the Excel workbook, all the text in the Excel workbook appears... KB#821273. Keywords: Dates, Printing, File Name, Files, Web

 
158. FRMWRK32.EXE: Updated Generic.xll Template for Excel The sample code provided contains a template that can used for writing 32-bit Microsoft Excel XLLs for Windows. This code demonstrates many of the features of the Microsoft Excel C API. This sample was updated from the Microsoft Excel Developer's... KB#152152. Keywords: Add-In, Download, API, DLL, Export, Startup, Macro, Files, Templates

 
159. How to Change the ToolTip for a Custom Toolbar Control Microsoft Office programs do not allow you to change the ToolTip for a custom toolbar control by using the Customize command (on the Tools menu). To change the ToolTip, you must use a Microsoft Visual Basic for Applications macro. This... KB#171595. Keywords: VBA, Macro, Toolbar, Web

 
160. Preventing the Office Clipboard Toolbar from Appearing It is possible to prevent the Clipboard toolbar from automatically appearing when you use multiple Copy commands in any Microsoft Office program. This article explains how to do this by modifying the Windows Registry. NOTE : You cannot disable... KB#207438. Keywords: Charts, Clipboard, Registry, Toolbar

 
161. How to configure a System Policy to Control the Recently Used File List in an Office XP Program In the Office XP programs listed at the beginning of this article, you can control whether the user sees a list of recently used documents on the File menu and how many file names are displayed in the list. This list is technically referred to as... KB#307949. Keywords: Files, Registry, Templates

 
162. "Unable to Read File" Error Message When You Open a Workbook When you try to open a workbook, you receive the following error message: Unable to read file. After you click OK , the Document Recovery task pane does not appear, and the workbook is not... KB#812384. Keywords: Dates, Errors, Corrupted, Error Message, File Name, Files, Web

 
163. How To Share a Custom AutoFill List In Microsoft Excel, custom AutoFill lists are stored in the Microsoft Excel toolbar file. You can exchange custom lists from one computer to another either by copying the Microsoft Excel toolbar file or by using a macro that creates the custom... KB#150360. Keywords: VBA, Macro, Toolbar, Web

 
164. Linking Charts Does Not Work Correctly If Name Has More Than 64 Characters In Microsoft PowerPoint 2000 or Microsoft Word 2000, when you link to a chart object created in Microsoft Excel 2000, you may experience the following problems. Microsoft Word 2000 When you paste the chart as a link in a Word 2000 document,... KB#249060. Keywords: Charts, Errors, Links, Object, Error Message, File Name, Files

 
165. You receive an error message when you use Microsoft Script Editor in an Office 2003 program Describes an issue that occurs when you use the Microsoft Script Editor in one of the Office 2003... KB#840184. Keywords: Errors, Corrupted, Error Message, Links, Web

 
166. Macro to Change File Type to "All Files (*.*)" in Open Dialog Box In the Open dialog box in Microsoft Excel, the default setting in the Files of type box is Microsoft Excel Files (*.xl*; *.xls; *.xla; *.xlt; *.xlm; *.htm; *.html). This article provides a sample Visual Basic for Applications macro that changes... KB#213755. Keywords: VBA, Macro, Files, Toolbar, Web

 
167. How to Copy the Text Within a Text Box to a Cell This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that copies the text within a text box and pastes it into a spreadsheet. After following the steps outlined in this article, you should see the text appear... KB#152379. Keywords: Text Box, VBA, Macro, Toolbar, Web

 
168. Time Calculation in Pivot Table May Not Be Accurate When you create a PivotTable in a new Excel 2002 workbook, the time calculation that is contained in the PivotTable is not calculated... KB#816997. Keywords: Dates, PivotTables, File Name, Files, Web

 
169. Errors After Copying Worksheet with Auditing Arrows In Microsoft Excel, the following problems may occur: When you delete a worksheet, you 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.... KB#211439. Keywords: Format, Errors, Error Message, File Name, Toolbar, Auditing

 
170. Inserting an Excel Worksheet Object May Fail Under Windows NT The insert object function of a container application may fail if the server application takes a long time to load. For example, if the autosave feature of Microsoft Excel is turned on and you attempt to insert an Excel Spreadsheet into a... KB#173191. Keywords: Add-In, OLE, Errors, Object, AutoSave, File Name, Web

 
171. How to Prevent Customization of Menus and Toolbars In Microsoft Office 97, Service Release 1 (SR-1), the CommandBars object model allows you to turn off (disable) the Toolbars shortcut menu. This simplifies preventing others from changing the toolbars and menus of a custom application that you... KB#170563. Keywords: VBA, Object, Menu Command, Toolbar, Web

 
172. How to Copy Files from Cabinets on DMFFormatted Disks The files on Disk 2 and later of the Setup program for Microsoft Excel for Windows are stored in cabinet files on DMF-formatted disks. If you need to copy the files from the disks to a network server or other permanent storage drive, you must use... KB#120006. Keywords: Setup, Files, Setup Program

 
173. A macro to control Word from Excel Thanks to Jake who provided this week's question: How can I write a macro which will take Excel spreadsheet data and create a Word file for each row of data. Jake - what a great idea! I often have sales results for the entire company and it would be great to be able to send each rep just his or her... Keywords: Sales, Clipboard, VBA, Macro, Object, File Name, Templates, Web

 
174. How to convert an Addin File into a Workbook in Excel 2000 This step-by-step article describes how to convert an add-in (.xla) file into a normal workbook (.xls) file that you can view and edit. Convert Add-in to Workbook To convert an add-in file back into a normal workbook, follow these steps: On the... KB#211561. Keywords: Add-In, Charts, Password, VBA, File Name, Files, Window

 
175. Incorrect Results When You Perform Mail Merge with Excel Data Source When you perform a mail merge with a Microsoft Excel data source, the results of the mail merge may not be correct. For example, a record that contains a blank field in the data source displays the data from the previous record in the merge... KB#204542. Keywords: Dates, DDE, File Name, Files

 
176. The /Automation CommandLine Switch Does Not Disable COM Addin Programs When you use the /automation command-line switch to start Excel, COM add-in programs load unexpectedly. (The /automation switch should disable all automatically opened files and auto-run... KB#320058. Keywords: Add-In, File Name, Files, Registry

 
177. Changed Macro Behavior with Excel Files When you click a control on a worksheet that is assigned to a macro, you receive the following message: The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to... KB#262876. Keywords: Macro, Templates, Toolbar

 
178. Error Message: RunTime Error:'13' Type Mismatch When you click a macro or you click a function on a menu that was created by another macro, you may receive the following error message: Run-time error:'13' Type... KB#821292. Keywords: Dates, Errors, Macro, File Name, Files, Web

 
179. How to Link a Visio Drawing to a Specific Region Within an Excel Worksheet This article describes how to embed a link in a Microsoft Visio drawing to a named region within a Microsoft Excel... KB#296528. Keywords: OLE, Links, Object, Ask a Question box, Files

 
180. How to Create a BIFF5 File BIFF is a file in the Microsoft Download Center that demonstrates how to create a file using the Microsoft Excel Binary Interchange File Format (BIFF) version... KB#150447. Keywords: Download, OLE, Format, Macro, File Name, Files, Comments

 
181. How to Display the Open and Save As Dialog Boxes When you use Microsoft Excel, you may want to display the Open or the Save As dialog boxes using Microsoft Visual Basic for Applications procedures. This article explains several ways to accomplish this task. Note that the Open and Close methods... KB#139723. Keywords: Macro, VBA, File Name, Save A File, Toolbar, Web

 
182. How to Programmatically Insert Data from a List Box into the Active Cell This article describes a sample Microsoft Visual Basic for Applications Sub procedure (macro) that enters a selected item from a list box into the active cell on a... KB#213363. Keywords: Format, VBA, Macro, Object, Web

 
183. How to Copy the Text Within a Text Box to a Cell This article contains a sample Microsoft Visual Basic for Applications macro that copies the text within a text box and pastes it into a spreadsheet. After following the steps outlined in this article, you should see the text appear in the... KB#213793. Keywords: Text Box, VBA, Macro, Toolbar, Web

 
184. How to Change the Alternate Startup Folder (Directory) The following example explains how to change the alternate startup folder (directory) without having to start Microsoft... KB#153543. Keywords: Startup, Files, Registry

 
185. How to Use FileSearch to Fill a Listbox with File Names In Microsoft Excel 97 for Windows, you can use the FileSearch object to locate files on a local or network drive. This article provides an example of how to use the FileSearch object in Microsoft Visual Basic for Applications to fill a list box... KB#155837. Keywords: Arrays, VBA, Macro, Object, UserForm, File Name, Files, Web

 
186. How to save addresses that are contained in a Word mail merged label document in Excel This article describes how to save addresses that are contained in a Microsoft Word mail merged label document to a Microsoft Excel... KB#832286. Keywords: Gridlines, File Name, Files

 
187. How to open Documents from FTP Site and Save Documents to FTP Site with an Office Program This step-by-step article describes how to open documents from, and save documents to, a File Transfer Protocol (FTP) Web site by using Microsoft Office programs. Open a File from an FTP Site To open a file from an FTP site, follow these steps: On... KB#290142. Keywords: Password, Files, Save A File, Internet Explorer, Web

 
188. How to Open a Copy of a Template in MS Excel 7.0, 97 Microsoft Excel provides several ways for you to create a copy of a template. However, if you use the Open command on the File menu to open a template, the template opens in edit mode. In earlier versions of Microsoft Excel, when you click Open on... KB#133137. Keywords: Startup, VBA, Macro, Templates

 
189. WINHLP32 Causes Invalid Page Fault Running Help When you use Help in the products that are listed at the beginning of this article, and you are running Microsoft Windows 95 or 98, you may receive the following error message: This program has performed an illegal operation and will be shut down.... KB#148117. Keywords: Export, Errors, Registry

 
190. How to Convert an Addin File into a Workbook In Microsoft Excel 97, you can convert an add-in (.xla) file into a normal workbook (.xls) file that you can view and edit. This article contains detailed information about converting an add-in... KB#156943. Keywords: Add-In, Charts, Password, VBA, File Name, Files, Window

 
191. Office 2003 program is slow or may appear to stop responding (hang) when you open a file from a network location When you try to open a file from a network location in one of the Microsoft Office 2003 programs listed in the Applies To section of this article, the Office program may run very slowly or may appear to stop responding... KB#833041. Keywords: File Name, Registry

 
192. Error Message When Opening a File by DoubleClicking the File Name When you double-click a Microsoft Excel file type (.xls), Excel starts as expected, but then you may receive an error message similar to the following: C:\ filename .xls' could not be found. Check the spelling of the file name, and verify that... KB#207574. Keywords: Errors, Error Message, Files, Registry

 
193. Error Message: Excel Caused an IPF in Module Excel.exe When you try to start Microsoft Excel 2000, you may receive an error message similar to the following: Excel caused an IPF in module excel.exe. Excel does not start. If you try to start Excel in safe mode by using the /s startup switch, Excel... KB#327761. Keywords: Errors, Startup, Corrupted, Error Message, File Name, Registry

 
194. Sample Macros to Return ID for a CommandBar Control The ID property for the CommandBar object uses a unique number for each built-in menu bar, shortcut menu bar, submenu, menu item, or toolbar. The ID is often required when you reference a control on a command bar. The Visual Basic for... KB#213211. Keywords: Charts, Formulas, PivotTables, VBA, Macro, Object, Menu Command, Toolbar, Web

 
195. How to Publish a Web Document to an FTP Site This article describes how to publish a Microsoft Office document to a Web server by using the File Transfer Protocol... KB#290298. Keywords: Format, Password, File Name, Files, Web

 
196. Linked Files with Lookup Functions Updated Much More Slowly Than in Earlier Versions of Excel When you click Yes to update the links on a workbook that you are opening, Microsoft Excel appears to stop responding (hang). After a long wait, the links are updated, and you gain control of the worksheet. The same workbook may have been updated... KB#248207. Keywords: Formulas, Links, Files, Registry, VLOOKUP, HLOOKUP

 
197. How to Programmatically Display All Files in a Folder In Microsoft Excel, you can create a sample Microsoft Visual Basic for Applications Sub procedure (macro) that loops through specified files in a folder (directory) and displays each file name in a dialog... KB#213369. Keywords: VBA, Macro, File Name, Files, Web

 
198. AutoCalculate feature is working even if that feature is turned off Fixes the problem where the AutoCalculate feature still functions when you change the color scheme for the display or update Group... KB#325703. Keywords: Dates, Colors, File Name, Files, Web

 
199. How to Open a Copy of a Template in Microsoft Excel 2000 Microsoft Excel provides several ways for you to create a copy of a template. However, if you use the Open command on the File menu to open a template, the template opens in edit mode. In versions of Microsoft Excel before Excel 97 and Excel 7.0,... KB#213817. Keywords: Startup, VBA, Macro, Templates

 
200. 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#141512. Keywords: VBA, Macro, File Name, Save A File, Web

 

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