Update LINKS when opening a workbook?

[Dragon120]

Hi Excel Experts,

I've stumpled upon a little problem. I will try my best to explain wha
I've encounterd.

Main Workbook (let's call this MONTHS workbook).
- in this workbook, there are various columns (ie, Sales, Operations
etc.)
- in each column under the appropriate categories, a formula is bein
used to gather the data from various files (ie. Sales, Operations
etc.) I've used the SUMIF formula. I've verified the formulas worke
and balanced.

Sales File- in this file, the columns are identical to the MAI
WORKBOOK. If a number changes in this file, IT SHOULD change
accordingly in the MAIN WORKBOOK.

When I was testing, I changed a number in cell $D$9 and saved the file
When I open MAIN workbook, it asked if I want to update th
links...HERE'S MY PROBLEM. If I select YES, it will give me #VALUE (
don't want to open the Sales file simultaneously). If I select NO, i
doesn't give me the most updated number.

Am I missing something?

Your help is greatly appreciated! I spend my weekend doing this fo
work and don't want to see it go to waste...

Thank you in advance

 

[Tom Ogilvy]

A link only operates when the workbook is open. Since your workbook isn't
open, when you do open it it offers to update the link. However, Some
formulas, such as sumif won't update to a closed workbook (the source
workbook this time). If you want the latest information, at some point you
need both workbooks open and let the workbook update links if it asks.