Excel 2007 and Sharepoint 2003 list issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UKDeluded - 11 Jan 2008 10:56 GMT

Hi, this is a strange one. In initial tests when we used Excel 2007 to edit a
datasheet from Sharepoint 2003 (2003 list, link to excel) we had no problem.

We have now imaged the build and rolled out to the organisation, only now it
fails without giving an error when you try to edit the 2003 list in Excel
2007.

Anyone got any idea why it might be unable to do this?

Thanks!

Reply to this Message

Jim Cone - 11 Jan 2008 12:01 GMT

Sounds like you choose an appropriate name <g> ...
From: http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx

Writeback to SharePoint (Eric Patterson - Microsoft) August 2006...
Excel 2003 added the ability to connect to (read) and update (write)
to lists that reside on SharePoint sites.
Moving forward we are focusing our efforts on Access as the best way for
writing data to lists on SharePoint and taking SharePoint lists offline.

For Excel we are deprecating the update behavior in the following ways:
* Existing files from Excel 2003 will load and continue to support update
functionality when opened in Excel 2007.
* Lists linked to SharePoint will be converted to read-only Tables when
existing files are saved to the new Excel 12 file formats.
* It is still possible to “publish” a Table to SharePoint,
however this is a one-time write to SharePoint.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"UKDeluded"
wrote in message
Hi, this is a strange one. In initial tests when we used Excel 2007 to edit a
datasheet from Sharepoint 2003 (2003 list, link to excel) we had no problem.
We have now imaged the build and rolled out to the organisation, only now it
fails without giving an error when you try to edit the 2003 list in Excel
2007.
Anyone got any idea why it might be unable to do this?
Thanks!

Reply to this Message