• AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP
Get FREE step-by-step guidance on your question from our Excel Experts.
Quick Excel Help
  • AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP

Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

  • All solutions
  • PIVOT TABLE
  • Data Source
I need the Pivot Table Wizard in Excel from Office Home and Student 2016 for Mac. The Cmd-Opt-P that works in Excel 2011 for Mac won't work in the 2016 version. I need to add ranges. The Change Data Source doesn't work: it says because I have dat "from multiple consolidation ranges" and it says to use "Command + Option + P" which doesn't work. Is there another way of bringing up the Pivot Table Wizard?
Solved by G. Q. in 40 mins
I created a pivot table linked to source data in a separate worksheet and the pivot table was distributed to employees. The data had confidential in it that was accidentally included. I thought deleting the sheet with the data source would break the pivot table, but that is not the case. Can I do anything to corrupt the pivot table?
Solved by I. J. in 40 mins
Sir, I want to change the data source of my pivot table to another data source in another spreed sheet, how can I go about it in Google spreed sheet? Thanks
Solved by S. C. in 48 mins

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, see here: Cookie Policy
  • Home
  • About
  • Excel Tutorial
  • Excelchat
  • Contact
  • Excel Problems
  • Experts
© 2023 Got It, Inc. All rights reserved.
Got it! Your question will be answered by an Excelchat Expert. Hang tight for 30 secs while we redirect you.

Save time by asking instead! Most questions solved and answered in 10 minutes.

Post your problem and you’ll get expert help in seconds.
Your message must be at least 40 characters
Free trial ends in 00 days 12 hours