Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 27th 04, 04:07 AM
L Mehl
 
Posts: n/a
Default Links in formulas change when another user runs a workbook

Hello --

When another user runs a set of workbooks I built for him, links in formulas
include the name of the folder in which he stored the set of xls files.

In my original files, links simply look like
workbook.xls!range_name

His workbooks don't work. and, when he sends them to us to fix, the links
have to be changed.

MS article PSS ID Number: 327006 seems to be relevant to this problem.
If I understand the article, it suggests:

"To temporarily prevent the recalculation of external links, set the
calculation environment to Manual... "

I can see how to do that in code placed in Workbook_Open,
but I can't figure out where to turn recalculation back ON.

Am I on the right track with this as a solution to the problem?

If so, can someone tell me where to put code to turn recalculation ON.

If not, do you have an idea of how the links become changed?

Thank you for any help.

Larry Mehl





---

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/2004



  #2   Report Post  
Old November 27th 04, 09:33 AM
Nick Hodge
 
Posts: n/a
Default

Larry

If I understand you correctly. When the workbook, to which it is linked is
open, that dialog only shows the file name, when it is closed the linked
workbook shows the path to it. This path would need to be available to the
new user for the links to not require updating. That is the links have a
fixed path, they are not searching for a workbook name which could be the
same in many folders.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"L Mehl" wrote in message
...
Hello --

When another user runs a set of workbooks I built for him, links in
formulas
include the name of the folder in which he stored the set of xls files.

In my original files, links simply look like
workbook.xls!range_name

His workbooks don't work. and, when he sends them to us to fix, the links
have to be changed.

MS article PSS ID Number: 327006 seems to be relevant to this problem.
If I understand the article, it suggests:

"To temporarily prevent the recalculation of external links, set the
calculation environment to Manual... "

I can see how to do that in code placed in Workbook_Open,
but I can't figure out where to turn recalculation back ON.

Am I on the right track with this as a solution to the problem?

If so, can someone tell me where to put code to turn recalculation ON.

If not, do you have an idea of how the links become changed?

Thank you for any help.

Larry Mehl





---

Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/2004




  #3   Report Post  
Old November 27th 04, 09:27 PM
L Mehl
 
Posts: n/a
Default

Nick --

Thanks.

I think we will require that all users install in the same folder, as well
as add code to the "calling" workbook to hide selected other workbooks.

Larry


"Nick Hodge" wrote in message
...
Larry

If I understand you correctly. When the workbook, to which it is linked is
open, that dialog only shows the file name, when it is closed the linked
workbook shows the path to it. This path would need to be available to

the
new user for the links to not require updating. That is the links have a
fixed path, they are not searching for a workbook name which could be the
same in many folders.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"L Mehl" wrote in message
...
Hello --

When another user runs a set of workbooks I built for him, links in
formulas
include the name of the folder in which he stored the set of xls files.

In my original files, links simply look like
workbook.xls!range_name

His workbooks don't work. and, when he sends them to us to fix, the

links
have to be changed.

MS article PSS ID Number: 327006 seems to be relevant to this problem.
If I understand the article, it suggests:

"To temporarily prevent the recalculation of external links, set the
calculation environment to Manual... "

I can see how to do that in code placed in Workbook_Open,
but I can't figure out where to turn recalculation back ON.

Am I on the right track with this as a solution to the problem?

If so, can someone tell me where to put code to turn recalculation ON.

If not, do you have an idea of how the links become changed?

Thank you for any help.

Larry Mehl





---

Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/2004






---

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/25/2004




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
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM


All times are GMT +1. The time now is 07:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017