Is there a way to ignore the lines that have errors, i.e. "#Value" and "####"
when I create my pivot tables?