Links

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 :)
 
D

Dave Peterson

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.
 
Top