Question regarding absolute and relative links in .XLS

  • Thread starter Thread starter Andrew Sutherland
  • Start date Start date
A

Andrew Sutherland

Quick question I am hoping someone might be able to assist with,

Our users have a joint excel workbook that is linked to other .docs and
..xls's, so when they open their workbook it fills in the excel lines
automatically via a formula that obtains that info from the other
documents.

If they open the excel workbook from a UNC folder, ie.
\\server\\share\workbook.xls - it works great.

However, if they open it via relative (mapped) drive folder, ie.
I:\fin\workbook.xls - the formulas dont work properly and they just get
a whole bunch of NA's instead of data.

My Question: Is there a way to force Excel (2003) to ALWAYS use UNC's
instead of changing them to relative (mapped)? Is there a registry key,
or patch, or......

thanks in advance!
Andrew
 
I've had similar problems in the past with links created that did not contain
the entire path, so they looked only to the default directory.......when the
file was moved, the new default directory did not contain the referenced
files so the links returned errors.......

hth
Vaya con Dios,
Chuck, CABgx3
 

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

MS Excel: Linking spreadsheet and Absolute and Relative Paths 7
Absolute->relative link 2
Hyperlink to cells in other workbooks keep changing 3
relative path in OLEDB string 3
Absolute reference when creating links to another workbook? 3
Re - Excel Help delineating Absolute and Relative Hyperlinks 0
Absolute External Link? 1
Relative Link remembers absolute path?? 1

Back
Top