Excel #VALUE error referencing Web Table cell in formula

Question

I have successfully imported a number of data tables into Excel from: Data ribbon --> "From Web..", and then pasting the website URL, and selecting the table from the queries dialogue. As part of this queries dialogue, I select "insert into existing worksheet" at the currently selected cell address, and excel inserts the data as a table object at that position.

When I click "Refresh All" from the data tab, all of the values in the tables refresh automatically from the web sources, so this is working.

However, I can't seem to use the values in the table in any formula. For example I have one of these tables in cells B3:C7, and in the same worksheet, cell A1, I put the formula "=C4" to extract the data from cell C4 (within the table), and sure enough, the value is displayed the same as in the table. However, when I put in cell A1 "=C4*A2" where cell A2 just contains the number 2, I get the #VALUE error in cell A1.

I have searched around on google but can't seem to find anything. since the data of C4 is within a table, do I need to reference it in some special way, rather than just using the cell reference, "C4"?

Thanks