Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 08, 05:04 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
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   Report Post  
Old November 13th 08, 08:44 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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   Report Post  
Old November 18th 08, 04:33 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
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   Report Post  
Old November 19th 08, 07:31 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External Links using Excel JB25 Excel Discussion (Misc queries) 2 August 31st 07 01:01 AM
External Links in Excel 2007 betany70 Excel Worksheet Functions 2 August 27th 07 02:34 PM
Excel links break on network Salman Setting up and Configuration of Excel 0 September 19th 06 10:30 AM
Excel: Finding external "links" in a spreasheet CILeader Excel Discussion (Misc queries) 3 October 15th 05 06:02 PM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017