I've been playing around with grabbing information from web pages to help me out with somethign I am doing. Basically the workbook drags in a table from a webpage to give stats for each month over a number of years. I then have custom function that is a lookup. Given two variables provided by the user (or by the sheet itself) it grabs the relevant data. It works by cycling down the years till it finds the right one, then cycling the months and returning what is in the intersection. Works like a charm, except...

If I refresh the external data the cell with the answer remains the same until I go into it to edit it then hit return. Refresh all doesn't work. Is there a way I can force the cell to recalculate? At the moment it is just one cell but once I get that working it is likely to be lots of cells (in no particular location).