AO different behavior for calculation
We have worksheet consists of multiple sheets with calculations and formulas in it and we are on AO 2.1 SP01 (64 bit) also tried on 1.4 and 2.0
I noticed when we open the excel sheet without plugin it takes few seconds to open the worksheet and then the sheet gets loaded in another a minute
But when I open the same sheet with Analysis plugin enabled after it open the worksheet , it takes double the time to display the sheet and on the bottom right it shows Calculating 4 Processors , I understand the sheet has calculations but cant we disable the calculation (I already tried forumale > calculation type set as manual in the excel).
I tried looking something related to AO in forums but was not able to understand should I be doing some setting for AO or on excel