How do I link a folder to a cell in an Excel spreadsheet

G

Guest

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.
 
G

Guest

....both files have to be open for a link from one spreadsheet to another to
work.
 
G

Guest

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
 
G

Guest

In Excel 2000, this fix is in TOOLS>OPTIONS>CALCULATION/Workbook
options/update remote references.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HyperLink to a folder on other drive on the same network (LAN) 6
How do I Hyperlink to document using filename in cell? 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I get rid of expired links 3
after opening existing spreadsheet can't input data anymore 2
How to create a hyperlink to open a file with part of the name 4
how do i make a cell a search cell for a spreadsheet 5
trying to create a link to a link in Excel (2007) 3

Top