How can I show all of the sheets in an Excel compatibility attachment

I am running Office 2007 Pro and when I receive an email attachment in Excel sent in compatibility mode it doesn’t show the additional sheets. Is there a switch somewhere?