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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing string as array variable (Pivot VBA) 2
Ho to Delete "Ghost" Pivot Tables 3
How to replace PivotTable data fields...? 2
Pivottable PageField Dropdowns Disappear 4
VBA code for making a pivot table 1
"Unable to get Pivot Tables Property of Worksheet Class "Error 2
Please Help! Need to add a Variable Range in my Excel Macro withPivot Tables 3
macro statement will not run a second time without closing and reopening 2

Back
Top