Get instant live Excel expert help and learn how to make a Pivot Table

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Color changing charts based off of weight goals for the day and week. every week the goal weight will change. also how to use pivot tables and graphs that update automatically from that. etc.
Solved by T. F. in 23 mins
Currently using an excel spread sheet to create a database of parts and their parts numbers, as well as the contact information of who to contact to order the part. I have a pivet table set up and in column A i have all the parts going down, and then the plus/minus buttons are clicked to reveal the contacts/phone/email to get ahold of it, again this is all in column A via the compact form report layout. Next i am trying to find a way to insert addition information such as order frequency etc, in column BCDEF. I want them to be attached to the pivot table so that i can easily update and insert information. If i were to insert the frequencies next to the table but not in it, when opening the plus/minus' in column A this then throws the rest of the document out of wack and isnt aligned correctly. How would i go about inserting this information in a column connected to the pivot table and its corresponding parts without changing out of the compact view because of printing aspects and clarity.
Solved by F. C. in 12 mins
Need to update several pivot tables in a worksheet after the data is updated (data is a OBDC query)
Solved by T. B. in 28 mins
Adding script to update data source of multiple pivot tables
Solved by S. D. in 18 mins
Updating data ranges for multiple pivot tables in one update.
Solved by G. W. in 12 mins
Every month we copy the worksheet we are working on over, rename the worksheet for the current month, update the figures, and then update the pivot table on that worksheet to pull from the new figures. For some reason, this no longer works. We tell the worksheet to pull from July's tab and then hit refresh, but it's still pulling from June.
Solved by K. E. in 20 mins
A coworker tried to update the account names in my pivot table. Somehow she added a 2 to the end of all these Microsoft accounts. It causes my 4 week average formula to stop working, since it references the account name. These are all the #NA's you see in the right column. How can I edit the name back to the original so the formulas work again? I just need to remove the 2's from the end of each name. Thanks
Solved by M. Y. in 14 mins
I have two separate pivot tables, with the same data source, I want to use a cell value to update filters for different pivot fields from this one cell value. I need to be able to do this same operation on the work sheet for 3 or 4 cells. Filter by Month then year and by customer name.
Solved by Z. B. in 28 mins
Cannot update the latest entered data on my pivot tables
Solved by I. Y. in 15 mins
During the preparing of pivot table, I have a problem to update the pivot table every second so need the shortcut key.
Solved by S. C. in 13 mins
2