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.