Hi all,

I'm building a spreadsheet that pulls in data from both a web query and a MySQL database.

I understand that Excel has the ability to fill down formulas for adjacent cells if the result set from my query grows. This is working well with my web query. However, I noticed that for the connection to the MySQL database, I do not have the option to do this. There is a checkbox for the web query properties menu that I can check to perform this, however for whatever reason, it's not found for my MySQL query. Is there any way to duplicate this function?

Also, FYI, I am using MS Excel 2007.

Thanks,
ChuckieT