Filled Element (Microsoft Excel)

Specifies whether formulas to the right of a query table are copied when the data is refreshed and new rows of data are added to a query table.

Contained In

QueryTable

Remarks

If <x:Filled/> is specified, any formulas to the right of the query table are filled down. If fewer rows are returned during the refresh, any unused formulas are removed from the worksheet.

Example

See the example in the QueryTable element topic.