I do OK with Excel 2007 but seem to have run in to an issue. I have a large sheet that is a library to all my movies on my media system. I won't go in to details but had cause to do a clean install on that system.
The issue: The Excel sheet looks for an external drive E: as the drive for all the hyperlinks but that drive now shows as F:; of course none of the hyperlinks now work.
Yes, I know that I could just change the drive letter for this external drive back to E: which is what I did when I first set up my media system. The problem was that after changing the drive letter some software would not install such as the Game Fable, XP Mode and some others. The most common error was that there was an invalid drive. Actually I'm still having an issue with XP Mode but, since I have the other installs done, don't really need it. This is a clean install so I can't see an infection being involved. I even have a hunch that I MIGHT be able to get XP Mode to install if I were to right click on the Virtual PC and XP Mode installers and select to run as admin... might just try that to see....
I see two solutions... Ok, three.
- Of course I could go through the sheet and edit all hyperlinks to point to the proper drive. With almost 400 listings I'd rather not go this route.
- Figure out a way to globally change E: to F: throughout the sheet. This is what I'd prefer to do but find and replace will not find the E: references. Quite possible that I'm doing the find and replace wrong for this aspect.
- Finish getting the 'problem' software packages installed and then do a system image and then change the drive letter of the external drive from F: back to E:. This worries me a bit even though it may be the easiest solution. Although, if it does break the 'problem' installs I would have the image to go back.
Any ideas as to how to best go about this?