Best way of Displaying A Seperate Table of Data

knotty150

New Member
Joined
Jun 26, 2014
Messages
30
Morning All

I'm having a problem with what should really be something very straightforward I think. I've got a PivotTable of stats etc in excel - beneath this PivotTable I'd like to display a more granular level of detail. Only problem is the inability to adjust row/column width/height without one table effecting the other. What I require is the freedom to adjust the column/width of the rows/columns in the granular detail display, independently of the PivotTable above it.

I've just tried using a method where you use insert > object and then linked to a separate worksheet (thinking I could then adjust the rows/columns in here as I see fit) but what I'm finding here is that if you adjust the size of this display, it merely zooms in on the worksheet i.e. does not expand the cell range it's looking at.

I'll gung-ho from going in to any further detail - I reckon you get the idea of what I'm trying to achieve here. Anyone have any suggestions?

Many Thanks!

Rich
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,118
Messages
5,835,495
Members
430,360
Latest member
Ajonode

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top