Refreshing web query creates #N/A in referencing cells

MyMe237

New Member
Joined
Jul 3, 2019
Messages
1
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.
 

Forum statistics

Threads
1,085,586
Messages
5,384,592
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top