Question Locked

Excel 2007 - Maintain Hyperlinks when inserting new data

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a single workbook, one sheet has graphics which have Hyperlinks to cells in other sheets.

My problem is the data in the other sheets may increase or decrease and hence the cell reference for the Hyperlink would have changed so the Hyperlink then links to the wrong place.

I am sure there must be an easy way to maintain that relationship ?

4 replies

by thumbsup2

Hyperlinks pointing to a cell in a spreadsheet are always a cell reference. If the contents of the cell is being moved to another cell by inserting lines/columns, then using Hyperlinks is not the correct procedure for you to be using.

You could try using Table of Contents (TOC) instead. And, if that doesn't work, you should re-think how you've got things set up in that other sheet and why you find the need to insert/delete lines/columns which moves the data around.

by 45geek

I agree hyperlinks in excel are a static setting and it seems like you want a dynamic link to changing data. It sounds like a data base would be a better solution so that everytime you connect to the database through the link in excell you would draw data from a database which can be dynamic by nature. Then the static hyperlink of the cell would always connect to the database to draw its data from and change accordingly.

Good Luck!!

by brianridley

Thx folks, longer term this will end up in a database but that will be a year off or so. I wont have too many links so will manage it for now and will have a look at the TOC option as well.

This discussion is closed to new replies.