Is It Possible To Make Pivot Table Using Multiple Sources Of Data? – InterviewSolution

1.

Is It Possible To Make Pivot Table Using Multiple Sources Of Data?

Answer»

YES, if the multiple SOURCES are DIFFERENT worksheets in the same WORKBOOK.

Yes, if the multiple sources are different worksheets in the same workbook.

Discussion

No Comment Found

Related InterviewSolutions

How Will You Check The Memory Consumed By Your Pivot Table In Kilobytes?
Which Option Is Used To Add Column(s) In Pivot Tables To Compute The Values In Run-time? For Eg. If The Underlying Source Table Contains Cost Price And Sales Price, How Would You Compute 'profit'.
Which Event Do You Use To Check If A Pivot Table Is Modified?
How Can You Disable Automating Sorting In Pivot Tables?
Which 3 Report Formats For Pivot Tables Are Available In Excel 2007 Or Later?
How Can You Hide The Error Values In Data Field Of Pivot Table?
How Would You Enable Automatic Refresh In Pivot Table Upon Opening The Workbook Without Using Macros?
When You Link To A Pivot Table Cell, A Getpivotdata Formula Is Created. How Would You Avoid This?
Can You Change The Default Summary Function For Data From Count To Sum?
Upon Refreshing A Pivot Table, It Always Loses The Formatting Like The Column Width. How This Can Be Corrected?