I have a linked table which will contain errors and which give an #NUM! error.
That's fine. I can't clean up the data I'm linking to (not in my control) but I know that the #NUM! error items can just be ignored for my reporting purposes - they don't affect the totals I am trying to extract...