Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 05, 03:23 PM
Nicolle K.
 
Posts: n/a
Default Can you update links between workbooks without them both open?

Here is a simplified example of what I'm trying to do:

CarPayment.xls contains cells that list the loan amount, interest rate and
term. There is then a cell with the PMT function that calculates the car
payment. Budget.xls lists my expenses - it contains my rent, insurance and a
link to the cell in CarPayment.xls that stores the car payment amount.

There is also a cell in CarPayment.xls that contains my total expenses.
This is calculated via links back to Budget.xls - it simply adds the rent,
insurance and car payment.

So both workbooks are essentially dependent on each other. If I change the
interest rate in CarPayment.xls, this updates the car payment cell in
Budget.xls, which in turn updates the total expenses in CarPayment.xls.

I'm finding that the only way to get these to update properly is if I have
both workbooks open. If, for example, I have only CarPayment.xls open, when
I change the interest rate the car payment cell updates but the total
expenses cell does not. Is there an easier way or another explanation for
this? I would appreciate any help!

  #2   Report Post  
Old January 7th 05, 07:39 PM
Bernie Deitrick
 
Posts: n/a
Default

Nicolle,

You must have both workbooks open.

As an alternative, the workbook could be constructed such that each of these
workbooks becomes a worksheet within the new workbook. Then you would only
have to open one file.

HTH,
Bernie
MS Excel MVP

"Nicolle K." wrote in message
news
Here is a simplified example of what I'm trying to do:

CarPayment.xls contains cells that list the loan amount, interest rate and
term. There is then a cell with the PMT function that calculates the car
payment. Budget.xls lists my expenses - it contains my rent, insurance and

a
link to the cell in CarPayment.xls that stores the car payment amount.

There is also a cell in CarPayment.xls that contains my total expenses.
This is calculated via links back to Budget.xls - it simply adds the rent,
insurance and car payment.

So both workbooks are essentially dependent on each other. If I change

the
interest rate in CarPayment.xls, this updates the car payment cell in
Budget.xls, which in turn updates the total expenses in CarPayment.xls.

I'm finding that the only way to get these to update properly is if I have
both workbooks open. If, for example, I have only CarPayment.xls open,

when
I change the interest rate the car payment cell updates but the total
expenses cell does not. Is there an easier way or another explanation for
this? I would appreciate any help!





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
Update Links - Problem Metallo Links and Linking in Excel 2 January 25th 05 04:42 PM
How to find cells with links to other workbooks? Bathonian Excel Discussion (Misc queries) 1 December 21st 04 09:55 AM
File asks to update when no links were created Dave Links and Linking in Excel 1 December 16th 04 08:10 PM
Automatic update of links in destination file when source file mo. Brucgil Excel Discussion (Misc queries) 0 December 2nd 04 04:07 PM
upgrade to excel 2003 update broken links error tigger Links and Linking in Excel 0 December 1st 04 06:39 PM


All times are GMT +1. The time now is 02:47 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017