Cells shift when a QueryTable is refreshed

G

g.cook.a

Hello!

I am having trouble with several QueryTables in my Excel spreadsheet.
I have allowed each QueryTable a certain amount of space (6 rows x 1
column) and am trying to keep them aligned both vertically and
horizontally. The problem is that the QueryTables' data sources
provide a dynamic number of rows. For each QueryTable no more than 5
rows (plus the header for a total of 6) will be returned, however
whenever fewer than the maximum number of rows are returned during a
Refresh All operation it causes cells below the QueryTable to move up
or down accordingly. Is there a way to make a QueryTable refresh and
not affect the placement of surrounding data, regardless of changes in
the number of rows?

Thanks! :)

Garrett
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non-exclusive file access via QueryTable 0
Code problem working with QueryTable 1
Unwanted Querytable Autofilter on ODBC Import 4
A QueryTable refresh, a named range, the 'Hidden' property 0
Deleting Zeros and Shifting All Cells left 3
cell range not changing when refreshing linked data- sumproduct fo 1
loop until empty row and column problem (format cells until the lastrow and column in a report) 4
Macro to Combine Data from Multiple Sheets with Cell References 4

Top