software

How do I restore my complete data set for a pivot table? I have a table that
has a grouping at the top (say group quot;Aquot;), a series at the right which are my
pivot table columns (1,2,3,...20), and data at the bottom which are my rows
(a city listing). Whenever I change the quot;dataquot; selection at the bottom, the
other selections disappear and I cannot get them back unless I undo. How do
I move the selections around but still have access to my original data set?

Andrew C

I'm not sure I follow you completely, but try double clicking the gray areas
that represent the data that you want to restore. It should pop up a box
with a list of all of your items and you can click on them to unhide. Or you
could try moving the data to the quot;topquot; (page field) and then choosing quot;(All)quot;
before moving it back.

quot;Andrew Cquot; wrote:

gt; How do I restore my complete data set for a pivot table? I have a table that
gt; has a grouping at the top (say group quot;Aquot;), a series at the right which are my
gt; pivot table columns (1,2,3,...20), and data at the bottom which are my rows
gt; (a city listing). Whenever I change the quot;dataquot; selection at the bottom, the
gt; other selections disappear and I cannot get them back unless I undo. How do
gt; I move the selections around but still have access to my original data set?
gt;
gt; Andrew C

Thanks for the help, and I'll try to explain myself better.

My pivot table has letters/numbers going across for the COLUMNS. The PAGE
is by vendor. Both of these I can hide and unhide and select without the
original selections disappearing. However, my data ROWS are another matter.
When I de-select ALL on my data rows on the table ( or data at the bottom of
the chart) and click on one or several check boxes, I get those selections.
When I click on the data box though to make other selections or all again,
the previous choices and selections I had are gone. It is like if I reduce
my data set, I cannot expand it again. Any help would be appreciated as I
feel like I'm missing something basic but just can't figure out what is.

--
Andrew Cquot;JAdamJquot; wrote:

gt; I'm not sure I follow you completely, but try double clicking the gray areas
gt; that represent the data that you want to restore. It should pop up a box
gt; with a list of all of your items and you can click on them to unhide. Or you
gt; could try moving the data to the quot;topquot; (page field) and then choosing quot;(All)quot;
gt; before moving it back.
gt;
gt; quot;Andrew Cquot; wrote:
gt;
gt; gt; How do I restore my complete data set for a pivot table? I have a table that
gt; gt; has a grouping at the top (say group quot;Aquot;), a series at the right which are my
gt; gt; pivot table columns (1,2,3,...20), and data at the bottom which are my rows
gt; gt; (a city listing). Whenever I change the quot;dataquot; selection at the bottom, the
gt; gt; other selections disappear and I cannot get them back unless I undo. How do
gt; gt; I move the selections around but still have access to my original data set?
gt; gt;
gt; gt; Andrew C

Sorry I misunderstood.

When you deselect fields in the data drop down then they are removed from
the pivot table (as you discovered). Don't worry, they have not been
forgotten. You can right click in the table and select Show Field List. The
field list will contain the fields that were removed. You can add them back
to the data area here. Or, when you right click you can choose Pivot Table
Wizard and then click the Layout button and add your fields back there.

Hope this helps.

quot;Andrew Cquot; wrote:

gt; Thanks for the help, and I'll try to explain myself better.
gt;
gt; My pivot table has letters/numbers going across for the COLUMNS. The PAGE
gt; is by vendor. Both of these I can hide and unhide and select without the
gt; original selections disappearing. However, my data ROWS are another matter.
gt; When I de-select ALL on my data rows on the table ( or data at the bottom of
gt; the chart) and click on one or several check boxes, I get those selections.
gt; When I click on the data box though to make other selections or all again,
gt; the previous choices and selections I had are gone. It is like if I reduce
gt; my data set, I cannot expand it again. Any help would be appreciated as I
gt; feel like I'm missing something basic but just can't figure out what is.
gt;
gt; --
gt; Andrew C
gt;
gt;
gt; quot;JAdamJquot; wrote:
gt;
gt; gt; I'm not sure I follow you completely, but try double clicking the gray areas
gt; gt; that represent the data that you want to restore. It should pop up a box
gt; gt; with a list of all of your items and you can click on them to unhide. Or you
gt; gt; could try moving the data to the quot;topquot; (page field) and then choosing quot;(All)quot;
gt; gt; before moving it back.
gt; gt;
gt; gt; quot;Andrew Cquot; wrote:
gt; gt;
gt; gt; gt; How do I restore my complete data set for a pivot table? I have a table that
gt; gt; gt; has a grouping at the top (say group quot;Aquot;), a series at the right which are my
gt; gt; gt; pivot table columns (1,2,3,...20), and data at the bottom which are my rows
gt; gt; gt; (a city listing). Whenever I change the quot;dataquot; selection at the bottom, the
gt; gt; gt; other selections disappear and I cannot get them back unless I undo. How do
gt; gt; gt; I move the selections around but still have access to my original data set?
gt; gt; gt;
gt; gt; gt; Andrew C

That does work to a degree. However, all of the formatting and row names
have to be re-done if I want to add back the data fields from the wizard
(gives it names of sum of XXX, count of XXXX). Also, if I add the rows back
with the Show Field List it adds not data rows back, but columns and the
table just turns into a mess. I appreciate your help but I know I'm missing
something or forgot something as I haven't run into this problem before.
--
Andrew Cquot;JAdamJquot; wrote:

gt; Sorry I misunderstood.
gt;
gt; When you deselect fields in the data drop down then they are removed from
gt; the pivot table (as you discovered). Don't worry, they have not been
gt; forgotten. You can right click in the table and select Show Field List. The
gt; field list will contain the fields that were removed. You can add them back
gt; to the data area here. Or, when you right click you can choose Pivot Table
gt; Wizard and then click the Layout button and add your fields back there.
gt;
gt; Hope this helps.
gt;
gt; quot;Andrew Cquot; wrote:
gt;
gt; gt; Thanks for the help, and I'll try to explain myself better.
gt; gt;
gt; gt; My pivot table has letters/numbers going across for the COLUMNS. The PAGE
gt; gt; is by vendor. Both of these I can hide and unhide and select without the
gt; gt; original selections disappearing. However, my data ROWS are another matter.
gt; gt; When I de-select ALL on my data rows on the table ( or data at the bottom of
gt; gt; the chart) and click on one or several check boxes, I get those selections.
gt; gt; When I click on the data box though to make other selections or all again,
gt; gt; the previous choices and selections I had are gone. It is like if I reduce
gt; gt; my data set, I cannot expand it again. Any help would be appreciated as I
gt; gt; feel like I'm missing something basic but just can't figure out what is.
gt; gt;
gt; gt; --
gt; gt; Andrew C
gt; gt;
gt; gt;
gt; gt; quot;JAdamJquot; wrote:
gt; gt;
gt; gt; gt; I'm not sure I follow you completely, but try double clicking the gray areas
gt; gt; gt; that represent the data that you want to restore. It should pop up a box
gt; gt; gt; with a list of all of your items and you can click on them to unhide. Or you
gt; gt; gt; could try moving the data to the quot;topquot; (page field) and then choosing quot;(All)quot;
gt; gt; gt; before moving it back.
gt; gt; gt;
gt; gt; gt; quot;Andrew Cquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; How do I restore my complete data set for a pivot table? I have a table that
gt; gt; gt; gt; has a grouping at the top (say group quot;Aquot;), a series at the right which are my
gt; gt; gt; gt; pivot table columns (1,2,3,...20), and data at the bottom which are my rows
gt; gt; gt; gt; (a city listing). Whenever I change the quot;dataquot; selection at the bottom, the
gt; gt; gt; gt; other selections disappear and I cannot get them back unless I undo. How do
gt; gt; gt; gt; I move the selections around but still have access to my original data set?
gt; gt; gt; gt;
gt; gt; gt; gt; Andrew C

The data area doesn't work the way you want it to. You either need to figure
out a way to make it a column, row, or page field, or you could do what you
want using vba. If you're not familiar with vba, then I wouldn't suggest
attempting this type of thing as your first try. Sorry I haven't been able
to help. Perhaps someone else will.

quot;Andrew Cquot; wrote:

gt; That does work to a degree. However, all of the formatting and row names
gt; have to be re-done if I want to add back the data fields from the wizard
gt; (gives it names of sum of XXX, count of XXXX). Also, if I add the rows back
gt; with the Show Field List it adds not data rows back, but columns and the
gt; table just turns into a mess. I appreciate your help but I know I'm missing
gt; something or forgot something as I haven't run into this problem before.
gt; --
gt; Andrew C
gt;
gt;
gt; quot;JAdamJquot; wrote:
gt;
gt; gt; Sorry I misunderstood.
gt; gt;
gt; gt; When you deselect fields in the data drop down then they are removed from
gt; gt; the pivot table (as you discovered). Don't worry, they have not been
gt; gt; forgotten. You can right click in the table and select Show Field List. The
gt; gt; field list will contain the fields that were removed. You can add them back
gt; gt; to the data area here. Or, when you right click you can choose Pivot Table
gt; gt; Wizard and then click the Layout button and add your fields back there.
gt; gt;
gt; gt; Hope this helps.
gt; gt;
gt; gt; quot;Andrew Cquot; wrote:
gt; gt;
gt; gt; gt; Thanks for the help, and I'll try to explain myself better.
gt; gt; gt;
gt; gt; gt; My pivot table has letters/numbers going across for the COLUMNS. The PAGE
gt; gt; gt; is by vendor. Both of these I can hide and unhide and select without the
gt; gt; gt; original selections disappearing. However, my data ROWS are another matter.
gt; gt; gt; When I de-select ALL on my data rows on the table ( or data at the bottom of
gt; gt; gt; the chart) and click on one or several check boxes, I get those selections.
gt; gt; gt; When I click on the data box though to make other selections or all again,
gt; gt; gt; the previous choices and selections I had are gone. It is like if I reduce
gt; gt; gt; my data set, I cannot expand it again. Any help would be appreciated as I
gt; gt; gt; feel like I'm missing something basic but just can't figure out what is.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Andrew C
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;JAdamJquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I'm not sure I follow you completely, but try double clicking the gray areas
gt; gt; gt; gt; that represent the data that you want to restore. It should pop up a box
gt; gt; gt; gt; with a list of all of your items and you can click on them to unhide. Or you
gt; gt; gt; gt; could try moving the data to the quot;topquot; (page field) and then choosing quot;(All)quot;
gt; gt; gt; gt; before moving it back.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Andrew Cquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; How do I restore my complete data set for a pivot table? I have a table that
gt; gt; gt; gt; gt; has a grouping at the top (say group quot;Aquot;), a series at the right which are my
gt; gt; gt; gt; gt; pivot table columns (1,2,3,...20), and data at the bottom which are my rows
gt; gt; gt; gt; gt; (a city listing). Whenever I change the quot;dataquot; selection at the bottom, the
gt; gt; gt; gt; gt; other selections disappear and I cannot get them back unless I undo. How do
gt; gt; gt; gt; gt; I move the selections around but still have access to my original data set?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Andrew C