Broken links in Excel 2003

K

Ken

When distributing Excel 2003 documents via email, links are broken and
recipients cannot view data. Even if the spreadsheet is set to Calculation of
Manual and Recalculate before save is not checked some users still get broken
links. It appears that the problem is that if users have an Excel document
open with calculation method set to automatic that any spreadsheet that is
opened after this gets this automatic setting, which looks for the source and
then breaks the links. I have also tried the Edit/Link option to ask the user
whether to update or don't update. Again, if a user has an existing
spreadsheet open that is set to calculate automatically then even if the user
selects don't update, the automatic calculation method kicks off and gives
#NAME errors. Short of doing a copy/paste/values in a second spreadsheet, is
there any way to distribute an Excel spreadsheet and have it not look for the
source for remote links that are unavailable?
 
G

Gail

If the recipient does not click update data, then he/she should be able to
read the document. Are you distributing just for viewing or for actual
use? If you are just viewing, have you thought about distributing as PDF
file rather than an excel spreadsheet. Else you will need to distribute the
originating data files with the file
 
Top