Software

Ask something
Question Locked

Insert hyperlink in an excel sheet

0 helpful
3 replies

by badrmostafa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by 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.

by badrmostafa

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

This discussion is closed to new replies.