Excel 2007/2003 Pivottable compatibility

M

Michael Anderson

Hi

In Excel 2007, I have pivottables that read data from a SQL Server 2005
Analysis Services Cube. I am not able to work in the "2003 Compatability
Mode" because of the features required by the SSAS Cube. I just want to be
sure that when I save the workbook in the Excel 2003 format, that the data
will be correct. I notice that some of the formatting doesn't come across
correctly. According to
http://office.microsoft.com/en-us/excel/HA101672981033.aspx ("Working with
different PivotTable formats in Office Excel"), "Filter results may vary".
Does this mean that I can't trust the data?
 

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

Top