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

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

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