Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing broken hyperlinks and vlookups
We are planning a re-configuration of our primary Drive and will be moving
most of our folders and subfolders. We commonly use hyperlinks between workbooks. We are an Excel dependent department nad have thousands of files within our primary folders and subfolders. During testing, I find that when the source workbook is moved, the hyperlink to that workbook no longer works and I get: "Cannot open specified file." I need to move the folders and subfolders soon and need to know how to prevent this error from occurring when the users try to use the hyperlinks. Also, vlookups - I know my vlookups to sheets within a workbook will be fine. Will the vllokups to other workbooks break also? THANK YOU IN ADVANCE!! jane |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing broken hyperlinks and vlookups
Hmm...this is a tough one. Explain what you mean by "re-configuration". Are
you upgrading hardware/putting in a new drive? Or are you renaming all your folders and reorganizing everything? If you're doing the latter, I'm not sure much can be done short of changing each hyperlink manually (or at best, doing a search/replace within each affected Excel file, if you can even do it with hyperlinks...I've never tried that before). -- -Kaman The IT dept people call before they call the real IT dept. "jane" wrote: We are planning a re-configuration of our primary Drive and will be moving most of our folders and subfolders. We commonly use hyperlinks between workbooks. We are an Excel dependent department nad have thousands of files within our primary folders and subfolders. During testing, I find that when the source workbook is moved, the hyperlink to that workbook no longer works and I get: "Cannot open specified file." I need to move the folders and subfolders soon and need to know how to prevent this error from occurring when the users try to use the hyperlinks. Also, vlookups - I know my vlookups to sheets within a workbook will be fine. Will the vllokups to other workbooks break also? THANK YOU IN ADVANCE!! jane |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing broken hyperlinks and vlookups
yes, we are re-orangizing the folders into a more logical order so many
folders are moving with the files that are contained within. I am thinking the same as you so far as there not being much you can do. In this day adn age, you would think that would be possible. I will explore the search/ replace possibility. thanks!! jane "Kaman" wrote: Hmm...this is a tough one. Explain what you mean by "re-configuration". Are you upgrading hardware/putting in a new drive? Or are you renaming all your folders and reorganizing everything? If you're doing the latter, I'm not sure much can be done short of changing each hyperlink manually (or at best, doing a search/replace within each affected Excel file, if you can even do it with hyperlinks...I've never tried that before). -- -Kaman The IT dept people call before they call the real IT dept. "jane" wrote: We are planning a re-configuration of our primary Drive and will be moving most of our folders and subfolders. We commonly use hyperlinks between workbooks. We are an Excel dependent department nad have thousands of files within our primary folders and subfolders. During testing, I find that when the source workbook is moved, the hyperlink to that workbook no longer works and I get: "Cannot open specified file." I need to move the folders and subfolders soon and need to know how to prevent this error from occurring when the users try to use the hyperlinks. Also, vlookups - I know my vlookups to sheets within a workbook will be fine. Will the vllokups to other workbooks break also? THANK YOU IN ADVANCE!! jane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Hyperlinks Broken After Windows Update 11/25 | Excel Discussion (Misc queries) | |||
Excel 2007 Crashed - All Hyperlinks broken | Excel Discussion (Misc queries) | |||
Hyperlinks broken | Excel Discussion (Misc queries) | |||
vlookups and hyperlinks | Excel Discussion (Misc queries) | |||
Fixing broken hyperlinks in Excel workbook | Excel Discussion (Misc queries) |