overlay sharepoint list with refreshed excel file

I've got a two-fold issue. I'd like to take an excel sheet within a
spreadsheet that gets updated/overlayed on a daily basis with the latest data
and update the sharepoint list without sharepoint thinking every item in the
list is new. The ultimate problem I'm trying to solve is to have alerts on
each item in the list, only when data values change, but sharepoint seems to
think the item changed when it really hasn't and alerts the user. What I
tried to do is keep the id field and just overlay the rest of the data in the
spreadsheet. Sharepoint saw that as a change and sent the alert. I need
to capture new list items from that spreadsheet and data changes to existing
list items. If there's a way to do this without having to write code?

Mike
Wed Jan 09 12:57:04 CST 2008

If you instead of making your changes in the spreadsheet and then
copying everything to the SharePoint list, create a SharePoint List from
the spreadsheet and make the changes in the SharePoint List version of
the information (perhaps in Datasheet View), you will get the result you
want.


Otherwise as far as I can see you *are* replacing everything in the
SharePoint List and it is reacting correctly to this.

P.S. WSS 2.0 or 3.0 / Excel 2003 or 2007 ??

Mike Walsh
WSS FAQ http://www.wssfaq.com
No private e-mail questions please

Deb wrote:
> I've got a two-fold issue. I'd like to take an excel sheet within a
> spreadsheet that gets updated/overlayed on a daily basis with the latest data
> and update the sharepoint list without sharepoint thinking every item in the
> list is new. The ultimate problem I'm trying to solve is to have alerts on
> each item in the list, only when data values change, but sharepoint seems to
> think the item changed when it really hasn't and alerts the user. What I
> tried to do is keep the id field and just overlay the rest of the data in the
> spreadsheet. Sharepoint saw that as a change and sent the alert. I need
> to capture new list items from that spreadsheet and data changes to existing
> list items. If there's a way to do this without having to write code?