Thanks for the advice!!
Best regards,
Paul
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Shirley Graver
Sent: 02 August 2005 18:13
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
I use hyperlinks all over the place here. I've found I get the best
performance when there are no spaces at all in your file names. This also
applies to links in Vantage document management. Another quirk with
Vantage
document management is that it truncates the path to DOS format (as in
tilde's) So you have to be careful there too.
Shirley
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Paul Whittle
Sent: Tuesday, August 02, 2005 1:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
Shirley,
Is this why my hyperlinks in Word don't work properly?
When I set up a template document with hyperlinks, it works for me, but
seems to fail for every one else!!
Potentially spaced out!
Paul Whittle
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Shirley Graver
Sent: 01 August 2005 17:30
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
Check his file names, if they have spaces in the file names then the
link
will get lost. Replace the "spaces" with underscores "_"
Shirley Graver
Rubber Associates
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Steve Wirch
Sent: Monday, August 01, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
Hi Mark,
Odds are if it's there and the link is ok the spreadsheet is locked.
Excel 2000 and XP have a problem whereby when you close it the process
can
continue to run in the background. To detect this, close all excel
sessions, Press [Ctrl][Alt][Del], check [processes] tab, and see if
excel.exe is still churning. This can eat cpu and preserve locks. You
can
either kill the process, or reboot. Fix is to go to Office 2003.
Someone else may also have the spreadsheet locked, you should check
this,
method will change based upon whether the spreadsheet and linked sheets
are
local or on another machine.
I've learned over the years to not use links; put the data in a database
where it belongs, the use external data queries in the spreadsheet to
bring
in the data you need. This seldom breaks.
Take care,
Steve
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Mark Caldwell
Sent: Monday, August 01, 2005 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Excel links
Our controller has a bunch of Excel files linked together and when he
opens them and clicks for them to update links, it errors out saying the
source cannot be found. However, the source files are where they should
be and we can open them up without any problems. Has anybody else
experienced this and know what might have caused this and know of a
quick fix without having to physically relinking everything. The files
were not moved to a new location so I don't even understand why this
would happen.
TIA,
Mark
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage <http://groups.yahoo.com/group/vantage>
"
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
<http://docs.yahoo.com/info/terms/> .
_____
Tracking #: 20B25E1CC1A70F4E8A4B6E1545F523FE113D2ACA
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
--------------------------------------------------------------------------
--
--
YAHOO! GROUPS LINKS
a.. Visit your group "vantage" on the web.
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
--------------------------------------------------------------------------
--
--
----------
On-Line API/ISO custody transfer sampling standards tutorial
Click the following link - http://www.jiskoot.com/NetsiteCMS.php?pageid=18
This email transmission is confidential and intended solely for the person
or organisation to whom it is addressed. If you are not the intended
recipient, you must not copy, distribute or disseminate the information,
or
take any action in reliance of it.Any views expressed in this message are
those of the individual sender, except where the sender specifically
states
them to be the views of any organisation or employer. If you have received
this message in error, do not open any attachment but please notify the
sender (above) deleting this message from your system. Please rely on your
own virus check no responsibility is taken by the sender for any damage
rising out of any bug or virus infection.
This message has been scanned by F-Secure AntiVirus for mail.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS
a.. Visit your group "vantage" on the web.
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
----------------------------------------------------------------------------
--
----------
On-Line API/ISO custody transfer sampling standards tutorial
Click the following link - http://www.jiskoot.com/NetsiteCMS.php?pageid=18
This email transmission is confidential and intended solely for the person
or organisation to whom it is addressed. If you are not the intended
recipient, you must not copy, distribute or disseminate the information, or
take any action in reliance of it.Any views expressed in this message are
those of the individual sender, except where the sender specifically states
them to be the views of any organisation or employer. If you have received
this message in error, do not open any attachment but please notify the
sender (above) deleting this message from your system. Please rely on your
own virus check no responsibility is taken by the sender for any damage
rising out of any bug or virus infection.
This message has been scanned by F-Secure AntiVirus for mail.
[Non-text portions of this message have been removed]
Best regards,
Paul
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Shirley Graver
Sent: 02 August 2005 18:13
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
I use hyperlinks all over the place here. I've found I get the best
performance when there are no spaces at all in your file names. This also
applies to links in Vantage document management. Another quirk with
Vantage
document management is that it truncates the path to DOS format (as in
tilde's) So you have to be careful there too.
Shirley
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Paul Whittle
Sent: Tuesday, August 02, 2005 1:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
Shirley,
Is this why my hyperlinks in Word don't work properly?
When I set up a template document with hyperlinks, it works for me, but
seems to fail for every one else!!
Potentially spaced out!
Paul Whittle
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Shirley Graver
Sent: 01 August 2005 17:30
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
Check his file names, if they have spaces in the file names then the
link
will get lost. Replace the "spaces" with underscores "_"
Shirley Graver
Rubber Associates
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Steve Wirch
Sent: Monday, August 01, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT: Excel links
Hi Mark,
Odds are if it's there and the link is ok the spreadsheet is locked.
Excel 2000 and XP have a problem whereby when you close it the process
can
continue to run in the background. To detect this, close all excel
sessions, Press [Ctrl][Alt][Del], check [processes] tab, and see if
excel.exe is still churning. This can eat cpu and preserve locks. You
can
either kill the process, or reboot. Fix is to go to Office 2003.
Someone else may also have the spreadsheet locked, you should check
this,
method will change based upon whether the spreadsheet and linked sheets
are
local or on another machine.
I've learned over the years to not use links; put the data in a database
where it belongs, the use external data queries in the spreadsheet to
bring
in the data you need. This seldom breaks.
Take care,
Steve
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Mark Caldwell
Sent: Monday, August 01, 2005 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Excel links
Our controller has a bunch of Excel files linked together and when he
opens them and clicks for them to update links, it errors out saying the
source cannot be found. However, the source files are where they should
be and we can open them up without any problems. Has anybody else
experienced this and know what might have caused this and know of a
quick fix without having to physically relinking everything. The files
were not moved to a new location so I don't even understand why this
would happen.
TIA,
Mark
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage <http://groups.yahoo.com/group/vantage>
"
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
<http://docs.yahoo.com/info/terms/> .
_____
Tracking #: 20B25E1CC1A70F4E8A4B6E1545F523FE113D2ACA
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
--------------------------------------------------------------------------
--
--
YAHOO! GROUPS LINKS
a.. Visit your group "vantage" on the web.
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
--------------------------------------------------------------------------
--
--
----------
On-Line API/ISO custody transfer sampling standards tutorial
Click the following link - http://www.jiskoot.com/NetsiteCMS.php?pageid=18
This email transmission is confidential and intended solely for the person
or organisation to whom it is addressed. If you are not the intended
recipient, you must not copy, distribute or disseminate the information,
or
take any action in reliance of it.Any views expressed in this message are
those of the individual sender, except where the sender specifically
states
them to be the views of any organisation or employer. If you have received
this message in error, do not open any attachment but please notify the
sender (above) deleting this message from your system. Please rely on your
own virus check no responsibility is taken by the sender for any damage
rising out of any bug or virus infection.
This message has been scanned by F-Secure AntiVirus for mail.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS
a.. Visit your group "vantage" on the web.
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
----------------------------------------------------------------------------
--
----------
On-Line API/ISO custody transfer sampling standards tutorial
Click the following link - http://www.jiskoot.com/NetsiteCMS.php?pageid=18
This email transmission is confidential and intended solely for the person
or organisation to whom it is addressed. If you are not the intended
recipient, you must not copy, distribute or disseminate the information, or
take any action in reliance of it.Any views expressed in this message are
those of the individual sender, except where the sender specifically states
them to be the views of any organisation or employer. If you have received
this message in error, do not open any attachment but please notify the
sender (above) deleting this message from your system. Please rely on your
own virus check no responsibility is taken by the sender for any damage
rising out of any bug or virus infection.
This message has been scanned by F-Secure AntiVirus for mail.
[Non-text portions of this message have been removed]