Publish to Excel Question

Question

Hi,

Using Excel 2010 and SP 2010.  Can save to SharePoint just fine by going File -> Save to SharePoint and the libraries I added via "Connect to Office" show just fine.

I can save a Excel file there and open it up via Browser or via Excel itself.

However, when I try to Publish to Excel Services, I cannot seem to connect to the document libraries.  Nothing shows up under "SharePoint Sites" and if I try to type in the path to the document libarary (e.g., http://servername/sitename/libraryname) it says the Path does not exist.

Any thoughts as to what I am missing here?

Alan 

---

My Ramblings @ http://alanwhitehouse.wordpress.com

Answer 1

I have run into this issue with Access 2010 and SharePoint 2010.  Please check the following:

Is Excel Services (available with Enterprise liscense, or what ever it is called in 2010) is enabled for your SharePoint FARM? (Central Admin? anyone?)

Is Excel Services enabled for your SharePoint Site Collection?

If you want to "publish" the Excel file, I don't think you want to publish it to a doc library.  As I understand it (at least in the case of Access 2010) the publish moves the spreadsheet or DB to a newly created Web Access site/sub-site.

I have yet to get my Access DB to publish successfully to SharePoint due to a very similar error message.

---

Tamara Bredemus SharePoint Minion...working up to Maven

Answer 2

Just to test, I accessed the SharePoint site from a client running Excel 2007 and was able to publish.  So there is something with Excel 2010 and SP 2010 I am missing.

---

My Ramblings @ http://alanwhitehouse.wordpress.com

Answer 3

I can't tell here exactly what you're having issues with. Can you upload an XLS to a document library and then access it using Excel Services (so avoiding the Excel client)? And can you use the Excel Client to upload to any other document library?

Which are you having trouble with?

Cheers,
Paul

---

SharePoint Product Manager. Posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

I can save to the document library no problem.  What I can't do is use the publish to excel services feature from Excel 2010.  It doesn't "see" sharepoint at all.

---

My Ramblings @ http://alanwhitehouse.wordpress.com

Answer 5

Hi Alan,

Yes, I did ran into similar issue.   Please add the Document Library to Trusted File locations - Central Administration | Manage Service Application | Excel Services | Manage | Trusted File Locations.   I hope Excel Calculation Services is started in Central Administration | Manage Services on the Server

Thank you,
Sundar - MSFT

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

Library was already added and the service is started.

Since I can publish with Excel 2007, this must be something to do with Excel 2010.

The only difference is Excel 2007 is on my laptop while Excel 2010 is running on the server along with SharePoint 2010.

---

My Ramblings @ http://alanwhitehouse.wordpress.com

Answer 7

Alan,

Could it be a WebDAV issue? I experience the same problem with my Office and SharePoint 2007 while running on Windows Server 2008.
I can't even open the Explorer View of a library and giving me the 'Your Browser Doesn't Support...' message.

grtz,
Octavie

Answer 8

I wondwer how you got the save to SharePoint to work.
I tried on 2 different Machines and any http://xxxx location is a wrong path for it.
Do I need to set something up first in office?

---

Ofer

Answer 9

I actually figured out my issue.   I was running all on a test server running server 2008.   Once I installed Desktop Experience on the server it starting working.

---

My Ramblings @ http://alanwhitehouse.wordpress.com