Insert hyperlink in an excel sheet

By 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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Do some more research on the problem

by gechurch In reply to Insert hyperlink in an ex ...

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.

Collapse -

Reponse To Answer

by bemostafa In reply to Do some more research on ...

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

Related Discussions

Related Forums