Excel 2007/2003 Pivottable compatibility
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/ex...672981033.aspx ("Working with different PivotTable formats in Office Excel"), "Filter results may vary". Does this mean that I can't trust the data? -- Thank You in Advance, Michael Anderson |
All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com