Data range properties

B

baz

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 props 0
Data range need help 0
Help - external data 0
Problem with external data 0
Import Access Data from 3 databases into 1 worksheet *ERROR* 0
How to manage new data with external data in Excel? 1
data range 0
data range problem 0

Top