If you are using WSS and not MOSS, you’ll notice there’s no RSS feed.

This needs to be created manually.

Use the XML Editor web part:

In the XML Link, put in the RSS url.

In the XSL Editor, put in the XML. Something like this:

This is good, has it’s limited to 5 items and opens a new window.