Pivotchart + ODBC + Office 2007

[Chris]

Hello,

I have the following configuration:
- SharePoint 2003 on the server with the Office Web parts installed
- Office 2007 (Excel, etc.) and OWC11 on my computer.

I want to use the PivotChart Web Part and ODBC to connect to named ranges in
Excel. It works perfectly for computers with Office/Excel 2003 installed, but
I get an error when I try the same with Office/Excel 2007.

Thanks for your help!

 

[Alvin Bruney [ASP.NET MVP]]

I haven't found a working solution yet with Office 2007, not sure if anybody
else out there has had success.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[Chris]

Hi Alvin,

do you mean that you haven't found ANY solution working with Office/Excel
2007? I was wondering if I could use a connection other than ODBC...

Thanks,

Chris

I haven't found a working solution yet with Office 2007, not sure if anybody
else out there has had success.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hello,

I have the following configuration:
- SharePoint 2003 on the server with the Office Web parts installed
- Office 2007 (Excel, etc.) and OWC11 on my computer.

I want to use the PivotChart Web Part and ODBC to connect to named ranges
in
Excel. It works perfectly for computers with Office/Excel 2003 installed,
but
I get an error when I try the same with Office/Excel 2007.

Thanks for your help!

 

[Alvin Bruney [ASP.NET MVP]]

That's right.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hi Alvin,

do you mean that you haven't found ANY solution working with Office/Excel
2007? I was wondering if I could use a connection other than ODBC...

Thanks,

Chris

I haven't found a working solution yet with Office 2007, not sure if
anybody
else out there has had success.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hello,

I have the following configuration:
- SharePoint 2003 on the server with the Office Web parts installed
- Office 2007 (Excel, etc.) and OWC11 on my computer.

I want to use the PivotChart Web Part and ODBC to connect to named
ranges
in
Excel. It works perfectly for computers with Office/Excel 2003
installed,
but
I get an error when I try the same with Office/Excel 2007.

Thanks for your help!

 

[Chris]

Hi Alvin,

I was finally able to get my ODBC connection with an Excel 2007 named range.
To make it work I had to:
- only use named ranges of finite length. For example A1:F300 would work but
not $A:$F.
- modify some security settings in Excel (trust center) and IE. Not sure
exactly which ones did the trick.

Chris

That's right.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hi Alvin,

do you mean that you haven't found ANY solution working with Office/Excel
2007? I was wondering if I could use a connection other than ODBC...

Thanks,

Chris

I haven't found a working solution yet with Office 2007, not sure if
anybody
else out there has had success.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------



Hello,

I have the following configuration:
- SharePoint 2003 on the server with the Office Web parts installed
- Office 2007 (Excel, etc.) and OWC11 on my computer.

I want to use the PivotChart Web Part and ODBC to connect to named
ranges
in
Excel. It works perfectly for computers with Office/Excel 2003
installed,
but
I get an error when I try the same with Office/Excel 2007.

Thanks for your help!

 

[Alvin Bruney [ASP.NET MVP]]

Hey thanks for posting this.

--
--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

Hi Alvin,

I was finally able to get my ODBC connection with an Excel 2007 named
range.
To make it work I had to:
- only use named ranges of finite length. For example A1:F300 would work
but
not $A:$F.
- modify some security settings in Excel (trust center) and IE. Not sure
exactly which ones did the trick.

Chris

That's right.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hi Alvin,

do you mean that you haven't found ANY solution working with
Office/Excel
2007? I was wondering if I could use a connection other than ODBC...

Thanks,

Chris

:

I haven't found a working solution yet with Office 2007, not sure if
anybody
else out there has had success.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------



Hello,

I have the following configuration:
- SharePoint 2003 on the server with the Office Web parts installed
- Office 2007 (Excel, etc.) and OWC11 on my computer.

I want to use the PivotChart Web Part and ODBC to connect to named
ranges
in
Excel. It works perfectly for computers with Office/Excel 2003
installed,
but
I get an error when I try the same with Office/Excel 2007.

Thanks for your help!