Problem with External Data range Properties

S

Steve M

Hi

In the External Data Range Properties, there are 3 options for
'If the number of rows in the data range changes upon refresh:'

I want it to stay on option 3 - Overwrite existing cells with new data,
clear unused cells.

but it keeps defaulting to option2 - Insert entire rows for new data, clear
unused cells.

I am using Excel 2000 and my data is from Access 97.

Any ideas??

Steve
 

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

Getting external data problem 0
external data problem 0
data range problem 0
data range 0
How to manage new data with external data in Excel? 1
Import Access Data from 3 databases into 1 worksheet *ERROR* 0
Data range properties 1
Problem with external data 0

Top