Home > Excel Help Portal > Using External Data with Excel

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

Using External Data with Excel

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

101. Can't Drag and Drop Movies/Sounds to Excel or Word When you attempt to use a drag and drop operation to move a movie or sound object from Microsoft PowerPoint to Microsoft Word or Microsoft Excel, a picture image appears in place of the object. This behavior does not occur when you use the drag... KB#198340. Keywords: OLE, Sounds, Object

 
102. How to Configure Excel 2003 to Use Microsoft OLE DB Provider for OLAP Services 7.0 If you configure a Microsoft Online Analytical Processing (OLAP) query to use the older version of Microsoft OLE DB Provider for OLAP Services, Excel 2003 continues to use Microsoft OLE DB Provider for OLAP Services 8.0. This article describes how... KB#827295. Keywords: Query, OLE, Registry, DB

 
103. Prompted to Save Changes After Setting the Saved Property to True When you close your workbook, Microsoft Excel prompts you to save changes even though you had previously set the Saved property of the workbook to True in a Microsoft Visual Basic for Applications macro. For example, your macro contains a line of... KB#238488. Keywords: ActiveX, Macro, VBA, Toolbar

 
104. Web Page Created in Office 2000 Cannot Be Opened on the Macintosh On a Macintosh computer, if you try to open a Microsoft Excel 2000 workbook published as a Web page with interactivity, you may receive the following error message at the top of the window: To use this Web page interactively you must have... KB#235093. Keywords: ActiveX, Errors, Error Message, HTML, Internet Explorer, Web

 
105. How to Display ASP Results Using Excel in IE with MIME Types Instead of displaying your Web data in HTML tables, you can provide users with the option of displaying the data in Microsoft Excel. This article demonstrates how to create a Web page with tabular data obtained from Microsoft SQL Server, and render... KB#199841. Keywords: SQL, Password, Index Server, HTML, Web

 
106. Inserting an Excel Worksheet Object May Not Work Under Windows NT Terminal Server The insert object function of a container program may not work if the server program takes a long time to load. For example, if the automatic save feature in Microsoft Excel is turned on and you attempt to insert an Excel spreadsheet into a... KB#245462. Keywords: Add-In, OLE, Errors, Object

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

 
108. Records Needed to Make a BIFF5 File Microsoft Excel Can Use This article documents which records are required in order to build a valid BIFF5 file that Microsoft Excel will... KB#147732. Keywords: OLE, Fonts, Styles, Files, INDEX

 
109. How to Import and Export Works Spreadsheets to Excel 97 This article discusses how to convert spreadsheet documents between the versions of Works listed at the beginning of this article and Microsoft Excel... KB#163109. Keywords: Export, Startup, Files, Window

 
110. Excel Abruptly Quits When You Save a Workbook When you save an Excel 2002 workbook, Excel may abruptly quit with an Application... KB#822380. Keywords: ActiveX, Errors, VBA

 
111. "Compile Error in Hidden Module: RegistrationDB" Error Starting Excel When you start or quit Microsoft Excel, you receive an error message similar to the following: Compile error in hidden module:... KB#291214. Keywords: Third-Party, Errors, Error Message

 
112. Ole_samp.exe to Microsoft Excel, Word, & PowerPoint Ole_samp.exe is a sample extracting file that provides an introduction to the concepts of OLE Automation using Visual FoxPro as the OLE client and Microsoft Word for Windows version 7.0, Microsoft PowerPoint for Windows 95 version 7.0, and... KB#148474. Keywords: Download, OLE, Files

 
113. How to Find Resources on Microsoft Excel Solver You can find more information about Microsoft Excel Solver in the following resources: For detailed information about the algorithm Microsoft Excel Solver uses, please see the following article in the Microsoft Knowledge Base: 82890 XL: Solver... KB#146606. Keywords: Solver, Third-Party, Web

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

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

 
116. "Compile Error in Hidden Module: RegistrationDB" Error Starting Excel When you start or quit Microsoft Excel, you receive an error message similar to the following: Compile error in hidden module:... KB#235326. Keywords: Third-Party, Errors, Error Message

 
117. Server Application Cannot Be Found When You Open Embedded Excel Object In Microsoft Excel 2000, when you try to edit or open an embedded Excel object, you receive the following error message: The server application, source file, or item cannot be found. Make sure the application is properly installed, and that it has... KB#268524. Keywords: ActiveX, Errors, VBA, Object, Error Message

 
118. ActiveX Control Samples for Microsoft Office 97 Developer Edition (ODE) The self-extracting file described in this article contains a Microsoft Excel 97 workbook with 15 ActiveX Control examples and a Readme.txt file. IMPORTANT : To use the examples in this workbook, you must install the ActiveX Controls that are... KB#252911. Keywords: Download, ActiveX, Files

 
119. STOP 0x1e Error Message Appears When You Try to Print from Excel or Word Using HP LaserJet 8100 PCL6 Printer Driver When you try to print from Microsoft Excel or Microsoft Word in landscape mode from a Microsoft Windows NT 4.0-based computer, using the Hewlett-Packard (HP) LaserJet 8100 PCL6 printer driver, you may receive a STOP 0x1e error... KB#255238. Keywords: Third-Party, Errors, Printing, Error Message, Web

 
120. How to Select Cells in Excel by Using OLE Automation This article shows by example how to use OLE Automation programmatically to create a Microsoft Excel worksheet, and select a range of... KB#139051. Keywords: OLE, Object

 
121. Combo Box Values Revert to Defaults After Another Combo Box Is Used If an Excel 2002 worksheet contains two or more ActiveX combo boxes, and you change the value of the first combo box, and then make a change to another combo box, the first box may revert back to its default... KB#811541. Keywords: ActiveX, Combo Box, Internet Explorer

 
122. Change recorded macro to import text file in next available row instead of using A1 every day. Change your recorded macro where it says something likeRange(“MyRange”)ToActiveCell MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for... Keywords: Import Data, Macro, VBA, Web

 
123. Converting non-numbers to actual values Q. I often import data into Excel from various applications, including Access. I've found that values are sometimes imported as text, which means I can't use them in calculations or with commands that require values. I've tried formatting the cells as values, with no success. The only way I've... Keywords: Charts, Import Data, Format, Formulas, Printing

 
124. Oracle Data to Excel - Custom Excel Solutions for Oracle from Mr Excel Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of the Tickling Keys, Inc. All contents Copyright 1998-2003 by MrExcel... Keywords: Export, SQL, Format, Files, Text Files

 

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