It won't let me put the Pivot Table in Cell A12, I get the errorA PivotTable report
Fantastic news! We've Found the answer you've been seeking!
Question:
It won't let me put the Pivot Table in Cell A12, I get the error"A PivotTable report cannot overlap a table or XML mapping. The full table range is A15:J212
On the Sales worksheet, using the rangeA15:J212, insert a PivotTable in cell A12 on theSalesAnalysis worksheet. | 8 |
Configure the PivotTable using the following. | 4 |
Transcribed Image Text:
File 1 Date 2 3 4 5 6 7 8 Pivot Table Recommended Table Pictures Pivot Tables Tables 9 10 11 12 13 14 Home Insert Page Layout 15 Date 16 5/1/2018 17 5/1/2018 18 5/1/2018 19 5/1/2018 20 5/1/2018 21 5/1/2018 22 5/1/2018 23 5/1/2018 24 5/2/2018 25 5/2/2018 26 5/2/2018 27 5/2/2018 28 5/2/2018 29 5/2/2018 Ready 44 HH Units Product Units Formulas Data Online Pictures L Shapes Icons Sales с Product 1 Spaaaaah - Hair Wrap 2 Sandalwood Massage Oil 2 Vanilla Bean Massage Oil Illustrations 2 Water - rejuvenating, flavored, 12 oz bottle 2 Geranium Rose Bath Crystals 1 Vanilla Bean reed oil 1 Vanilla Bean Massage Oil 1 Nail repair 2 Nail repair 4 Geranium Rose Bath Crystals 1 Nail repair 1 Sandalwood reed oil 1 Vanilla Bean reed oil 3 Healthy Hands - extra dry Sheet4 Filter SalesAnalysis Review 3D Models ▾ SmartArt Screenshot- D Category View Help SalesBackup Get Add-ins My Add-ins Category Clothing Massage Oil Massage Oil Food Skincare Scents Massage Oil Hand Care Hand Care Skincare Hand Care Scents Scents Hand Care + Search FA Bing People Maps Graph Add-ins F Retail_Price Staff Retail_Price Staff 17.95 Kendra 19.95 Kelly 19.95 Kelly 4.19 Pat 6.99 Kendra 6.95 Irene 19.95 Kendra 9.95 Jason 9.95 Christy 6.99 Susan 9.95 Jason 6.95 Jason 6.95 Pat 8.5 Christy Recommended Charts G D-BA -- Staff_Category Receptionist Charts Transaction count Units sold Subtotal sum Retail average H Hotel Guest $ Ś Staff_Category Massage Therapist Yes Receptionist Receptionist Yes On Maps PivotChart No Massage Therapist No No Massage Therapist Yes Manager Massage Therapist Yes Massage Therapist Massage Therapist Nail Technician Massage Therapist Nail Technician Massage Therapist Yes Yes No Yes Yes Yes Massage Therapist Yes 197 283 2,074.32 10.53 Hotel_Guest I Trans_Type Card 3D Map Tours card card cash card cash check cash card card cash check M. Line Column Win/ Loss Trans_Type Subtot cash check check J Sparklines 17.95 39.90 39.90 8.38 13.98 6.95 19.95 9.95 19.90 27.96 9.95 6.95 6.95 25.50 K L Microsoft Excel 4 10: Slicer Timeline Filters 5 M Link Links N Comment Comments O P A Text Header Box & Footer Object A PivotTable report cannot overlap a table or XML mapping. A WordArt Signature Line + O Text R S 间 LO Share π Equation Symbol T Symbols U Comments V 100% V File 1 Date 2 3 4 5 6 7 8 Pivot Table Recommended Table Pictures Pivot Tables Tables 9 10 11 12 13 14 Home Insert Page Layout 15 Date 16 5/1/2018 17 5/1/2018 18 5/1/2018 19 5/1/2018 20 5/1/2018 21 5/1/2018 22 5/1/2018 23 5/1/2018 24 5/2/2018 25 5/2/2018 26 5/2/2018 27 5/2/2018 28 5/2/2018 29 5/2/2018 Ready 44 HH Units Product Units Formulas Data Online Pictures L Shapes Icons Sales с Product 1 Spaaaaah - Hair Wrap 2 Sandalwood Massage Oil 2 Vanilla Bean Massage Oil Illustrations 2 Water - rejuvenating, flavored, 12 oz bottle 2 Geranium Rose Bath Crystals 1 Vanilla Bean reed oil 1 Vanilla Bean Massage Oil 1 Nail repair 2 Nail repair 4 Geranium Rose Bath Crystals 1 Nail repair 1 Sandalwood reed oil 1 Vanilla Bean reed oil 3 Healthy Hands - extra dry Sheet4 Filter SalesAnalysis Review 3D Models ▾ SmartArt Screenshot- D Category View Help SalesBackup Get Add-ins My Add-ins Category Clothing Massage Oil Massage Oil Food Skincare Scents Massage Oil Hand Care Hand Care Skincare Hand Care Scents Scents Hand Care + Search FA Bing People Maps Graph Add-ins F Retail_Price Staff Retail_Price Staff 17.95 Kendra 19.95 Kelly 19.95 Kelly 4.19 Pat 6.99 Kendra 6.95 Irene 19.95 Kendra 9.95 Jason 9.95 Christy 6.99 Susan 9.95 Jason 6.95 Jason 6.95 Pat 8.5 Christy Recommended Charts G D-BA -- Staff_Category Receptionist Charts Transaction count Units sold Subtotal sum Retail average H Hotel Guest $ Ś Staff_Category Massage Therapist Yes Receptionist Receptionist Yes On Maps PivotChart No Massage Therapist No No Massage Therapist Yes Manager Massage Therapist Yes Massage Therapist Massage Therapist Nail Technician Massage Therapist Nail Technician Massage Therapist Yes Yes No Yes Yes Yes Massage Therapist Yes 197 283 2,074.32 10.53 Hotel_Guest I Trans_Type Card 3D Map Tours card card cash card cash check cash card card cash check M. Line Column Win/ Loss Trans_Type Subtot cash check check J Sparklines 17.95 39.90 39.90 8.38 13.98 6.95 19.95 9.95 19.90 27.96 9.95 6.95 6.95 25.50 K L Microsoft Excel 4 10: Slicer Timeline Filters 5 M Link Links N Comment Comments O P A Text Header Box & Footer Object A PivotTable report cannot overlap a table or XML mapping. A WordArt Signature Line + O Text R S 间 LO Share π Equation Symbol T Symbols U Comments V 100% V
Expert Answer:
Answer rating: 100% (QA)
Step 1 Solution The error message youre encountering A PivotTable report cannot overlap a table or XML mapping suggests that there might be an existing table or XML mapping in the range where youre tr... View the full answer
Related Book For
Managerial Accounting Decision Making and Performance Management
ISBN: 978-0273764489
4th edition
Authors: Ray Proctor
Posted Date:
Students also viewed these programming questions
-
How much money do you need to live comfortably each year? Everyone could have different answer here. So, let's make it 1million here, and this will be your annual income at retirement with this same...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
IP A hot-air balloon rises from the ground with a velocity of (3.00 m/s ). A champagne bottle is opened to celebrate takeoff, expelling the cork horizontally with a velocity of (6.00 m/s )x relative...
-
A management team can gain additional insight on company performance by comparing ___________ against _____________. Question content area bottom Part 1 A. budgets, flexible budget B. actual results,...
-
Until 2010, Norman Corporation, a young manufacturer of specialty consumer products, had not had its financial statements audited. It had, however, relied on the auditing firm of Kline & Burrows to...
-
The Collins Corporation purchased office equipment at the beginning of 2016 and capitalized a cost of $2,000,000. This cost included the following expenditures: Purchase...
-
How should the sample company decide which capital projects to fund?
-
The General Fund trial balance of the City of Cordes as of January 1, 2012, was as follows: The following data pertain to General Fund operations for the City of Cordes for the fiscal year ended...
-
n this assignment, you are going to think of a scenario 5 years from now when you have your dream job and you are happy with what you are earning. Fill out the budget calculator by creating an income...
-
Solve the following modifications of the capital budgeting model in Figure 6.5. (Solve each part independently of the others.) a. Suppose that at most two of projects 3, 5, and 6 can be selected. b....
-
Students will prepare a two-page summary outlining a political, social, economic, or environmental event in a resort destination that has had, or will have, either a positive or negative effect on...
-
Which of the following is not an example of a closing entry? a. Close each revenue account to the Retained Earnings account b. Close each expense account to the Retained Earnings account c. Close the...
-
Ober Co. sold merchandise to Nunley Companyon December 31, FOB shipping point. If the merchandise is in transit on December 31, the end of the fiscal year, which company would report it in its...
-
Stamm Company issued a promissory note to Blair Company, (a) Who is the payee? (b) What is the title of the account used by Blair Company in recording the note?
-
What are some of the methods you have seen managers or others use to overcome resistance to change? Were these methods successful? Why, or why not?
-
Do you think leadership can be learned, or is it just a personal characteristic that some people have? Why do you think this way?
-
2-3 Application Problem: Analyzing revenue, expense, and withdrawal transactions into debit and credit parts 105 Use the chart of accounts for Helfrey Marketing Services given in Problem 2-2....
-
d. The characteristic equation of a control system is given by s+2s+8s+12s+20s+16+16=0. Determine the number of the roots of the equation which lie on the imaginary axis of s-plane
-
It is 30 January 2013 and Worthy Ltds board of directors is meeting to discuss the 2012 accounts (summarized below together with those of 2011). Worthy Ltd is a manufacturing business and all its...
-
SACCUS is a local charity which decides to hold an outdoors fund-raising event in mid-summer. The secretary has a connection with an entertainments company which puts on musical laser light shows for...
-
MCP plc specializes in providing marketing, data collection, data processing and consulting services. The company is divided into divisions that provide services to each other and also to external...
-
Why is EVA a better measure of financial performance than are accounting measures such as net income or earnings per share?
-
Might financial value creation be an appropriate goal for not-for-profit businesses? Explain.
-
Richmond Clinic has obtained the following estimates for its costs of debt and equity at various capital structures: What is the firms optimal capital structure? (Hint: Calculate its corporate cost...
Study smarter with the SolutionInn App