Update Multiple List Items at the same time

I have a custom list that has several fields and about 75 rows. One of
the fields is updated by a single user and usually when she is ready to
update that field she needs to update it for most of the 75 rows...ie
about 65 of them and then the rest at a later date. If possible she
would like to be able to update all of the rows at once without having
to go into each item and click edit and so forth. I am not sure that
it is possible to do this. Does anyone have any experience with this?

Thank you!
JED

Ian
Mon Nov 14 16:39:52 CST 2005

Hi,
You can link the list to Access 2003 and then run an Update Query.
I have done this and found it to save a lot of time.
Here is a video of doing something similar with Access against SharePoint...
http://xpstream.winisp.net/imorrish

Regards,
Ian,
http://www.wssdemo.com

"JED" <jbyrd76@hotmail.com> wrote in message
news:1132002339.530001.232560@g43g2000cwa.googlegroups.com...
>I have a custom list that has several fields and about 75 rows. One of
> the fields is updated by a single user and usually when she is ready to
> update that field she needs to update it for most of the 75 rows...ie
> about 65 of them and then the rest at a later date. If possible she
> would like to be able to update all of the rows at once without having
> to go into each item and click edit and so forth. I am not sure that
> it is possible to do this. Does anyone have any experience with this?
>
> Thank you!
> JED
>

Sven
Tue Nov 15 01:42:04 CST 2005

Hi,

You can also use the 'edit in datasheet view' feature, that will
display your list in an Exel like view. The person will need to modify
each row but she wont have to press edit, wait for detail to load,
modify and then save for each item.

Sven

JED
Tue Nov 15 17:25:47 CST 2005

Thank you all for the replies! JED