9.5 and Excel 2007 Performance Problems

Post Reply
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

9.5 and Excel 2007 Performance Problems

Post 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
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
Post Reply