Weird Save Problem

  • Thread starter Alastair MacFarlane
  • Start date
A

Alastair MacFarlane

Dear All

I have created a pivot table in Excel 2000 and have to
send it to clients who have Excel 97. When I save the file
the speadsheet looses some formating (which I understand
is possble going from one version to another), however in
this example it saves the dropdown capabilities of the
PageFields but looses it for the the ColumnFields and
RowFields. Only when the RowField or ColumnField is
dragged to become a PageField, does the drop down exist.

Is the dropdown capability of the RowField or ColumnField
only available in Excel 2000?

Thanks again...

Alastair
 
M

Max

Is the dropdown capability of the RowField or ColumnField
only available in Excel 2000?
Click to expand...

Looks like it, I'm afraid...

I'm using xl97, and can confirm this feature is *not* available in xl97.
 
Top