I have a shared workbook in Excel 2007 (and it needs to stay in 2007) and the
rest of our staff that would simply need to view it are in Excel 2003 still.
Is there a user-requested report that can be created in 2003 to pull from the
shared workbook? Or any other ideas?

They simply need to view, not append/change.