Page 1 of 1

9.5 and Excel 2007 Performance Problems

Posted: Fri Jun 04, 2010 4:53 pm
by mattgoff
Hi all,

FYI, there appear to be some performance problems with 9.5 and Excel 2007. Support recommended the following as a workaround:
  • Add the parameter ProgressMessage=F to the server config file tm1s.cfg.
  • (For 64bit OS only) Add the parameter LockPagesInMemory=T to the server config file tm1s.cfg (see technote 1413242 for details).
  • Disable (rename) the Excel 2007 file, tm1pRibbonX.xlam.
Matt