I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.

Eison,

Check out Debra's Dalgleish's site at www.contextures.com



"Eison" wrote:

I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.

I did, and downloaded the example, tried out the code and it errored out
(1004). Maybe it has something to do with the fact the table is based off a
cube?? Like the site, thanks for the tip.

"Dominic" wrote:

Eison,

Check out Debra's Dalgleish's site at www.contextures.com



"Eison" wrote:

I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.

No problem.

I just ran a quick search on the newsgroup for error code 1004 and it seems
to occur a lot during macros when you're trying to do something that doesn't
exist (paste, etc., when there's nothing on the clipboard).

Maybe you're trying to find data (pivots) that don't exist? Did you check
your names real good?

HTH



"Eison" wrote:

I did, and downloaded the example, tried out the code and it errored out
(1004). Maybe it has something to do with the fact the table is based off a
cube?? Like the site, thanks for the tip.

"Dominic" wrote:

Eison,

Check out Debra's Dalgleish's site at www.contextures.com



"Eison" wrote:

I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.

Double checked, they exist. Using OLAP to query database then create table,
maybe it has something to do with it. I can do what I need in the database,
but I don't get to decide how to make the reports, just have to make what the
boss wants happen.

"Dominic" wrote:

No problem.

I just ran a quick search on the newsgroup for error code 1004 and it seems
to occur a lot during macros when you're trying to do something that doesn't
exist (paste, etc., when there's nothing on the clipboard).

Maybe you're trying to find data (pivots) that don't exist? Did you check
your names real good?

HTH



"Eison" wrote:

I did, and downloaded the example, tried out the code and it errored out
(1004). Maybe it has something to do with the fact the table is based off a
cube?? Like the site, thanks for the tip.

"Dominic" wrote:

Eison,

Check out Debra's Dalgleish's site at www.contextures.com



"Eison" wrote:

I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.

After doing some testing, the code works if i dont use OLAP, however, with
the number of records being polled from the database, the pivot will error,
but using the cube the code gives the 1004 error.... Strange.

"Eison" wrote:

I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.