software

Hello Everyone,

I have a user who is running Excel 2003. He has a sheet that is nothing but
hyper links and notes about what those links are. When a doc is linked and
the document saved the link is no longer working. Here is what the link
looks like before and after save.

P:\P05502\05201-0000\ENGINEERING\ACEP_5201_Final.pdf

.../../M2M/m2mdata01/PROJECTS/P05502/05201-0000/ENGINEERING/ACEP_5201_Final.pdf

P:\ is a mapped drive but navigating through the network for the link
casuses the same problem. Anyone have any idea why this is not working?

LWhite
Hi,

does the user running Excel 2003 have the same network disk under P:?Lets assume that P: points to \\server\share
Try to change links before you hand the workbook to the user this way:

instead of
P:\P05502\05201-0000\ENGINEERING\ACEP_5201_Final.pdf

use
\\server\share\P05502\05201-0000\ENGINEERING\ACEP_5201_Final.pdf

Maybe it will help.

IvanWe are havivg the same problem, however when the spreadsheet is saved to a
local drive it works fine. In other words, when the spreadsheet is opened
from a mapped drive the links read .../.../server/folder/document. When the
spreadsheet is openned from a local drive the links read
file///\\server\folder\document. Any ideas folks?nquot;iL.Whitequot; wrote:

gt; Hello Everyone,
gt;
gt; I have a user who is running Excel 2003. He has a sheet that is nothing but
gt; hyper links and notes about what those links are. When a doc is linked and
gt; the document saved the link is no longer working. Here is what the link
gt; looks like before and after save.
gt;
gt; P:\P05502\05201-0000\ENGINEERING\ACEP_5201_Final.pdf
gt;
gt; .../../M2M/m2mdata01/PROJECTS/P05502/05201-0000/ENGINEERING/ACEP_5201_Final.pdf
gt;
gt; P:\ is a mapped drive but navigating through the network for the link
gt; casuses the same problem. Anyone have any idea why this is not working?
gt;
gt; LWhite
gt;
gt;
gt;

Hi John,
see
You receive a quot;The file may have been changedquot; error message when you save
a workbook to a network server in Excel 2002 or in Excel 2003
support.microsoft.com/default.aspx?kbid=324491

For additional items of interest do a Google Groups search at
groups.google.com/ place the following in the search box
author:harlan author:grove network drive group:*.public.excel*
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;John Hullquot; gt; wrote in message ...
gt; We are havivg the same problem, however when the spreadsheet is saved to a
gt; local drive it works fine. In other words, when the spreadsheet is opened
gt; from a mapped drive the links read .../.../server/folder/document. When the
gt; spreadsheet is openned from a local drive the links read
gt; file///\\server\folder\document. Any ideas folks?
gt;
gt;
gt; nquot;iL.Whitequot; wrote:
gt;
gt; gt; Hello Everyone,
gt; gt;
gt; gt; I have a user who is running Excel 2003. He has a sheet that is nothing but
gt; gt; hyper links and notes about what those links are. When a doc is linked and
gt; gt; the document saved the link is no longer working. Here is what the link
gt; gt; looks like before and after save.
gt; gt;
gt; gt; P:\P05502\05201-0000\ENGINEERING\ACEP_5201_Final.pdf
gt; gt;
gt; gt; .../../M2M/m2mdata01/PROJECTS/P05502/05201-0000/ENGINEERING/ACEP_5201_Final.pdf
gt; gt;
gt; gt; P:\ is a mapped drive but navigating through the network for the link
gt; gt; casuses the same problem. Anyone have any idea why this is not working?
gt; gt;
gt; gt; LWhite
gt; gt;
gt; gt;
gt; gt;