No. A working internet connection should suffice if the library is reachable from an external network.

Imagine you were using a Tabular server instead of PowerPivot with a total size of...

You need to have a working connection to the SharePoint library where your PowerPivot workbook is stored.

Screenshot?

Also take a look at this blog post of mine:

What’s the deal with Excel & SSIS?

It covers most of the common issues with Excel and SSIS.

scotsditch (11/13/2013)

---

Thanks for getting back to me so quickly on this. The subqueries are correlated subqueries, and the Select Sum([Accepted Calls]) has a from clause. I've underlined it...

Integrated logging in SSISDB? Easier automation with TSQL and powershell?

Parameters combined with execute package tasks, which allow you...

samalex (11/12/2013)

---

I was coming in here to ask this exact same question, so I'm surprised your question from last year has no answers. So I'll reply to it which...

Beatrix Kiddo (11/13/2013)

---

Can this be used as a way to get access if you don't know any of the passwords? I definitely didn't give this guy access- he doesn't need...

Maybe you need to add some indexes to the tables. Do you have any index specified currently on any of the tables?

It's very hard to help you without the table...

You'll need that rendering option if you want to export to Excel 2003. Is that what you want?

Are you sure you are using SSRS 2012?

According to this article, you'd have to explicitly enable Excel 2003.

http://msdn.microsoft.com/en-us/library/dd255234.aspx

Is there no Excel 2007-2010 option?

Create, Modify, and Delete Standard Subscriptions (Reporting Services in Native Mode)

What did you select for render format?

Great article. This will sure come in handy if I ever have to set-up MSDTC.

Thanks!

First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

Secondly, developer is the same as enterprise feature-wise, so that...

Your subqueries are wrong. For example, (Select sum(c.[Accepted Calls]) doesn't have a FROM clause.

It might help if you provided table DDL, sample data and desired output.