Hi there,
I use an Excel spreadsheet to list Recipes. When I click on one of the recipe names in the spreadsheet a Hyperlink opens MS Word and displays the actual recipe.
The Spreadsheet is contained in a directory called "COOKBOOK" off the C drive root directory. That directory also contains a folder called Recipes which is full of the actual MS Word recipes.
e.g. C:\COOKBOOK\RECIPES
This all worked fine for years until my computer crashed recently whilst I was using my "Recipe Book". When I opened the spreadsheet again Excel had "auto-saved" my work. I saved it as my original Recipe Book however, when I opened it again, none of the hyperlinks worked. I found the reason was that the hyperlink destination was changed to some other directory which did not contain the folder called "Recipes".
e.g. C:\Documents and Settings\xxxxxxx xxxx\Application Data\Microsoft\Excel
As a temporary measure I copied my Recipes folder and pasted it in the new location specified by the corrupted hyperlinks.
e.g. C:\Documents and Settings\xxxxxxx xxxx\Application Data\Microsoft\Excel\Recipes
This of course works however, I would like to restore everything back to its original location and destination.
I have hundreds of recipes in my Recipes folder and therefore there are also hundreds of hyperlinks in my "Cookbook" spreadsheet.
It would be very time consuming to redo each hyperlink individually. I feel that since Excel changed my hyperlinks of its own accord there must be an easy way of restoring them back to their original location/destination. Is this at all possible? or, do I have to start changing them back one at a time?
If anyone can help me and give me step by step instructions on how to do this I would be very grateful and I thank you.
Bookmarks