Questions

Insert hyperlink in an excel sheet

+
0 Votes
Locked

Insert hyperlink in an excel sheet

bemostafa
i created an excel sheet and inserted hyperlinks in some cells. All was fine but suddenly i am unable to insert anymore hyperlinks to the the sheet. what went wrong and how to fix this?
  • +
    0 Votes
    gechurch

    Try isolating the problem:
    * Can you insert links in other Excel documents on that machine still?
    * If you copy and paste the Excel spreadsheet into a new one can you insert hyperlinks?
    * Is the file saved as .xls or .xlsx (not .csv etc)?
    * Is the spreadsheet locked down at all (locked cells etc)?
    * Does Ctrl + K (the shortcut to addd hyperlink) work?

    If it doesn't work in other sheets try a repair install of Office, or a full uninstall/reinstall. If it does work in new sheets figure out if it is a problem with the format, or locked cells etc. If it's not, I'd give up on figuring it out and just copy and paste into a new spreadsheet and go from there.

    +
    0 Votes
    bemostafa

    Thank u for ur answer.
    hyperlinks can be included in a new sheet in the same file but not in the ones with data already.
    other new sheets work well
    there seems to be no locked cells
    copying and pasting in a new file did solve the problem
    thanx

  • +
    0 Votes
    gechurch

    Try isolating the problem:
    * Can you insert links in other Excel documents on that machine still?
    * If you copy and paste the Excel spreadsheet into a new one can you insert hyperlinks?
    * Is the file saved as .xls or .xlsx (not .csv etc)?
    * Is the spreadsheet locked down at all (locked cells etc)?
    * Does Ctrl + K (the shortcut to addd hyperlink) work?

    If it doesn't work in other sheets try a repair install of Office, or a full uninstall/reinstall. If it does work in new sheets figure out if it is a problem with the format, or locked cells etc. If it's not, I'd give up on figuring it out and just copy and paste into a new spreadsheet and go from there.

    +
    0 Votes
    bemostafa

    Thank u for ur answer.
    hyperlinks can be included in a new sheet in the same file but not in the ones with data already.
    other new sheets work well
    there seems to be no locked cells
    copying and pasting in a new file did solve the problem
    thanx