This Blog

Home
About

Syndication

News

this is Rebecca's profile

Awesome List of Bloggers

Becky's Blog

This is Becky Isserman's Blog about her Sharepoint blunders and successes. She is an Admin/Developer at Terracon Consulting Firm in the Kansas City Area.
This blog has been moved to http://www.mosslover.com.

Export to Spreadsheet XSLT View Issue

I am working on a really bizarre issue that occurred right after I installed SP1 for WSS 3.0 and MOSS. Basically, Export to Spreadsheet works in a regular document library or regular document library webpart, however when I use an XSLT view or create a custom menu item using Sharepoint:ActionsMenu I get an "Unexpected error has occurred. Changes to your data cannot be saved." Every other menu item in XSLT view or on the custom menu works properly. If anyone can shed light on this issue please let me know. I am going to continue to look around for a solution and if I find one I will post it.

Published Dec 17 2007, 12:26 PM by MOSSLover

Filed under: MOSS 2007, Document Libraries, Excel

Comments

MOSSLover said:

I didn't get it to work fully, however now it has decided to display the id in the spreadsheet and nothing else.

December 18, 2007 8:20 AM

JoeD said:

I'm having the same problem. I am using Excel 2007 and I get two columns in the spreadsheet - Item Type and Path. Item Type is "Item" for every row and the Path column has a relative path name to the list itself. Useless.

Instead of opening the .iqy file it generates in Excel, I saved it to a file, then used the Sharepoint List View and saved the .iqy from it (the one that works) and compared them.

The only differences are three lines - the third line that has a URL, the Selection= line and the SharePointListView= line.

The differences on each of those lines is a GUID, and I'm not sure where it is getting that GUID.

March 15, 2008 9:37 PM

Name (required )

Your URL (optional )

Comments (required )

Remember Me?

Add

About MOSSLover

I am a Sharepoint and .Net Consultant working for a company based in the Kansas City Metro Area. I have been working Sharepoint since July 2005. I love to play World of Warcraft and discuss all things Sharepoint.

Need SharePoint Training? Attend a SharePoint Bootcamp!

SharePoint Blogs