Extend Size for Number of Cells in AO

[abhishek_shanbhogue2]

Hello All,

We are making use of Analysis for Office and want to extend the size limit of the workbook cells, Understood from multiple SDN blogs and WIKI SCN about the REGEDIT Settings and RSADMIN settings.

Firstly I checked for AdvanceAnalysis/Datasource/Settings path & folder in REGEDIT but couldn't find it! I had to manually create them and maintain appropriate settings there but even after maintaining the settings the size limit isn't getting extended?

Business requirement is to extended cell value to 1M+

We are using OS 64 BIt, MS Office 64 Bit and AO 64bit edition for our analysis

Thanks

Abhishek Shanbhogue

[Former Member · Accepted solution]

Hi Abhishek,

maybe this link helps you: http://scn.sap.com/docs/DOC-63509

I'm still in 1.4.10 so I haven't set any Parameter in 2.0 yet.

Best regards, Martin

[abhishek_shanbhogue2 · Accepted solution]

Thanks Martin, This was of great help. I have now fixed the data volume issue.

[TammyPowlas]

Would you please specify version of Analysis Office - 1.4, 2.0, 2.1?

[abhishek_shanbhogue2]

Analysis Office 2.0