I am attempting to create a second PivotTable using the PivotTable Wizard and
need to use an Excel database as my data source. Each time I select the data
range and hit Next it gives me a list of PivotTables to choose from for my
data source. Excel should be giving me the option to create the table from an
existing table (as it is) to save memory or choose a new data source. If I
use another machine in the office it does give me this option. Is there any
way to get my computer to give me this option? I appreciate any help.