ExcelBanter - How to convert OLAP data (PIVOT Table) to formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to convert OLAP data (PIVOT Table) to formula (https://www.excelbanter.com/excel-discussion-misc-queries/148991-how-convert-olap-data-pivot-table-formula.html)

Apinya

How to convert OLAP data (PIVOT Table) to formula

I've been able to convert OLAP data to formula on MS Excel 2007 by using OLAP
Tools. But the most of my users use MS Excel 2003. Could anybody please
kindly guide how do I convert the OLAP data to formula on MS Excel 2003?

Thank you so much

All times are GMT +1. The time now is 07:48 AM.