Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 17th 04, 01:12 AM
akrr-rasmussen
 
Posts: n/a
Default Why do my links break when I burn multiple Excel files to a CD?

We have a master Excel file containing ~330 links to other Excel or Word
files. The Excel files it links to all contain at least 2 additional links
to other Word files. We need to supply this data to other users via CD. To
do so, we burn a CD using the top level folder as our starting point. All the
linked files are contained in the other sub-folders. Unfortunately, when the
CD is created multiple links are broken. These breaks are not consistent,
but seem to happen randomly from burn to burn.

  #2   Report Post  
Old November 17th 04, 03:39 AM
akrr-rasmussen
 
Posts: n/a
Default

We figured out our own issue. An example of our current file structure is as
follows:
Folder B\Folder C\Folder C1\example 1.xls
Folder B\Folder C\Folder C1\example 1.xls
T:\Folder A\Folder B\Folder D\etc.
Folder B\Folder D1\example 2.xls
Folder B\Folder E\etc.
This structure shows file 'example 1.xls', which contains links to 'example
2.xls'. When we burned the CD, we only burned from the level of folder B.
Unfortunately, the link embedded in example 1 had the following structu
T:\Folder A\Folder B\Folder D1\example 2.xls. Since we didn't burn one level
up at Folder A, everytime we created another CD the link broke when it looked
for Folder A and couldn't find it.

An early solution we looked at was copying all of Folder A to a PC hard
drive (which we'd then use to burn the CE), but the drive had too much data
to fit. To solve for this, we created C:\Folder A on the hard drive, then
copied Folder B into it. This was sufficient to maintain the file structure
and fix all the broken linkages.

"akrr-rasmussen" wrote:

We have a master Excel file containing ~330 links to other Excel or Word
files. The Excel files it links to all contain at least 2 additional links
to other Word files. We need to supply this data to other users via CD. To
do so, we burn a CD using the top level folder as our starting point. All the
linked files are contained in the other sub-folders. Unfortunately, when the
CD is created multiple links are broken. These breaks are not consistent,
but seem to happen randomly from burn to burn.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 2nd 05 12:31 AM
How to break links Excel 97 jwiley Excel Discussion (Misc queries) 2 December 20th 04 03:49 PM
How do I Break links Using Excel 2000 DaddyMan Excel Discussion (Misc queries) 1 December 9th 04 11:18 PM
Combine multiple Excel files into one master [email protected] Excel Discussion (Misc queries) 1 November 27th 04 12:20 AM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017