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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,118
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top