Hi

I have an unexplained behaviour in Excel. I am trying to create a report. I use a Data Query and add to it some columns with formulas. If the quesry returns with the results, the formulas work fine and show results. If the query returns with empty result, Excel suddenly removes the formulas from all the columns and never recovers it, it brakes the report. What can I do to make formulas stay even if Data Query returned with empty result?

Thanks a lot