Hello,
ProClarity 6.1 is only supported with the following Office versions:
Microsoft Office 2000, SR1
Microsoft Office XP
Microsoft Office 2003
That being said, you may run into issues exporting ProClarity views to Office 2007, however this is something I have not tested and do not know for certain. If you run into problems with it you won't be able to gain support being that it is not a supported configuration.
In regards to your second inquiry; Yes, you will need ProClarity to access briefing books, members/sets, etc. Excel 2007 allows you to analyze data via its PivotTable reports feature but it will not allow you to connect to existing ProClarity data.
HTH
Regards,
Amanda