Data Tables - Location

[Steve D]

In Excel 2000, must data tables (Data\Tables...) always be located on the
same worksheet tab as the source data? I want to put summary tables into a
separate worksheet (tab), but Excel won't let me do that.

Steve

[Max]

Looks that way, at least in Excel97 (my ver)
But we could always mirror the data tables (or parts thereof)
elsewhere (eg: another sheet) via simple link formulas
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Steve D" <sdrenker_(you_know_what_here)_media.sj.nec.com> wrote in message
news:ufhMsZfyFHA.3804@TK2MSFTNGP10.phx.gbl...
> In Excel 2000, must data tables (Data\Tables...) always be located on the
> same worksheet tab as the source data? I want to put summary tables into a
> separate worksheet (tab), but Excel won't let me do that.
>
> Steve
>
>

[Dave Peterson]

I thought that there was an option on one of the steps of the wizard that asked
where you want the pivottable.

It's on Step 3 in xl2003. And I think xl2k is the same. (My memory of xl97 is
fading, but I would have guessed that it was there in xl97, too.)



Max wrote:
>
> Looks that way, at least in Excel97 (my ver)
> But we could always mirror the data tables (or parts thereof)
> elsewhere (eg: another sheet) via simple link formulas
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "Steve D" <sdrenker_(you_know_what_here)_media.sj.nec.com> wrote in message
> news:ufhMsZfyFHA.3804@TK2MSFTNGP10.phx.gbl...
> > In Excel 2000, must data tables (Data\Tables...) always be located on the
> > same worksheet tab as the source data? I want to put summary tables into a
> > separate worksheet (tab), but Excel won't let me do that.
> >
> > Steve
> >
> >

--

Dave Peterson

[Dave Peterson]

Hmmmmm. Data|Table.

Never mind.

Thanks for the poke in the ribs from a Canadian.

Dave Peterson wrote:
>
> I thought that there was an option on one of the steps of the wizard that asked
> where you want the pivottable.
>
> It's on Step 3 in xl2003. And I think xl2k is the same. (My memory of xl97 is
> fading, but I would have guessed that it was there in xl97, too.)
>
> Max wrote:
> >
> > Looks that way, at least in Excel97 (my ver)
> > But we could always mirror the data tables (or parts thereof)
> > elsewhere (eg: another sheet) via simple link formulas
> > --
> > Rgds
> > Max
> > xl 97
> > ---
> > Singapore, GMT+8
> > xdemechanik
> > http://savefile.com/projects/236895
> > --
> > "Steve D" <sdrenker_(you_know_what_here)_media.sj.nec.com> wrote in message
> > news:ufhMsZfyFHA.3804@TK2MSFTNGP10.phx.gbl...
> > > In Excel 2000, must data tables (Data\Tables...) always be located on the
> > > same worksheet tab as the source data? I want to put summary tables into a
> > > separate worksheet (tab), but Excel won't let me do that.
> > >
> > > Steve
> > >
> > >
>
> --
>
> Dave Peterson

--

Dave Peterson

[Max]

Thanks for the Canadian poke <g> !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Clarification, as it might have been understood.
What was meant in the earlier response was
to concur with the OP that the data table needs
to be created all within the same sheet.
This appears to be a limitation.

The mirroring part comes after, i.e. to reproduce elsewhere
the data table (as created and working on that same sheet).

--- "Steven G. Drenker" wrote:

> Hi, Max. I tried that -- put a simple link to the
> Col and Row references
> on the "Results" tab. Didn't work.
>
> Steve

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Oops, line:
> Clarification, as it might have been understood.

should read:
> Clarification, as it might have been mis-understood.

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--