D
Debra Dalgleish
How did you create the pivot table? Where is the source data?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Merlin
The data is in the same spreadsheet. Created using the Pivot Table Wizard.
D
Debra Dalgleish
What version of Excel are you using?
If you run the macro shown here:
http://www.contextures.com/xlPivot03.html#Hide97
does it hide the items in the Row fields?
If you run the macro shown here:
http://www.contextures.com/xlPivot03.html#Hide97
does it hide the items in the Row fields?
M
Merlin
Hi,
I have come across a problem using pivot tables.
After creating the pivot table I select a filter drop down
but it will not let me edit any of the checkboxes.
I have tried numerous spreadsheets and even re-installed
excel to no avail.
I have search the web and can find no reference to this problem.
There is no protection on the spreadsheet and on another
machine it works fine.
Has anyone seen this before and / or can suggest a solution.
Kind Regards,
Mark
I have come across a problem using pivot tables.
After creating the pivot table I select a filter drop down
but it will not let me edit any of the checkboxes.
I have tried numerous spreadsheets and even re-installed
excel to no avail.
I have search the web and can find no reference to this problem.
There is no protection on the spreadsheet and on another
machine it works fine.
Has anyone seen this before and / or can suggest a solution.
Kind Regards,
Mark
M
Merlin
Thanx Debra,
The problem is back at the office so will test on Monday and let you know.
Regards,
Mark.
The problem is back at the office so will test on Monday and let you know.
Regards,
Mark.
D
Dave Peterson
Ahem. Note the subject.
CQC (junior member)
CQC (junior member)
Debra said:What version of Excel are you using?
If you run the macro shown here:
http://www.contextures.com/xlPivot03.html#Hide97
does it hide the items in the Row fields?
D
Debra Dalgleish
Oops! Who knew that you had to read the subject lines too?
Dave said:Ahem. Note the subject.
CQC (junior member)
D
Debra Dalgleish
There isn't a Show All checkbox in Excel 2000. The macro doesn't add the
checkbox, it just adds a check mark to each item in the list.
Your home machine must have Excel 2002 or Excel 2003 -- those versions
do have the Show All checkbox.
In your initial post, you wrote "it will not let me edit any of the
checkboxes". Did you mean that you can't check or uncheck any of the
items, or did you mean something different?
checkbox, it just adds a check mark to each item in the list.
Your home machine must have Excel 2002 or Excel 2003 -- those versions
do have the Show All checkbox.
In your initial post, you wrote "it will not let me edit any of the
checkboxes". Did you mean that you can't check or uncheck any of the
items, or did you mean something different?
D
Debra Dalgleish
Magic? <g>
Thanks for letting me know that you got it working.
Thanks for letting me know that you got it working.
M
Merlin
Hi Debra,
I have tried that macro and yes it does hide all the items in the Row
Fields.
I also tried your Showall macro but it did not add the Showall checkbox
on this machine. It did one my home machine.
For what it is worth (as I am not sure this helps at all) I tried opening
the spreadsheet
in Internet Explorer and it all works fine. I discovered this because I
opened you
sample pivot sales in my browser and it worked.
As I say, don't know it that provides any pointers to the problem but it
might.
I have also tried opening Excel in safe mode and the problem remains.
This is a bizarre and very annoying problem.
Regards,
Mark.
I have tried that macro and yes it does hide all the items in the Row
Fields.
I also tried your Showall macro but it did not add the Showall checkbox
on this machine. It did one my home machine.
For what it is worth (as I am not sure this helps at all) I tried opening
the spreadsheet
in Internet Explorer and it all works fine. I discovered this because I
opened you
sample pivot sales in my browser and it worked.
As I say, don't know it that provides any pointers to the problem but it
might.
I have also tried opening Excel in safe mode and the problem remains.
This is a bizarre and very annoying problem.
Regards,
Mark.
Debra Dalgleish said:Oops! Who knew that you had to read the subject lines too?
M
Merlin
Hey Debra,
All is OK. Don't ask how but this is what I did.
I opened one of your samples in a browser then saved it to the desktop.
I then opened it in Excel and the pivot checkboxes worked. Hmmm, me thinks,
why is that?
Opened my existing spreadsheet and checkboxes there
all work to.
Thanx for you help.
Cheers,
Mark
All is OK. Don't ask how but this is what I did.
I opened one of your samples in a browser then saved it to the desktop.
I then opened it in Excel and the pivot checkboxes worked. Hmmm, me thinks,
why is that?
Opened my existing spreadsheet and checkboxes there
all work to.
Thanx for you help.
Cheers,
Mark
Debra Dalgleish said:Oops! Who knew that you had to read the subject lines too?