View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Creating a PivotTable w/o selecting data in an existing PivotTable

Is the same version of Excel on both machines?
Are you testing this on the same workbook?

Damian wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html