Links

  • Thread starter Thread starter prhrmk
  • Start date Start date
P

prhrmk

I have a spreadsheet that is linked to another and pulls in - let's say
Monthly $. The only way it updates properly is if you have the other
spreadsheet open too. Otherwise, you get VALUE# on all the cells when
you select UPDATE.

Is there a way to have both spreadsheets open when you open the Monthly
$ report.

I hope this is making sense?

Thanks,
P :)
 
There are some formulas (=sumif(), =countif(), for example) that don't work with
closed files.

But there are workarounds.

You may want to share the formula that returns the error when the other workbook
is closed.
 
Back
Top