XL5: Last Cell Incorrect in Imported .DIF Files

 Last reviewed: September 12, 1996
Article ID: Q116186
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



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.