Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
is this the pivot table I created for you?
No, it was created by the PC Guy. I was very happy with it but when I went to copy and paste new data into
if there is a problem I will help fix it
No, it was created by the PC Guy. I was very happy with it but when I went to copy and paste new data into it the summary number will not change. I tried refreshing it but it still wont update the total cell numbers to reflect 260 and 3 Converted in Column K. I will load it up for you.
which version of office do you have
Microsoft Excel 2010
i see what is hapening
you have filtered data
click on the pivot table
where it says row labels
click the little filter icon next to it
then click clear filter
the list will expand
and total will be 259
Where do I see the pivot table?
in row 3
it says row labels
glad I could help
was there anything else you needed now
You are the best Sir. Going forward if that happens I do the same procedure right?
it is very easy to apply filter by mistake
and to refresh the data
just click anywhere in the pivot table
click the pink options tab
then click refresh
PLEASE RATE WHEN READY IF YOU NEED ANY FURTHER HELP IN THE FUTURE. Don't hesitate to ask
Let me check again. Something didn't update.
ill stay here until it is working
Tried the pivot table clear summary but it didn't update eventhough I corrected some cells with misspellings.
i change the last cell in K column
and selected the pivot filter
and the change showed up
so I am not sure what you are getting at
would it be easier if a macro were created
to refresh the pivot table
when the workbook is opened
or have a command button
or have the pivot table auto refresh
when any change is made in k column
Is that something you could do?
just tell me how you want it
I'll take the auto refresh.
so if any cell in K changes
give me a few minutes to do so
seams to be working
here is the link
now any time you change a value in column K
the pivot will update
adding new values
It still shows 4 Converted when there should be only 3 and it's pulling a blank 1 reading.
nothing can be done about the blanks unless you specify a range that doesn't include the blanks that the data comes from
Ok, I'll find out where that is pulling from later. What about the Converted?
there are 4 converteds
i just counted them
Just caught it and your Summary picked it up. You are great. Excellent rating coming your way again.
Even if I build more than 260 cells will the pivot update maintain itself going forward?
if you dont mind the blanks
Great. No I don't.
Good night PCG.