Link to SQL Server?

[[email protected]]

Hello -

I'm building a pivot table and chart in Excel based on information from
SQL server. I'm noticing that the actual data is being included when I
save the spreadsheet, but I don't want to save the actual data with the
spreadsheet. I want just the table and chart definitions. How can I
link to the SQL server without actually importing the data?

Thanks

[Andrew]

When I do these sort of things I create a (small) summary table in SQL
Server and then, using odbc black art, import it into Excel... or is the
question not based on size .i.e. security etc???

That's my tuppence worth... any use?

regards

andrew
www.jmdata.co.uk

<[email protected]> wrote in message
news:[email protected]...
> Hello -
>
> I'm building a pivot table and chart in Excel based on information from
> SQL server. I'm noticing that the actual data is being included when I
> save the spreadsheet, but I don't want to save the actual data with the
> spreadsheet. I want just the table and chart definitions. How can I
> link to the SQL server without actually importing the data?
>
> Thanks
>

[[email protected]]

Hi Andrew -

I'm not sure what you suggest would help in this case. I'm just trying
to separate the data from the query format. I do want all of the data
visible in Excel, but when I save the Excel file I don't want the data
saved with it. Does that make better sense?

Thanks....
Greg

[andreww]

Not really... do you want to give me a call and I'll see if I can help you.

Cheers

Andrew
www.jmdata.co.uk

<[email protected]> wrote in message
news:[email protected]...
> Hi Andrew -
>
> I'm not sure what you suggest would help in this case. I'm just trying
> to separate the data from the query format. I do want all of the data
> visible in Excel, but when I save the Excel file I don't want the data
> saved with it. Does that make better sense?
>
> Thanks....
> Greg
>

[[email protected]]

Hi Andrew - trying to call you from the phone number on your website,
from the United States, and it's not working. Can you tell me how?

Thanks

[[email protected]]

Never mind...just figured it out. In data range properties, there's an
option "Remove External Data From Worksheet Before Saving" that did the
trick.

Thanks anyway for the help Andrew.

Cheers!

[andreww]

Glad you have sorted, I understand what you are trying to do now.

Also, to dial a UK number you need to take off the leading zero.

Cheers

Andrew

<[email protected]> wrote in message
news:[email protected]...
> Never mind...just figured it out. In data range properties, there's an
> option "Remove External Data From Worksheet Before Saving" that did the
> trick.
>
> Thanks anyway for the help Andrew.
>
> Cheers!
>

[Andrew]

Greg, not sure I understand what you mean. If you call me (see
wwwdotjmdatadotcodotuk) I'll try and help.

Cheers

Andrew
<[email protected]> wrote in message
news:[email protected]...
> Hi Andrew -
>
> I'm not sure what you suggest would help in this case. I'm just trying
> to separate the data from the query format. I do want all of the data
> visible in Excel, but when I save the Excel file I don't want the data
> saved with it. Does that make better sense?
>
> Thanks....
> Greg
>