Group:  Microsoft Excel ยป microsoft.public.excel.worksheet.functions
Thread: How do I link a folder to a cell in an Excel spreadsheet

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How do I link a folder to a cell in an Excel spreadsheet
Hyperlink from Excel Cell to Folder 08.12.2005 18:31:02
i have tried to hyperlink from a cell in an Excel spreadsheet to a folder in
a different directory. It works until I save and close the spreadsheet.
When I reopen the speadsheet the link comes up as invalid. Help.
RE: How do I link a folder to a cell in an Excel spreadsheet
JR 08.12.2005 19:52:02
....both files have to be open for a link from one spreadsheet to another to
work.

"Hyperlink from Excel Cell to Folder" wrote:

[Quoted Text]
> i have tried to hyperlink from a cell in an Excel spreadsheet to a folder in
> a different directory. It works until I save and close the spreadsheet.
> When I reopen the speadsheet the link comes up as invalid. Help.
RE: How do I link a folder to a cell in an Excel spreadsheet
Sramic 28.09.2006 15:11:02
I think the problem is the same as a problem i had. Excel tries to "UPDATE"
the links when you save a file and "corrupts" the link. To fix this you can
turn auto link updating off. DATA>OPTIONS>GENERAL click on web options
button. Under the tab named FILES deselect "update links on save". This
worked well for me but I wish microsoft would fix the problem.

PL

"JR" wrote:

[Quoted Text]
> ...both files have to be open for a link from one spreadsheet to another to
> work.
>
> "Hyperlink from Excel Cell to Folder" wrote:
>
> > i have tried to hyperlink from a cell in an Excel spreadsheet to a folder in
> > a different directory. It works until I save and close the spreadsheet.
> > When I reopen the speadsheet the link comes up as invalid. Help.


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net