Skip to Content
0
Former Member
Mar 20, 2009 at 07:20 AM

#REF! appearing in the workbook cells

15 Views

Hi gurus,

When there are values for the query selection, the workbook will present the values properly but when there are no values for a perticular selection criteria of the query- #REF! appeares in the workbook cells. I think there are cell references in the workbook. Now the client does not want that '#REF!' to appear, he wants zero to appear if values are not there. Pls advice how to achieve this?

Thanks & Regards,

Shreesh.