Weird Save Problem

  • Thread starter Thread starter Alastair MacFarlane
  • Start date 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
 
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.
 
Back
Top