Refreshing web query creates #N/A in referencing cells

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.

Thank you, Glenn.

Actually, your request led me to try to recreate the error unsuccessfully with a new query, which then led me to finding out my mistake!

Apparently, when I refreshed the web query, the new data was missing a few of the original entries, leading to an #N/A error in the column with the =(a2) formula. Then, When I tried to find the maximum value in the =(a2) column, the formula failed because of these #N/As, resulting in the new #N/A error that frustrated me so much.

Since I can't recreate the error with a new query and since the original query produced a very large dataset, I'm afraid I don't have a sample spreadsheet to share and show the error and the fix.

I hope my explanation is clear enough.