You do have SP1 based on that version number, and I am not aware of any hotfixes published subsequently that deal with Excel export issues. Access pivots have never been as useful as what you can do in Excel, but in this case, does it appear the pivot is behaving as it should? You can determine if the tables are linked by holding down the SHIFT key as you open the database and then look at the tables and see if they show a globe symbol indicating they are ODBC linked tables. Have you tried copying and pasting the pivot result into Excel directly rather than trying to export it?

It seems unlikely that joins in the SQL Server view would cause issues with the pivot unless there are a great many records. How many records does the view return?