Worksheet switching

  • One of the end-users working on my spreadsheet has been complaining that sometimes she types into a cell and then all of a sudden Excel switches to another worksheet within the workbook. Is there a shortcut she is hitting on accident or might the explanation be more complicated?

    btw I do like the new look of the forum

  • Sounds like there is a hyperlink in the cell (perhaps "invisible"). Right-click on the cell and if there is a hyperlink, then you will see two more menu options in the pop-up, "Delete Hyperlink" or "Edit Hyperlink"

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    (retired Excel 2003 user, 3.28.2008)

  • Following code can help you to get a complete list of all the links on a particular sheets shown on a new sheet
    You can then go through the list and determine if there is any unwanted link.

    Thanks: ~Yogendra

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!