key <Enter> in cell - catastrophe RRS feed

  • Question

  • I have inherited an XLS spreadsheet written in Excel 2007

    After adding code and creating an XLSM we found that when you add data into 1 range of cells and Press Enter, Excel either turns to a new worksheet but usually turns to a new ws while showing bits of the old and new worksheets, fragmented (if a user presses Tab, everything works as it should)

    There is no code/functions/references under these cells.

    This is catastrophic - anybody have any ideas ??

    Greg Nelson

    Sunday, December 21, 2014 1:55 PM


  • Hi Greg Nelson,

    I suggest that you try to open the Workbook in the Office safe mode to see wehter the issue was caused by the add-in or macros.

    If the issue couldn't be reproduced in Office safe mode, you can try to disable all add-ins and macros then enable them one by one to see which one caused this issue.

    If yes, I suggest that you update and repair the Office to see whether the issue was fixed.

    You can get more detail about Office safe mode from link below:
    Work with Office safe modes

    Regards & Fei

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, December 22, 2014 8:08 AM