External Data Range Properties - Cannot find in 2007

S

Steve

I have a 2003 spreadsheet which i am now updating in 2007.

On the old existing data connections created with 2003 i have a "External
Data Range Properties" option which includes the "Fill down formulas in
columns adjacent to data".

My new connections do not have this option, instead they come in as a table
which under "table -> External Data Properties" i have some of the options
but not all, some of which i can find under other options but not the "Fill
down ...." one.

Can someone please help with (a) where can i find the "Fill down ...."
option for the new connections and (b) how do i create a 2003 style
connection that doesnt bring the data in as a new type of table so i can then
see the "External Data Range Properties" dialog box. It's there in 2007, i
just cant get to it.

Cheers

Steve
 
A

Angelos

You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.



Posted as a reply to:

External Data Range Properties - Cannot find in 2007

I have a 2003 spreadsheet which i am now updating in 2007

On the old existing data connections created with 2003 i have a "External
Data Range Properties" option which includes the "Fill down formulas in
columns adjacent to data"

My new connections do not have this option, instead they come in as a table
which under "table -> External Data Properties" i have some of the options
but not all, some of which i can find under other options but not the "Fill
down ...." one

Can someone please help with (a) where can i find the "Fill down ...."
option for the new connections and (b) how do i create a 2003 style
connection that doesnt bring the data in as a new type of table so i can then
see the "External Data Range Properties" dialog box. It's there in 2007, i
just cant get to it

Cheer

Steve

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx
 

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

Top