Update linked formulas between workbooks

  • Thread starter Thread starter lbabli
  • Start date Start date
L

lbabli

We have 2 workbooks where staff enter daily totals. The totals in these
2 worksbooks need to be combined for a grand total. I created a
formula that adds Day 1 of workbook1 to Day 1 of workbook2. However,
we must save both workbooks, and close/reopen the one with the formula
to update the total. I tried using Edit/Links but that didn't work.
Any suggestions?
 
Hi,

Check that 'Update remote references' is checked un
Tools|Options|Calculation.

Cheers
 
Hi,

Do you get a prompt to update the links when the workbook is opened? If not,
make sure 'Ask to update automatic links' is checked under
Tools|Options|Edit. Also, make sure Calculation is set to 'Automatic' under
Tools|Options|Calculation.

Cheers
 
Yes. I get the prompt. However, I would really prefer not to close and
open to file to get this prompt. I want the formula to update/refresh
without having to close/reopen.
Thanks,
Lin
 
Back
Top