MS Query and TM1
Posted: Tue Mar 04, 2014 1:48 am
Hi all. Hopefully someone might be able to shed some light on this.
We have an Excel 2010 workbook with an ms query to our erp system. We want to add two new fields into the query and we open ms query and add them. We close and return to Excel and we can see the new columns added but on the last OK to exit they disappear from the worksheet. This is only happening for users with TM1 installed. For any other user who does not have TM1 it works and the new columns appear in the workbook.
We are using TM1 10.1.1
Any insight would be greatly appreciated.
Regards
Vera
We have an Excel 2010 workbook with an ms query to our erp system. We want to add two new fields into the query and we open ms query and add them. We close and return to Excel and we can see the new columns added but on the last OK to exit they disappear from the worksheet. This is only happening for users with TM1 installed. For any other user who does not have TM1 it works and the new columns appear in the workbook.
We are using TM1 10.1.1
Any insight would be greatly appreciated.
Regards
Vera