Update remote references without opening the second sheet

[goofy78270]

Is it possible to update values within a second workbook without opening that workbook?

Also, is it possible to use INDIRECT to reference another workbook?

 

[Fazza]

http://excelkb.com/?cNode=1J5L2H&pNodes=8M3M1M
http://www.erlandsendata.no/english/index.php?t=envbadac

Google will reveal lots of similar & related info. Regards, Fazza

 

[goofy78270]

With this method, if I update tab 1 within workbook b, will the formulas on tab 2 and 3 update as well with the workbook being closed?

 

[Fazza]

No. (Though in normal circumstances they would update when the file opens. That is, when calculation is automatic.)

If there is something you want to do, better to ask about that. These detailed questions might be not revealing a 'bigger picture' answer/approach that would be superior.

 

[goofy78270]

Here is what I do.

Every Day, I download an investor ratesheet and archive it - not very hard and just for reference purposes.
I compare the ratesheet of today vs yesterday or Friday if it is Monday by saving the today's ratesheet as today and moving the previous today's ratesheet to yesterday.

From this comparison, created within a comparison tab, I determine the change in rates, by the differences, and track changes that need to be addressed from a programming standpoint within a comparison summary tab of the workbook.

I then create customer pricing after adding in our various cost. This portion is done within a seperate workbook due to the amount of calculations.

I would like the customer pricing woorkbook to simply update itself when changes to the comparison workbook are done. Currently we have to open each customer pricing workbook when on a daily basis which takes about a half hour in total to complete, given there are no errors. This is the process I would like to cut out or at least minimize in time.

NOTE: The reason for the comparison book vs the product books is to seperate the products out by type rather than all products in one workbook.