Insert Hyperlink question

[BostonMike]

I right click on a cell to insert hyperlink. It opens a parent folder we will call folder A. There is a folder B inside folder A. When I right click and insert hyperlink I would like Excel to open up folder B to get at my file so that I don't have to open A first. How do I do this? I am using 2007.

[Palmetto]

Drill down to the applicable folder when creating the hyperlink and Excel will open it to the right place.
Delete the old link and create a new one per the above.

[BostonMike]

Palmetto, when I create the links they work fine but when I go to create a new one Excel does not open the B folder it opens A again and I have to drill down to B and I don't want to have to do that.