Hi, I am working in Excel 2007 and have created hyperlinks in a database to make navigation easier for the spreadsheet user.

What I am finding is that the tables I have hyperlinked to are not showing up in the centre of the screen when I click on the link. Sometime they come up in the top left hand corner, sometime along the bottom etc. I am wondering if there is a way to get the linked table opening in the centre of the screen?

There are a number of linked tables on the worksheet and attempts at manoeuvring them around have proven fruitless. Any help is greatly appreciated. I have a presentation coming up soon and this is quite critical to it running smoothly!

Cheers, Alex