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.

Ivan

We 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?


n"iL.White" wrote:

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 John,
see
You receive a "The file may have been changed" error message when you save
a workbook to a network server in Excel 2002 or in Excel 2003
http://support.microsoft.com/default.aspx?kbid=324491

For additional items of interest do a Google Groups search at
http://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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John Hull" wrote in message ...
We 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?


n"iL.White" wrote:

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