Row Heights Change Completely Randomly

lemo

Registered User.
Local time
Today, 13:51
Joined
Apr 30, 2008
Messages
187
and extremely annoyingly..

whenever i trigger a change in a pivot table using the report filter, the heights of some of the rows involved in the action change without any logic.
i have a bunch of cells to the right of the pivot table that change based on the pivot table modifications, and sometimes they require to be '1 unit' high, and sometimes 2 (when long text wraps around), but it's not happening at all.

help please. thanks.
l
p.s. using 2007 on xp.
 
and extremely annoyingly..

whenever i trigger a change in a pivot table using the report filter, the heights of some of the rows involved in the action change without any logic.
i have a bunch of cells to the right of the pivot table that change based on the pivot table modifications, and sometimes they require to be '1 unit' high, and sometimes 2 (when long text wraps around), but it's not happening at all.

help please. thanks.
l
p.s. using 2007 on xp.

lemo,

we're on Office 03 and sometimes our text wraps soemtimes it doesn't, you might have to trigger VBA when the pivot table changes. Have you set the as the necessary cells format to wrap text?

I'm thinking along the lines of triggering

Code:
Rows([I][B]x:y[/B][/I]).EntireRow.AutoFit

when the pivot table is changed. Record a macro to see what the pivot table is called, adjust a row and then adapt the code accordingly.
 
great idea, thanks Call_Me_Sam!
definitely will try that, although it will be a laborious exercise as i am not a good coder at all.
couldn't understand your question, could you rephrase please?..
l
 
great idea, thanks Call_Me_Sam!
definitely will try that, although it will be a laborious exercise as i am not a good coder at all.
couldn't understand your question, could you rephrase please?..
l

ok let's start easy, you prob won't need the pivot table name as you'll be using the

Code:
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

sub proc..

Think out side of the box, you could do it 2 ways.

Record a macro to adjust rows x through to y (14 to 65000), and then double click the row height.Stop recording
In the VBEditor, go to the sheet with your pivot table on and select worksheet from the left of the two combo boxes (see my attachment)..then select pivot table update.
Then add the name of your macro to the sub routine so it is triggered when the pivot tabel changes.

The other way is to put the code from the macro into the sub routine, or enter the code i put in originally..

hopefully this will help..and is clearer, sorry my double dutch is poor..:D
 

Attachments

  • excelPVUpdate.JPG
    excelPVUpdate.JPG
    39.5 KB · Views: 205
sorry for being mia - other projects etc.
i'll get back to this very soon, will post progress..
thanks a bunch, Call_Me_Sam.
l
 
sorry for being mia - other projects etc.
i'll get back to this very soon, will post progress..
thanks a bunch, Call_Me_Sam.
l

lemo, check out another thread with pivot table problems, shades recommends a book by Mr Excel ( has his own website), might be worth checking it out when you have time..
 
worked like a charm!
many thanks, Sam.. (just 'Sam' is good, i assume, since the whole handle asks for it?)
it could be a new chapter in my relationship with excel..
(although we just had another argument, i am posting my complaint in a minute)..

l
 
worked like a charm!
many thanks, Sam.. (just 'Sam' is good, i assume, since the whole handle asks for it?)
it could be a new chapter in my relationship with excel..
(although we just had another argument, i am posting my complaint in a minute)..

l

'sam's fine...though i answer more to frank...

and whatever you do don't tell Bill you're having a thing with his software... i'm sure there's something in the end user licence
 
hey, they just split, it's free for all now....
 

Users who are viewing this thread

Back
Top Bottom