A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel: External Network Links



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2008, 06:04 PM posted to microsoft.public.excel.links
misoca
external usenet poster
 
Posts: 2
Default Excel: External Network Links

I've started creating reporting files on Excel 2003 which are shared via
Mailsite 8.0 which link several files to one summary file. Currently the
file works when I open it, but not when another person opens it from their
computer. Ideally, multiple people would be able to access the summary file
with working links, and the correction could be easily applied to other
similar file relationships.

It looks like the file is connecting to the desktop of the specific user (in
the example below, misoca)before finding the worksite file (in the example
below, 90625), so when someone else opens it they can't access my desktop.

'C:\Documents and Settings\misoca\Local
Settings\Temp\NetRight\Links\WorkSite\[90625_1.XLS]

Another post hinted at what I might be doing wrong, but I'm not sure what
that means or how to fix it: "Also if your source files are on a network
drive and if you have mapped the network drive under different name it may be
causing the problem"

Thanks!
  #2  
Old November 13th, 2008, 09:44 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Excel: External Network Links

I know nothing about MailSite, but the symptoms you describe are
similar to those we see if a user emails the summary workbook to
someone else as an attachment and that person opens the attachment,
gets an error because they can't access the linked files and then sends
it back to you.

Assuming that all users can see the network location of the summary
file, do not send the file around as an email attachent; rather get the
users to access the file from its network location.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3  
Old November 18th, 2008, 05:33 PM posted to microsoft.public.excel.links
misoca
external usenet poster
 
Posts: 2
Default Excel: External Network Links

Thanks for the response Bill. Unfortunately the file is not being emailed,
but rather each user accesses it directly from the network.

It seems as if the file path naming changes depending upon whether the
source files are open, and when the source file is saved/closed with respect
to the summary file, even though the formula is entered appears to be set the
same. Generally I try to either copy a relative formula and use find-replace
to change the paths of entire sections if need be.

I saw something online about writing a universal path to a file, for
networked files, but have not been able to find a clear explanation on how to
do that? Can someone direct me further on that point?

Thanks,

"Bill Manville" wrote:

I know nothing about MailSite, but the symptoms you describe are
similar to those we see if a user emails the summary workbook to
someone else as an attachment and that person opens the attachment,
gets an error because they can't access the linked files and then sends
it back to you.

Assuming that all users can see the network location of the summary
file, do not send the file around as an email attachent; rather get the
users to access the file from its network location.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


  #4  
Old November 19th, 2008, 08:31 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Excel: External Network Links

Misoca wrote:
I saw something online about writing a universal path to a file, for
networked files


A UNC filename is like
\\ServerName\ShareName\Folder\Folder\FileName.ext

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

 




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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:54 PM.


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