A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

how to prevent excel to change hyperlink path towards external fil



 
 
Thread Tools Display Modes
  #1  
Old October 6th 09, 08:57 AM posted to microsoft.public.excel.misc
Danko Jotanovic
external usenet poster
 
Posts: 7
Default how to prevent excel to change hyperlink path towards external fil

I have cca 150 entries in 6 column table made in excel 2007. One of those 6
columns contains links to pdf files saved in separate directory on the same
hard disk drive.
Somehow, (I do not how it happens…) excel changes hyperlink paths towards
pdf documents.
My pdf docs are saved in a folder:
c:\users\AUSER\Auser documents\pdfs\classX
However, excel somehow changes this path to NONEXISTING one:
c:\users\AUSER\AppData\Roaming\Microsoft\Excel\pdf s\classX

How to prevent excel from changing original path towars my pdf documents?

Ads
  #2  
Old October 6th 09, 09:07 AM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 8,521
Default how to prevent excel to change hyperlink path towards external fil

Have you used worksheet function HYPERLINK()

Check out the help on
HYPERLINK(link_location,friendly_name)

If this post helps click Yes
---------------
Jacob Skaria


"Danko Jotanovic" wrote:

> I have cca 150 entries in 6 column table made in excel 2007. One of those 6
> columns contains links to pdf files saved in separate directory on the same
> hard disk drive.
> Somehow, (I do not how it happens…) excel changes hyperlink paths towards
> pdf documents.
> My pdf docs are saved in a folder:
> c:\users\AUSER\Auser documents\pdfs\classX
> However, excel somehow changes this path to NONEXISTING one:
> c:\users\AUSER\AppData\Roaming\Microsoft\Excel\pdf s\classX
>
> How to prevent excel from changing original path towars my pdf documents?
>

  #3  
Old October 6th 09, 09:53 AM posted to microsoft.public.excel.misc
Danko Jotanovic
external usenet poster
 
Posts: 7
Default how to prevent excel to change hyperlink path towards external

what I did is:
I typed friendly name inside the cell and then clicked hyperlink icon from
Insert menu, browse to the file, selected it and it worked.
my problem appeared afterwards. like I said, excel somehow managed to change
hyperlink path...

I just tried with worksheet function HYPERLINK like it is described in HELP,
but it is not working at all.
when I enter everything needed to retrieve specific pdf document, as a
result i get #NAME? shown inside the cell, error message after the click.

"Jacob Skaria" wrote:

> Have you used worksheet function HYPERLINK()
>
> Check out the help on
> HYPERLINK(link_location,friendly_name)
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Danko Jotanovic" wrote:
>
> > I have cca 150 entries in 6 column table made in excel 2007. One of those 6
> > columns contains links to pdf files saved in separate directory on the same
> > hard disk drive.
> > Somehow, (I do not how it happens…) excel changes hyperlink paths towards
> > pdf documents.
> > My pdf docs are saved in a folder:
> > c:\users\AUSER\Auser documents\pdfs\classX
> > However, excel somehow changes this path to NONEXISTING one:
> > c:\users\AUSER\AppData\Roaming\Microsoft\Excel\pdf s\classX
> >
> > How to prevent excel from changing original path towars my pdf documents?
> >

  #4  
Old October 6th 09, 01:40 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default how to prevent excel to change hyperlink path towards external fil

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.

===============

I like to use the =hyperlink() worksheet function for this.

I'll put the path in a hidden cell (A1 in my example). (Include the trailing
backslash, too!)

Then put the filenames in A2:Axxx
Then use the =hyperlink() formula in B2:Bxx.

=hyperlink("File:////"&$a$1&a2,"Click me")
and drag down

Then when I need to change the folder, I can change it one location (A1).

I could embed the path directly in the formula:
=hyperlink("File:////c:\my documents\excel\"& a2,"Click me")
and use Edit|Replace, but that seems like more work to me.

========
If you used Insert|Hyperlink, then you've noticed that edit|replace won't touch
those hyperlink addresses.

Saved from a previous post:

If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But
the good news is David McRitchie has done most of it for you:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Danko Jotanovic wrote:
>
> I have cca 150 entries in 6 column table made in excel 2007. One of those 6
> columns contains links to pdf files saved in separate directory on the same
> hard disk drive.
> Somehow, (I do not how it happens…) excel changes hyperlink paths towards
> pdf documents.
> My pdf docs are saved in a folder:
> c:\users\AUSER\Auser documents\pdfs\classX
> However, excel somehow changes this path to NONEXISTING one:
> c:\users\AUSER\AppData\Roaming\Microsoft\Excel\pdf s\classX
>
> How to prevent excel from changing original path towars my pdf documents?


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel hyperlink loses its path on save (2) Davva Excel Discussion (Misc queries) 0 July 2nd 09 01:16 PM
Hyperlink to File name and path VBA Excel jlclyde Excel Discussion (Misc queries) 3 February 4th 09 07:24 PM
Excel 2000: Changing path of an external data source Craig Excel Discussion (Misc queries) 1 December 11th 07 05:03 PM
hyperlink navigation path path wrong in Excel 2003 CE Admin Excel Discussion (Misc queries) 5 January 7th 06 07:47 PM
How prevent formulas to get external references/path to current workbook? Gunnar Johansson Excel Worksheet Functions 1 August 15th 05 10:39 AM


All times are GMT +1. The time now is 04:45 PM.


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