Re: Creating a PivotTable w/o selecting data in an existing PivotT

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I still encounter the same issue when I do this. In step one I choose
"Microsoft Office Excel list or database" but when I hit Next after selecting
my data range it brings up a list of PT's to choose from as if I chose
"Another PT report or PC report" in step one. If I hit back at this window it
brings me back to step one and now "Another PT report or PC report" is
selected.

Thanks again for all of your help Roger.

-Damian

"Roger Govier" wrote:

Hi Damian

Yes you can.
Select any cell in your source data range>Data>Pivot Table>Next>enter any
other valid range that you wish>Layout>set which fields are to appear in
which sections>Finish

--
Regards
Roger Govier



"Damian" <Damian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C095D7A0-5662-4EF2-90DB-7D7B14ED83DF@xxxxxxxxxxxxxxxx
Roger,

Thanks for the quick response. I appreciate your help. I do understand
that
doing this will target the data used to create the first PT, and not the
PT
itself, but I need to use a different range of data in this second table.
Is
there any way I can get my machine to allow this?

Thanks again,

-Damian

"Roger Govier" wrote:

Hi Damian

Although the wizard shows the PT Name, if you read the first line of the
dialogue box, it says
"Which Pivot table report contains the data you want to use?"

It will refer back to the source data for that PT, not to the PT itself
and
will save memory as opposed to creating a new PT from a given source data
range.

--
Regards
Roger Govier



"Damian" <Damian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C79DBAA-A583-4617-8F40-6006B22ACF24@xxxxxxxxxxxxxxxx
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.






.

Relevant Pages

  • Re: Can Grow for object based on function (AC2003)
    ... The functions simply concatenate data from other fields in the underlying data source, ... The text boxes don't "grow" when the report is previewed. ... I guess there's something strange going on in this report. ... I also copied the report and revised it to use a data source that was in the Access database (not from Excel) and got the same result. ...
    (microsoft.public.access.reports)
  • RE: Open form in another program
    ... export it to Excel. ... Right click on any report and hit Export. ... we only have the standard office software. ...
    (microsoft.public.access.forms)
  • Re: Can Grow for object based on function (AC2003)
    ... The functions simply concatenate data from other fields in the underlying data source, ... The text boxes don't "grow" when the report is previewed. ... I guess there's something strange going on in this report. ... I also copied the report and revised it to use a data source that was in the Access database (not from Excel) and got the same result. ...
    (microsoft.public.access.reports)
  • Re: reporting using SQL Server security
    ... Use a connection string that allows access to the data in the report. ... If you only want certain people to be able to hit the site, ... I tried populating a dataset and supplying the datatable to the report with LocalReport.DataSources.Add method, but the report requires a datasource instance and I get errors before I can add the data table as a data source. ... I used a stored procedure to create the dataset the report is based on, and it tries to load the report at runtime with the original dataset, but I get login errors or errors like "a data source instance has not been supplied..." ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Excel 2000...wont save printer settings
    ... settings with each report, why does Excel 2000 not allow ... >My Excel Pages: ...
    (microsoft.public.excel.setup)