S
signal
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
If you create a PivotTable, and select "Multiple Consolidation Ranges", "I will select page fields", then lets say you have three sheets.
You click on sheet1, and command select column A and column C, it shows this in the range box:
'Sheet1'!$A:$A,'Sheet1'!$C:$C
you then click Add, but what it adds is this:
$A:$A,'Sheet1'!$C,$C
If you try to finish, it will say "Invalid Range". If you try to re-type the correct range such as: 'Sheet1'!$A:$A,'Sheet1'!$C:$C, it will say its a duplicate.
I realize I could delete column B, and then just use Shift-Select, but this seems to be a bug. Any ideas?
Brian
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
If you create a PivotTable, and select "Multiple Consolidation Ranges", "I will select page fields", then lets say you have three sheets.
You click on sheet1, and command select column A and column C, it shows this in the range box:
'Sheet1'!$A:$A,'Sheet1'!$C:$C
you then click Add, but what it adds is this:
$A:$A,'Sheet1'!$C,$C
If you try to finish, it will say "Invalid Range". If you try to re-type the correct range such as: 'Sheet1'!$A:$A,'Sheet1'!$C:$C, it will say its a duplicate.
I realize I could delete column B, and then just use Shift-Select, but this seems to be a bug. Any ideas?
Brian