If you add a new column that contains a formula to the list, and the list is linked to a SharePoint site, the formula will be converted to a calculated value.
You can retain formulas by publishing the list without linking it to Microsoft Windows SharePoint Services.
The formula is read-only and cannot be updated in a list that is linked to a SharePoint site.
You will see a formula in a list in Microsoft Excel only if the SharePoint list had been exported to Excel and contains a column that has been specified as a calculated column in a SharePoint list. This column is read-only and cannot be modified.
I can't create a list in a shared workbook.
You cannot create lists in workbooks that are shared. Additionally, the Share Workbook command is disabled if your workbook contains any lists. You must first disable workbook sharing if you want to use lists in your worksheet.
I can't create a list in a protected worksheet.
You cannot create lists in a workbook or a worksheet that is protected. You must first unprotect the worksheet or workbook before creating lists.
I can't create a list when worksheets are grouped.
If you have multiple worksheets selected, you cannot create a list because the worksheets have been grouped. To create a list, you must have only one worksheet selected.
When I type in a row directly under a list, the list does not automatically expand.
I can't publish a list because I have too many columns in the list.
| Data type | Number of columns |
|---|---|
| Short text | 64 |
| Multi-line text | 32 |
| Number | 32 |
| Currency | 32 |
| Date/Time | 16 |
| Hyperlink | 64 |
When you copy a cell by dragging or by clicking Cut
or Copy
, and Paste
, Microsoft Excel copies the entire cell, including formulas and their resulting values, comments, and cell formats.
For example, if you copy a number from a cell in a column that has been specified as a column of text and paste it into a cell in a column that requires a number, you will get a data validation error. If you then try to type a number into that cell to resolve the error, you will again get a data validation error. This validation error occurs because the format for the cell changed to text when you copied data to the cell from another cell that has text format. In text format cells, numbers are treated as text.
To resolve this error, change the format of the cell back to a format that is suitable for the data type. For example, to correct the problem described above, do the following:
- Select the cell you want to modify and click Cells on the Format menu.
- On the Number tab of the Format Cells dialog box, select the General format.
- Click OK to apply the format.
I get an unexpected error when I try to publish a list.
When you publish a list, unexpected errors may occur for a number of reasons.
- You may not be able to access the Microsoft Windows SharePoint Web site. The URL specified for the SharePoint site may be incorrect or an administrator may have configured the SharePoint site to deny access.
- The name of the list may be too long. Give the list a shorter name before trying to publish it again.
- You may have cancelled the publish operation while data was being transferred to the SharePoint site.
- There may be a version conflict between Microsoft Excel and the SharePoint site.
- There may have been a schema conflict between the list in Excel and the list on the SharePoint site.