This stock query works fine in an Excel 2003 macro but causes an error when used in a similar Excel macro for Office 2011

Sheets("stock quotes").QueryTables(1).FillAdjacentFormulas = True

Greatly appreciate any suggestions in using an Excel stock query table

Jim