TM1 Forum

Hi,
I have 2 tm1 files (excel environment), the first file is a big file with lots of sheets and second file is small csv file,
when Im openning the csv file (and the first file is already opened) it trying to calculate the first file, it seeems that openning csv file affect on the excel calculation,
the calculation mode is on manual,
any suggestions?

yuval wrote:Hi,
I have 2 tm1 files (excel environment), the first file is a big file with lots of sheets and second file is small csv file,
when Im openning the csv file (and the first file is already opened) it trying to calculate the first file, it seeems that openning csv file affect on the excel calculation,
the calculation mode is on manual,
any suggestions?

Turn off auto-recalc in Excel before opening the CSV file.

it's off

There is an Excel bug affecting up to 2007 where opening a CSV turns calculation mode to automatic regardless of the setting prior to that. This most annoying behaviour is finally fixed in Excel 2010 (well it's annoying when you happen to be working with TM1.)

Note sure in Office 2007 but on Office 2003 not even that always works. CSVs tend to force a recalc no matter what.

EDIT: Lotsaram beat me to it

finally I found a solution,
I've created excel file which reads data from the csv file (in excel tool bar-->data-->text) and refreshing in openning,
not ideal solution but it works.