Works: Fill Series Autofill Does Not Increment Beyond 32767
Article ID: 150450
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Works 6.0
- Microsoft Works 2000 Standard Edition
- Microsoft Works 4.5 Standard Edition
- Microsoft Works 4.0 Standard Edition
This article was previously published under Q150450
SYMPTOMS
In a Microsoft Works spreadsheet, if you use the Autofill option of Fill
Series on the Edit menu with an entry that begins with a letter and ends
with a number (such as J133, J134, J135), Works will not Autofill beyond
the number 32767.
If you try to use Autofill to fill a series beyond 32767, you will either
receive an ERR in the cell, or it is treated as a plain fill rather than a
series fill. This only occurs if the cell entry begins with text and ends
with a number.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
To work around this issue, do not use an entry composed of mixed text and numbers.
For example, if the series mentioned in the Summary is in Row 1 on the Spreadsheet, enter a J in cell A1 and Fill Down, then Autofill the series 133, 134, 135.
Additional query words: 4.00 4.00a 4.50 4.50a w_works works2000 works6 wks
Keywords: kbprb KB150450