Profile Picture

Connecting to Excel Services for Data Causes error

Posted By Greg Corliss 10 Years Ago
Author
Message
Greg Corliss
sad Posted 10 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 21 Years Ago
Posts: 3, Visits: 1

We recently acquired and installed Nevron Charts for SharePoint 2010.

When I try to connect to an Excel workbook I get an error:
Error: Cannot connect to data source.  Error was:Exception has been thrown by the target of an invocation.

This is what I did to get to that point.

1. I added a nevron chart web part to a page.

2. In the configuration I put a link to my excel file that I want to reference (http://mysite.com/Shared%20Documents/test.xlsx)

3. Put in the range (A2:B54)

I had a rather involved spreadsheet with a lot of calculations and data and thought maybe I was trying to reference to much so I created a simple sheet with a date column and a currency column and pasted simple values in and saved it as test.xlsx and still no joy. The document is checked in, published as a major version and I am able to view it in excel services in the browser.

 

PS. The WYSIWYG tools on the forum here seem to be inop, using IE8.



Greg Corliss
Posted 10 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 21 Years Ago
Posts: 3, Visits: 1

I was able to get the range to work by creating a new named range that only spanned 2 columns. For some reason, named ranges that span a table don't work.

 



Nevron Support
Posted 10 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 11 hours ago
Posts: 2,994, Visits: 3,512

Hello Greg,

Can you please elaborate and send us a sample Excel spreadsheet (snapshot of the one you work with)?



Best Regards,
Nevron Support Team



Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 11 hours ago
Posts: 2,994, Visits: 3,512

Hello Greg,

You can take a look at the following KB topic: Create Chart by using Dynamic Named Range in Excel Services



Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic