I can query the SQL view in Mgt. Studio and see all of the numbers.

Excel Pivot Tables work for views that are not using linked servers pointing to Oracle so....

It is either...

1. An Excel bug when connecting to this type of view--most likely

2. Excel requires a certain setup on the view and/or linked server in order to work properly

Does that make sense?