Hello.

Our Ops department here would like to take advantage of the dynamic
capabilities of Pivot Tables and Pivot Charts, in order to present Load vs.
Capacity planning data.

The Load dea is in an Oracle database, and the Capacity data is in an Excel
worksheet.

Is there a way to get those two sources into the same Pivot Table? We could
load the capacity data into the database, of course, but Ops would like to
retain the flexibility of the what-if capabilities of Excel.

Conversely, we could potentially summarize the database data enough to fit
into an Excel worksheet's row count, but, not as much detail would as desired
would be possible on that side.

Thanks for any suggestions.