data range

S

Steve M

Hi

I have a problem with external data. In the Data Range Properties, under
Data Layout.
There are 3 options after
'If the number of rows in the data range changes upon refresh:'
1 - Insert cells for new data, delete unused cells
2 - Insert entire rows for new data, clear unused cells
3 - Overwrite existing cells with new data, clear unused cells.

I want option 3 to be the default oprion but it always defaults back to
option 2. Is there any way I can change this.??

Cheers Baz
 

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

data range problem 0
external data problem 0
MACRO RUN random percentage and copy of column values 1
Publisher is filling blank lines with data 2
data range props 0
Data range properties 1
Problem with External Data range Properties 0
Data range need help 0

Top