Data range need help
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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
.
Relevant Pages
- Problem with External Data range Properties
... In the External Data Range Properties, ... 'If the number of rows in the data range changes upon refresh:' ... clear unused cells. ...
(microsoft.public.excel) - Getting external data problem
... In the External Data Range Properties, ... 'If the number of rows in the data range changes upon refresh:' ... clear unused cells. ...
(microsoft.public.excel) - Problem with External Data range Properties
... In the External Data Range Properties, ... 'If the number of rows in the data range changes upon refresh:' ... clear unused cells. ...
(microsoft.public.excel.newusers) - RE: Data range properties
... In the Data Range Properties, ... > 'If the number of rows in the data range changes upon refresh:' ... > 2 - Insert entire rows for new data, clear unused cells ... > Cheers Baz ...
(microsoft.public.excel.misc) - data range
... Data Layout. ... 'If the number of rows in the data range changes upon refresh:' ... - Insert entire rows for new data, clear unused cells ...
(microsoft.public.excel) |
|
