hi,

i have a listbox in my spreadsheet which changes the page field of a pivot
table in another sheet. when i select a certain value, i get an error
message that sys something like "no item of this name exists in the
PivotTable report. rename 'value' to 'value2'?. it only happens when i
select certain values in the listbox. what causes this message, and how can
i prevent it. it makes the users feel uncomfotable , like thee issometing
wrong with the spreadsheet, so im reluctant to pass it along just yet.

thanks in advance,
geebee