Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Vista-related issue? Export to Spreadsheet is read-only

  Asked By: Kris    Date: Nov 21    Category: Sharepoint    Views: 1998

I am running SPS and have a calendar on the home page. Using XP, I
have no problem exporting the calendar to an Excel spreadsheet, adding
items, and synchronizing the list back to SharePoint. However, when I
try to do the same from a Vista machine, I am able to export to a
spreadsheet, but I add a line and refresh the database, nothing
happens. When I try to save the spreadsheet, I get an error that
indicates the table is read-only. How do I overcome the read-only



6 Answers Found

Answer #1    Answered By: Jessi Sweet     Answered On: Nov 21

Are you running  different versions of Office on the two different
machines. I seem to remember that that is an issue  with Office 2007.
I think MS came up with a patch to restore this functionality. I
could be wrong about that. But start there.

Answer #2    Answered By: Kelvin Mckinney     Answered On: Nov 21

Office 2007 uses Access for 2-way editing instead of Excel.

Answer #3    Answered By: Gaurav Ghosh     Answered On: Nov 21

Here's some more data: Using XP and Excel 2003, I exported a
spreadsheet from a SharePoint Calendar webpart that I was able to
modify and update. I sent that spreadsheet  to a Vista user who was
also able to modify it and have it synchronize back  to SharePoint.
Therefore it sounds like it might be related to Bryan's comment. If
so, then can anyone direct me to the patch he mentioned? As for the
MS Access comment--our Vista images include MS Access, how does that
relate to the fact that a spreadsheet created in Vista with Excel 2007
come up as read-only?

Answer #4    Answered By: Alka Sarabhai     Answered On: Nov 21

The basic issue  is that for 2003 Excel is read-write and 2007 Excel is
read-only. In 2007, Access has replace Excel as the 2-way edit

Answer #5    Answered By: Eashan Nadkarni     Answered On: Nov 21

Office 2007 SP1 should have fixed the read-only issue  with Excel. I
haven't tested the RTM version, so I am not sure. I will ask one of our
power user trainers to verify.

Answer #6    Answered By: William Odom     Answered On: Nov 21

I don't understand. MOSS has the ability to export  a webpart, such as
a Calendar, to an Excel spreadsheet  and it functions properly. The
issue clearly (to me) is Vista-related.

Didn't find what you were looking for? Find more on Vista-related issue? Export to Spreadsheet is read-only Or get search suggestion and latest updates.