XL5: Last Cell Incorrect in Imported .DIF Files

ID: Q116186

5.00 WINDOWS

The information in this article applies to:

Microsoft Excel for Windows, version 5.0

SYMPTOMS

When you import .DIF (document interchange format) files to Microsoft Excel version 5.0, the last cell address will be incorrect.

MORE INFORMATION

In Microsoft Excel version 5.0, you can select the last cell of the active area of a spreadsheet by doing either of the following:

Press CTRL-END on the keyboard.
-or-
Choose Go To from the Edit Menu, choose the Special button, then choose Last Cell from the list of options, and then choose OK.

However, when a .DIF file is opened in Microsoft Excel version 5.0, you cannot use these methods to get to the last cell in your document. For example, if a .DIF file that is 3 rows by 3 columns is opened in Microsoft Excel version 5.0, the last cell should be C3. However, if you press CTRL+END, cell D3 is selected (that is, the last cell is one cell to the right of the actual last cell).

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows version 5.0c.

For more information on resetting the last cell, query on the following words in the Microsoft Knowledge Base:

   resetting and last and cell

KBCategory: kbprb KBSubcategory:

Additional reference words: 5.00

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996