We help IT Professionals succeed at work.
Get Started
Troubleshooting Question

Need help with pivot table in excel workbook

20 Views
Last Modified: 2021-02-11
I have an excel spreadsheet that tracks usage on our Konica/Minolta Bizhub c654e.  I have a pivot table in the spreadsheet that use to work, but after I added a new user, it no longer works.  I used to be able to just set the data to the new source table and it displayed correctly.  I would prefer to automate this as much as possible.  

ADDED: I forgot to add I tried recreating the Pivot Table, but either I completely forgot how to do this or it was unsuccessful for another reason.

I have attached the spreadsheet I use.  I would prefer to do this using a database but our security team is no longer allowing MS Access (which is easiest for me) on our network.

Currently, I do the following at the beginning of each month:
  • download the usage file from the copier
  • import the usage stats into excel
  • format usage stats as a table
  • rename new tab to the current date
  • copy usage stats to a tab called "current"
  • go to the pivot table tab (named "Pivot Table of Usage") and change the data source to the new table

What am I doing wrong? How do I fix this and make it easier?

Konica usage all copy.xlsx

Comment
Watch Question
Consultant
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 23 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE