The cells might be locked and protected. See the designer of the Web page for more information.

Wrapped text within cells is not supported in the Microsoft Office Spreadsheet Component. To correctly display the text, you can shorten the text or use multiple cells for the text, or you can widen the column so that all of the text shows.

Unlike Microsoft Excel, the Microsoft Office Spreadsheet Component does not provide a formula bar to edit cell contents. However, you can edit the contents of a cell by double-clicking the cell or by selecting the cell and pressing F2.

If you are modifying a hyperlink that was published from a Microsoft Excel worksheet and was originally created by using the Insert Hyperlink dialog box in Excel, you can change the text that's displayed for the hyperlink, but you cannot change the address that the hyperlink goes to. To change the address, delete the hyperlink and then insert a new hyperlink.

Your spreadsheet might be set to size automatically. See the designer of the Web page for more information.

Your spreadsheet may have been set to size automatically by the designer of the Web page. If so, scroll bars appear when the spreadsheet reaches the maximum height or width set, regardless of whether you set scroll bars to be displayed or hidden. See the designer of the Web page for more information.

If sorting a spreadsheet does not produce the results you expect, check the following:

Check your selection before sorting   When you select a range of cells to sort, the spreadsheet sorts everything within that range, and it sorts only that range. This means that if your header row is within the selection, the header row will be sorted. It also means that if you select one column of data within a list that must be sorted, only that column will be sorted and not the entire list. Try to select a single cell within the range you want to sort, but not within a header row. The spreadsheet will automatically detect the data to sort and will exclude the header row. If this does not work properly for your data, try to select the entire range you want to sort, without selecting the header row.

Check that numbers are in a numeric format   If a value is sorted out of order, the cell might be formatted as text and not as a number. For example, negative numbers from some accounting systems become text when the data is imported into a spreadsheet. To apply the correct formatting, click the cell, and then change the format of the number.

Check that dates and times are formatted correctly   Dates and times are treated as numbers. When you type a date or time into a cell, the cell's format changes from the General number format to a built-in date or time format. For dates and times to sort correctly, all dates and times in a column must have the same date or time format. To apply the correct formatting, click the cell, and then change the format of the number.

Remove any leading spaces   Make sure that no leading spaces have been inserted before data. Remove the leading spaces before sorting the data.

Check the locale setting   Sort orders vary by locale setting. Make sure that you have the proper locale setting in the Regional Settings or Regional Options in Control Panel. For information about changing the locale setting, see Windows Help.

Make sure you sort multiple columns in the correct order   When you sort on more than one column, the order in which you sort determines how the data will be organized. Sort lower-level (inner) categories first, and then sort higher-level (outer) categories.

The list might be filtered using the AutoFilter command to display specific rows. If an arrow appears to the right of the top cell in each column, do one of the following:

• Click the arrow, and then click Show All.
• Make sure the AutoFilter button on the toolbar is not selected.

The Microsoft Office Spreadsheet Component does not support the ability to filter lists that contain merged cells. If your spreadsheet contains merged cells, unmerge the cells and then try to use the AutoFilter command again.

If you have selected a range of data, the Find Next command searches only in that selection for the value you specify. To find data anywhere in the spreadsheet, select a single cell before clicking Find Next.

In Microsoft Excel, you can create AutoFilter criteria that cannot be shown in the spreadsheet AutoFilter drop-down list. For example, there is no equivalent for "Top 10..." or "begins with" criteria in the spreadsheet.

When you publish an AutoFilter range in Excel that uses criteria that cannot be shown in the spreadsheet AutoFilter list, the filtered items are displayed correctly on the Web page, but the AutoFilter list does not reflect the chosen criteria.

You can reset the drop-down list by clicking AutoFilter on the spreadsheet toolbar to turn the filter off, and then click AutoFilter again to turn the filter on. This will also reset the displayed list.

From Microsoft Excel, you can publish a protected worksheet only by using a blank password. Open the original workbook in Excel, remove the password, and try to publish the worksheet again.

In a spreadsheet, you can create AutoFilter criteria that can't be shown in the AutoFilter drop-down list or the Custom AutoFilter dialog box in Microsoft Excel. For example, there is no direct equivalent in Excel for a spreadsheet filter that has three unselected items. When you export the spreadsheet to Excel and the spreadsheet contains filtering criteria that Excel does not support, the entire AutoFilter range is shown in Excel.

To export your filtered data and have it display as it does in the spreadsheet, it is recommended that you not have more than two criteria set for each filter; that is, you must not have more than two check boxes with a different setting (selected or cleared) from any of the other check boxes.

Spreadsheets can contain data in columns A through ZZZ and rows 1 through 262,144. Microsoft Excel worksheets, on the other hand, can contain data only in columns A through IV and rows 1 through 65,536. To export your spreadsheet to Excel, you must delete or move data from columns beyond IV and rows beyond 65,536. If you want, you can copy the additional data to another Excel worksheet.

If you can view but not interact with your spreadsheet, you might not have access to a Microsoft Office XP license. See your network administrator for more information.

The source data Web page is unavailable   If some of the data in the spreadsheet comes from another Web page, check to see if the Web page is available and that you have proper access to the Web page.

The Web page is not local   If the spreadsheet contains a formula that links to data on another Web page, check whether you have proper access to the Web page and that the Web page resides on your local computer or intranet. See your network administrator for more information.

Programs that are available from the Edit button in your Web browser depend on how the page was published.

If clicking the Edit button in your Web browser opens a program that you do not want to use, quit the program, start the program you want to use, and open the Web page in that program.

When part of a formula cannot be calculated, or if there is a problem with the formula, the formula returns an error value, such as #NAME? or #DIV/0! To determine the cause, read about troubleshooting error values.