Hi,
my Excel workbook has 2 sheets:

1. Source: with an external data reference to a MS Access database
Query property "If number of rows changes after refresh" is set to
option #1:
"Insert cells for new data, delete unused cells"
User chooses external query selection criteria and therefore can
have different result sets.

2. Target:
Formular B4: =Source!P5
Formular B5: =Source!P6
Formular B6: =Source!P7

Problem:
When Source has data in rows 5, 6 and 7 formular gets calculated correctly.
If Source row #5 has data and #6 and #7 is empty then I get a #refe error in
Target cells B5 and B6.
Error details: Invalid cell reference.

I would have expected that in this case the cell shows no data because the
source cell is empty.

Appreciate any thought on how to troubleshoot.



--
Thanks in advance
Bodo