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.