Refreshing web query creates #N/A in referencing cells

[MyMe237]

Hi,

I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries.

The order of the formulas is as follows:

web query --> cells referencing the table created by the web query (example formula - =(a2)) --> cells referencing the cells with the =(a2) formula (example - =max(a:a))

When I first created those tabs, the formulas worked perfectly, but once I refresh the data from the web query, the cells referencing the =(a2) formulas display #N/A errors. Now, the data from the web query displays and updates correctly and in the the same format, and so do the cells with the =(a2) formulas. It's only the cells that reference the =(a2) formulas that break. And even if I paste the =(a2) cells as values to get rid of the formulas, the #N/A remains.

When I direct the =max(a:a) formula to a column that was originally hard-coded, I get the result I'm looking for.

I verified the cells have numbers, using ISNUMBER and I tried pasting as values the data from the web query and the data from the =(a2) cells. But nothing helps.

Any thoughts?

Thanks.