Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Pivot "row hide menu" keeps having items I don't have anymore!?!?

Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.

PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.

The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.

Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?

English is not my language but I hope I was clear enough to make you
understand what is my question!!!!

Thank you,
Ataru

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Pivot "row hide menu" keeps having items I don't have anymore!?!?

Try right-clicking within the pivot table and selecting Refresh Data

" wrote:

Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.

PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.

The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.

Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?

English is not my language but I hope I was clear enough to make you
understand what is my question!!!!

Thank you,
Ataru


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Pivot "row hide menu" keeps having items I don't have anymore!?!?

Done it!!! No way...here I found another post
http://groups.google.com/group/micro...f5ae5843cc04b7
with someone having the same problem but it was Office 97!!!
I am using Office 2003 and this error is still there....isn't it???
Tks,
Ataru


On Jan 4, 11:13 pm, Sean Timmons
wrote:
Try right-clicking within the pivot table and selecting Refresh Data



" wrote:
Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.


PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.


The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.


Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?


English is not my language but I hope I was clear enough to make you
understand what is my question!!!!


Thank you,
Ataru- Hide quoted text -- Show quoted text -


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Pivot "row hide menu" keeps having items I don't have anymore!

Perhaps so. I don't have 2003, so I couldn't verify that for you...

" wrote:

Done it!!! No way...here I found another post
http://groups.google.com/group/micro...f5ae5843cc04b7
with someone having the same problem but it was Office 97!!!
I am using Office 2003 and this error is still there....isn't it???
Tks,
Ataru


On Jan 4, 11:13 pm, Sean Timmons
wrote:
Try right-clicking within the pivot table and selecting Refresh Data



" wrote:
Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.


PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.


The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.


Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?


English is not my language but I hope I was clear enough to make you
understand what is my question!!!!


Thank you,
Ataru- Hide quoted text -- Show quoted text -



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Pivot "row hide menu" keeps having items I don't have anymore!

And even the code posted on Microsoft anyway doesn't solve the
problem...maybe that was written for O97 and not for O2003.
No solution!??!!?? I wonder why because that must be a common problem
people may have using the pivot table.
I wonder.....!
Ataru

On Jan 4, 11:31 pm, Sean Timmons
wrote:
Perhaps so. I don't have 2003, so I couldn't verify that for you...



" wrote:
Done it!!! No way...here I found another post
http://groups.google.com/group/micro...isc/browse_thr...
with someone having the same problem but it was Office 97!!!
I am using Office 2003 and this error is still there....isn't it???
Tks,
Ataru


On Jan 4, 11:13 pm, Sean Timmons
wrote:
Try right-clicking within the pivot table and selecting Refresh Data


" wrote:
Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.


PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.


The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.


Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?


English is not my language but I hope I was clear enough to make you
understand what is my question!!!!


Thank you,
Ataru- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Pivot "row hide menu" keeps having items I don't have anymore!?!?

In Excel 2002 and Excel 2003 you can programmatically change a setting
to prevent old items from appearing. There is sample code he

http://www.contextures.com/xlPivot04.html

wrote:
Done it!!! No way...here I found another post
http://groups.google.com/group/micro...f5ae5843cc04b7
with someone having the same problem but it was Office 97!!!
I am using Office 2003 and this error is still there....isn't it???
Tks,
Ataru


On Jan 4, 11:13 pm, Sean Timmons
wrote:

Try right-clicking within the pivot table and selecting Refresh Data



" wrote:

Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.


PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.


The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.


Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?


English is not my language but I hope I was clear enough to make you
understand what is my question!!!!


Thank you,
Ataru- Hide quoted text -- Show quoted text -





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Pivot "row hide menu" keeps having items I don't have anymore!?!?

Debra, thank you for the help...that is great. I still wonder why that
feature (for me a problem) is still there in Excel 2003.
Hope won't be in the next release.
Ataru

On Jan 5, 12:07 am, Debra Dalgleish wrote:
In Excel 2002 and Excel 2003 you can programmatically change a setting
to prevent old items from appearing. There is sample code he

http://www.contextures.com/xlPivot04.html





wrote:
Done it!!! No way...here I found another post
http://groups.google.com/group/micro...isc/browse_thr...
with someone having the same problem but it was Office 97!!!
I am using Office 2003 and this error is still there....isn't it???
Tks,
Ataru


On Jan 4, 11:13 pm, Sean Timmons
wrote:


Try right-clicking within the pivot table and selecting Refresh Data


" wrote:


Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.


PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.


The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.


Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?


English is not my language but I hope I was clear enough to make you
understand what is my question!!!!


Thank you,
Ataru- Hide quoted text -- Show quoted text ---

Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -- Show quoted text -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
items disappearing from pivot dropdown when not selected confused Excel Worksheet Functions 1 July 19th 06 02:42 PM
Pivot Table unable to Include Hidden Items In Subtotals TC319 Charts and Charting in Excel 0 February 24th 05 09:53 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 09:41 PM
Pivot Tables, can I use an external list to select data items? Brian Lofquist Excel Worksheet Functions 0 January 4th 05 07:43 PM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 02:01 AM


All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"