Archive for November, 2007
Error message when you open a file in Excel or in Word: “The document caused a serious error the last time it was opened”
Posted in MS Office Excel | No Comments »
SYMPTOMS loadTOCNode(1, \'symptoms\'); When you try to open a file that Microsoft Excel or Microsoft Word could not open previously, you receive the following error message: The document 'Filename' caused a ... Read more..How to create a conditional format to hide errors in Excel
Posted in MS Office Excel | No Comments »
In Microsoft Excel, you can create conditional formatting on a cell or on a range of cells so that error values are not displayed in the cell(s). MORE INFORMATION loadTOCNode(1, \'moreinformation\'); ... Read more..Error message when you open or save a file in Microsoft Excel: “Filename is not valid”
Posted in MS Office Excel | No Comments »
ERROR MESSAGE loadTOCNode(1, \'errormessage\'); When you open or save a file in Microsoft Excel, you may receive one of the following error messages: Error message 1 Filename is not valid. Error message 2 The ... Read more..How to remove smart tags from a workbook in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This article explains how to remove smart tags from a workbook in Microsoft Excel. MORE INFORMATION loadTOCNode(1, \'moreinformation\'); To remove a single smart tag in a cell, follow ... Read more..Description of the smart tag functionality in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This article describes the functionality of the smart tags feature in Microsoft Excel. MORE INFORMATION loadTOCNode(1, \'moreinformation\'); Smart tags are designed to recognize specific data and then offer ... Read more..How to use the Paste Options button in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This step-by-step article describes the functionality of the Paste Options button in Microsoft Excel. The Paste Options button becomes available when you paste data into cells in Excel. ... Read more..How to Find and Replace tildes and wildcard characters in Excel for Mac
Posted in MS Office Excel, OS X Applications | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); Microsoft Excel for Mac uses the tilde (~) as a marker to indicate that the next character is a literal. When you click Find or Replace on ... Read more..How to find and replace tildes and wildcard characters in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the Find and Replace dialog box ... Read more..How to calculate the number of months between two dates in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This step-by-step article shows you how to calculate the number of months between any two dates. To calculate the number of months between any two dates, use one ... Read more..How to reset the last cell in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); Microsoft Excel saves only the part of each worksheet that is in use, meaning the section that contains data or formatting. Sometimes the last cell of a ... Read more..How to use startup folders in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \\'summary\\'); This step-by-step article describes how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways: To load Excel workbooks at startup. As a reference location ... Read more..How to use the INDEX function to find data in a table in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This article describes how to use the INDEX function to find data in a table at the intersection of a specific row and column in Microsoft Excel. There ... Read more..How to use the LOOKUP function in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This article describes how to use the LOOKUP function in a Microsoft Excel worksheet. MORE INFORMATION loadTOCNode(1, \'moreinformation\'); The LOOKUP function returns a value either from a one-row ... Read more..How to use the OFFSET function in Excel
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \'summary\'); This article describes how to use the OFFSET function to return the value of a cell that is a specified number of rows and columns away from ... Read more..How to find data in an Excel table
Posted in MS Office Excel | No Comments »
SUMMARY loadTOCNode(1, \\'summary\\'); This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different ... Read more..How to view Word 2007 and Excel 2007 files by using Word Viewer 2003 and Excel Viewer 2003
Posted in MS Office Excel, MS Office Word | No Comments »
INTRODUCTION loadTOCNode(1, \'summary\'); Microsoft Office Word Viewer 2003 and Microsoft Office Excel Viewer 2003 cannot natively open documents that are saved in the Office Open XML Formats. However, you can ... Read more..How to create legacy Office files in the 2007 Office system
Posted in MS Office Access, MS Office Excel, MS Office Powerpoint, MS Office Word | No Comments »
INTRODUCTION loadTOCNode(1, \\\'summary\\\'); When you use Windows Explorer or the desktop to create a new 2007 Microsoft Office file, a new Office file is created in an XML file format ... Read more..Refresh / redirect your site using PHP code
Posted in Programing and Coding | No Comments »
The PHP's header() function You can re-direct or refresh your web pages by simply doing either of the following in your PHP scripts or codes: Method I: using header('location...') Php code: <?php // refresh ... Read more..Parsing PHP code in .html or .htm files
Posted in Programing and Coding | No Comments »
You want to parse php code in html/htm files ? Easier done than said. You need access to the www root of your domain (place where you put your domain ... Read more..You cannot export portrait and landscape images to the same width in Picture Manager
Posted in General, MS Office Excel | No Comments »
SYMPTOMS loadTOCNode(1, \\\'symptoms\\\'); In Microsoft Office Picture Manager, when you export two images of different orientations (one is landscape, the other is portrait), the longest side of each image is ... Read more..