Home > Excel Help Portal > Excel and the Web

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

Excel and the Web

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses topics about Excel and
the Web.

51. Data Is Truncated When You Download a GzipEncoded Excel File in Internet Explorer When you download a Microsoft Excel file that uses HTTP compression (gzip-encoded) in Internet Explorer, if you open the file, the data is truncated. However, if you save the file to disk and then open the file using Excel, all the data is... KB#331596. Keywords: Dates, Download, File Name, Files, Internet Explorer, Web

 
52. Unable To Read File" Error Message When You Open a Workbook and Try to Update Links When you open a workbook in Microsoft Excel 2002 that contains links to other Excel workbooks, you may receive the following error message when you click Update to update the links in the workbook: Unable to read file. After you save the file as... KB#823026 ". Keywords: Dates, Errors, Links, Error Message, File Name, Files, HTML, Web

 
53. How to export Lotus 123 Linked Files to Excel 2000 This step-by-step article explains how to export Lotus 1-2-3 linked files to Microsoft Excel 2000. A Lotus 1-2-3 worksheet that is opened in Microsoft Excel and contains links to Lotus 1-2-3 source worksheets will maintain these links. These... KB#214009. Keywords: Export, Third-Party, Links, Object, Files

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

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

 
56. How to Programmatically Modify Hyperlink Addresses on a Worksheet This article demonstrates how to use Microsoft Visual Basic for Applications (VBA) to update or replace hyperlinks throughout a workbook or on only a single... KB#247507. Keywords: Links, VBA, Macro, Object, Hyperlinks, Web, Window

 
57. How to Format an Excel Workbook While Streaming MIME Content This article demonstrates how you can use Active Server Pages (ASP) to create a formatted workbook that can be streamed as MIME content to Microsoft... KB#271572. Keywords: XML, Format, Page Setup, HTML, Internet Explorer, Web

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

 
59. BUG: Excel Does Not Shut Down After Calling the Quit Method When Automating from JScript When automating Microsoft Excel from Microsoft JScript, Excel stays in memory after calling the Quit method until you close Internet Explorer or navigate to another... KB#266088. Keywords: Internet Explorer, Web

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

 
61. How to Find the Installation Path of an Office 2000 or an Office XP or an Office 2003 Application This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office or an Office XP or an Office 2003... KB#234788. Keywords: Download, Links

 
62. An example of a Cascading Style Sheet CSS You may hear of references to style sheets (CSS) which can be used to determine the effects of HTML commands such as headings, paragraphs and tables. They are not complicated and there is plenty of help available on the internet. Nevertheless, producing a working example can be time consuming and... Keywords: SQL, Borders, Colors, Format, Styles, Errors, Links, Class, Save A File, HTML, Hyperlinks, Web

 
63. Link back to original workbook There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in... Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

 
64. Selecting files within VBA There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in... Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

 
65. Stopping an Endless Loop There is a command in VBA called GetOpenFileName. It displays the File Open box. You can naviagate to a directory, select the file and then click Open. At this point, the command does not open the file, it merely passes the name back to your program. Here is an example of the code in... Keywords: Years, Links, Macro, VBA, Files, Hyperlinks, Web

 
66. How to Automate Excel from Java This article illustrates how to call a COM object like Excel from Java. It provides code samples that show how you can make an Excel application visible and open an existing Excel file. There are two code samples. One illustrates how to invoke... KB#169796. Keywords: Download, Object, Internet Explorer, Web

 
67. Sample Visual Basic Code to Update Links in an Excel Chart This article provides a sample Microsoft Visual Basic for Applications macro (Sub procedure) that updates the links inside a Microsoft Excel Chart object on a Microsoft PowerPoint... KB#251337. Keywords: Charts, OLE, Format, Links, VBA, Macro, Object, Web

 
68. How to Change an Existing Linked Excel Object After you use the Paste command in a Microsoft Word document to insert a link to a Microsoft Excel worksheet, there is no direct way to change the number of rows or columns being linked from... KB#211258. Keywords: Links

 
69. Macro to Link a Range of Cells in Word This article provides an example of how to link a Microsoft Excel worksheet to a Microsoft Word document using a Microsoft Visual Basic for Applications macro in conjunction with OLE Automation... KB#213316. Keywords: OLE, VBA, Macro, Object, Links, Web

 
70. Rounding numbers If I enter a formula to take one-third of a number like 100,000 - how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don't want the decimals to enter into subsequent calculations?Surround the formula with... Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

 
71. Getting Rid of Broken Links If I enter a formula to take one-third of a number like 100,000 - how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don't want the decimals to enter into subsequent calculations?Surround the formula with... Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

 
72. Getting Rid of Broken Links If I enter a formula to take one-third of a number like 100,000 - how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don't want the decimals to enter into subsequent calculations?Surround the formula with... Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

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

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

 
75. Share your spreadsheets on the Web If you use Excel 2000 or later, it's relatively easy to save a workbook in HTML as a web document. In fact, Excel supports two types: static documents and interactive documents After creating your workbook, use the File, Save as Web Page command. Specify what you want to save (a single worksheet or... Keywords: Charts, Dates, Microsoft Access, Format, Arrays, Errors, Formulas, Printing, Error Message, Files, HTML, Internet Explorer, Web, Window

 
76. Print Help File for Excel 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 a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Printing, VBA, Files, HTML, Hyperlinks, Web, Window

 
77. How to Import Web Page Tables into Microsoft Excel You can import tables from Web pages into Microsoft Excel 97. This article discusses two methods you can use to accomplish this... KB#165499. Keywords: Clipboard, File Name, HTML, Internet Explorer, Web

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

 
79. How to save a Workbook as a Web Page in Excel 2002 This step-by-step article explains how to save your Microsoft Excel workbook as one of the following types of Web pages: Save Workbook as Web Page To save your workbook as an interactive Office Web Component, follow these steps. NOTE: To save... KB#289260. Keywords: Download, PivotTables, Object, File Name, HTML, Web

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

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

 
82. Excel Quits Unexpectedly with an Error Message When You Close an Excel Workbook That Contains DDE Links When you close a Microsoft Excel workbook that contains DDE links, you may receive the following error message: Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of... KB#827270. Keywords: DDE, Third-Party, Errors, Error Message, Links, Web

 
83. How to Post to the New Board 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 a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Sorting, Years, VBA, Hyperlinks, Web

 
84. How to Determine Which DLLs Are Registered In Microsoft Excel you can programmatically list the dynamic link library (DLL and XLL) files that provide functions registered in Excel. This article describes a sample macro that creates a three-column array of all registered functions in... KB#213498. Keywords: DLL, Arrays, VBA, Macro, Files, Links, Web

 
85. Excel - Hyperlink navigation and macro buttons If you regularly use a large spreadsheet and repeatedly need to move between particular sections, it is worth adding some simple links to automate moving from one area to another. The link can be placed anywhere convenient on a worksheet and when clicked, it takes you directly to another location.... Keywords: SERIES, Graphic, Fonts, Format, Links, Page Setup, Printing, Macro, Object, Toolbar, Hyperlinks

 
86. How to open a Document Linked to PasswordProtected Sheet in Excel 2000 This step-by-step article describes how to open a document that is linked to password-protected sheet in Microsoft Excel 2000. If you open a Excel worksheet that is linked to protected worksheets, you are prompted whether to update links to... KB#214314. Keywords: Links, Password, VBA, Macro, Web

 
87. How to link to a Particular Worksheet from a Web Page in Excel 2000 This step-by-step article explains how to create a link from a Web page to a particular worksheet, range, or defined name in a Microsoft Excel 2000 workbook. Normally, when you create a link from a Web page to a Microsoft Excel workbook, the path... KB#211693. Keywords: Defined Name, Links, Web

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

 
89. Links to Frequently Asked Questions Keywords: Errors, Links, Class, VBA, AutoSave, Hyperlinks, Web, Comments

 
90. Updating old information The professor walked up to the board, wrote the familiar equation that was the basis for Newtonian physics, "F=ma". This stands for Force = Mass x Acceleration. Then, he dropped a bomb shell. "Everything that we have taught you over the last 3 semesters is wrong. F does not equal ma." He went on to... Keywords: Years, VBA, Web

 
91. Cannot Use Pound Character in File Name for a Hyperlink When you create a hyperlink to another file, the file name that appears in the hyperlink text may appear to be different than the actual file name. For example, a hyperlink to a file with the following file name: C:\My Documents\Book#One.xls... KB#202261. Keywords: Errors, File Name, Hyperlinks, Web

 
92. How to Open a Document Linked to PasswordProtected Sheet When you open a Microsoft Excel worksheet that is linked to protected worksheets, a dialog box will appear asking whether to update links to unopened worksheets. If you click Yes, another dialog box will appear asking for the passwords of the... KB#63091. Keywords: Links, Password, VBA, Web

 
93. Some Text Box Hyperlinks Do Not Work After You Save a Workbook As a Web Page When you save an Excel workbook as a Web Page, text boxes that contain a hyperlink may not work when you view the Web page in your Web... KB#826091. Keywords: Text Box, Registry, Hyperlinks, Web

 
94. How to Link to a Particular Worksheet from a Web Page This article explains how to create a link from a Web page to a particular worksheet, range, or defined name in a Microsoft Excel... KB#172503. Keywords: Defined Name, Links, Web

 
95. An Additional "Object" Workbook Opens and Excel Appears to Stop Responding When you double-click a Microsoft Excel workbook, a blank workbook that is named Object may open with the workbook that you double-clicked. If you quit Excel, and then double-click a workbook, Excel appears to stop responding (hang). The... KB#811344. Keywords: Download, Toolbar, Internet Explorer, Web, Window

 
96. Office 2003 documents take longer than expected to open in Internet Explorer Fixes the problem that occurs when Office documents, Word documents, Excel workbooks, or PowerPoint presentations, take longer than expected to open in the Internet Explorer browser... KB#837255. Keywords: Registry, HTML, Internet Explorer, Window

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

 
98. How to Automate Excel from an HTML Web Page Using JScript This article demonstrates how to create and manipulate a Microsoft Excel workbook from an HTML... KB#234774. Keywords: Format, Arrays, VBA, File Name, HTML, Internet Explorer, Web

 
99. Return to Previously Selected Sheet nxtsheets(nxtsheets(0)) =... Keywords: Links, VBA, Toolbar, Hyperlinks, Web, Comments

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

 

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