Updating LINKS when opening a workbook
 

Hi Excel Experts,

I've stumpled upon a little problem. I will try my best to explain
what 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 being
used to gather the data from various files (ie. Sales, Operations,
etc.) I've used the SUMIF formula. I've verified the formulas worked
and balanced.

_*Sales_File*_- in this file, the columns are identical to the MAIN
WORKBOOK. If a number changes in this file, IT SHOULD changed
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 the
links...HERE'S MY PROBLEM. If I select YES, it will give me #VALUE (I
don't want to open the Sales file simultaneously). If I select NO, it
doesn't give me the most updated number.

Am I missing something? :confused:

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

Thank you in advance!


--
Dragon120
------------------------------------------------------------------------
Dragon120's Profile: http://www.excelforum.com/member.php...o&userid=33091
View this thread: http://www.excelforum.com/showthread...hreadid=529033

Updating LINKS when opening a workbook
 

See one answer in respone to one of your multiposts.

--
Regards,
Tom Ogilvy

"Dragon120" wrote
in message ...

Hi Excel Experts,

I've stumpled upon a little problem. I will try my best to explain
what 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 being
used to gather the data from various files (ie. Sales, Operations,
etc.) I've used the SUMIF formula. I've verified the formulas worked
and balanced.

_*Sales_File*_- in this file, the columns are identical to the MAIN
WORKBOOK. If a number changes in this file, IT SHOULD changed
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 the
links...HERE'S MY PROBLEM. If I select YES, it will give me #VALUE (I
don't want to open the Sales file simultaneously). If I select NO, it
doesn't give me the most updated number.

Am I missing something? :confused:

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

Thank you in advance!


--
Dragon120
------------------------------------------------------------------------
Dragon120's Profile:
http://www.excelforum.com/member.php...o&userid=33091
View this thread: http://www.excelforum.com/showthread...hreadid=529033