Pivot Table Range ("Database")

  • Thread starter Thread starter Helen2245
  • Start date Start date
H

Helen2245

If you build a pivot table in Excel 97-2000 when a cell inside the database
you want to use is selected, the pivot wizard will assume that you want to
use that whole database for your pivot table (without you having to specify
the range)

I'm now using 2003 and it won't do it anymore. Is there something wrong
with my settings?

Many thanks

Helen
 
I do not know of anything that changed with respect to how XL makes it best
guess at the intended range for pivot table source data. Normally if it is
not selecting the correct data it is because there is some kind of ambiguity
in the data that makes XL not understand what you want to do. Changes from
text to number half way though and such can make XL not understand the source
data...

FYI the Pivot Table engine did change in XL2002 so pivot tables themselves
are a bitt different starting with XP...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Dynamic data ranges in pivot tables 3
Pivot tables - memory issues - please help 2
Pivot Table Ranges 8
Excel 2007 pivot table source table 1
Pivot Table Wizard Fails to Recognize New Rows of Database 2
Pivot table wizards 2
Pivot Table - Changes 5

Back
Top