Hyperlinks in an Excel doc stored on Sharepoint

Hi, I'm using Excel 2007 and have some hyperlinks to other sheets of the workbook in my file.  However, they keep breaking depending on whether the workbook is checked out of Sharepoint or not - because if the document IS checked out, then its file path is to my local folder, but if its NOT checked out, the file path is the website.  So if you create them using one, then they break when you open it the other way.

 

I've tried creating the links via the right click > insert hyperlink function, and also using the hyperlink formula wizard.

 

Any ideas?  Is there another way to take me to another sheet of the workbook without using a hyperlink? (or without a macro - our company has very tight security settings and macro enabled workbooks are a right pain for people to open...)

 

Thanks for any advice!

Comments
There are 5 comments. Login or register to view them.

I have tried to replicate

chetan |

Thanks for the reply

cornwallsharon |

In your excel options check

chetan |

Chetan,  thanks so much for

cornwallsharon |

Solved...sort of

chetan |