I have a 32 sheets work book that fetches data from different sources after data cleansing and filteration of data i have created a pivot table which get refreshed once all the data related procedure gets over
My requirement is now to export the sheets containg this pivot table and its underlying data (So in all two sheets only )sheet in previous version i.e excel 2003. so that majority of viewers can see this file.As I try this by saving in compatiable mode i.e. ".xls" . Pivot table structure get lost only the values left.
I read somewhere to change pivot table version (earlier) and than save it in order to remain pivot intact but don't know how to do this please help.
Also after data cleansing steps raw data for pivot is well under lmit, i.e. number of rows are much less than excel 2003 row limit.