In Excel 2003, I have set Tools > Options > Transition > Transition
Navigation Keys to "on". The shortcut keys for highlighting a
contiguous range of data work fine EXCEPT for when I am in the pivot
table wizard.
If I have already created a pivot table, and I decide to change the
range of my data, and I hit the "Back" button in the wizard to change
the data range that the pivot table draws from, I cannot use the arrow
key shortcuts (although I can use the mouse.) When I am not in the
pivot table wizard, the shortcut navigation keys work correctly.
Does anyone else experience this issue?
Please feel free to respond to me directly. Thank you.
David
consulttech2004@hotmail.com
Debra Dalgleish - 25 Jun 2005 12:39 GMT
If you right-click on the PivotTable, and choose Wizard, the arrow keys
won't work.
However, if you click the PivotTable button on the Pivot toolbar, and
choose PivotTable Wizard, the shortcut keys WILL work when selecting the
range.
> In Excel 2003, I have set Tools > Options > Transition > Transition
> Navigation Keys to "on". The shortcut keys for highlighting a
[quoted text clipped - 13 lines]
> David
> consulttech2004@hotmail.com

Signature
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html