Tm1Web xlsx websheets issue

Post Reply
Lewis
Posts: 31
Joined: Thu Jul 17, 2008 6:03 pm
OLAP Product: Cognos Tm1
Version: 952 FP1 [prod]
Excel Version: 2007 2010

Tm1Web xlsx websheets issue

Post by Lewis »

Tm1web (9.5.2) stopped opening xlsx worksheets -

? Think it started when I overwrote a test.xlsx file in web app folder with an excel xlsm file

any ideas ?

Thanks in advance
tomok
MVP
Posts: 2835
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Tm1Web xlsx websheets issue

Post by tomok »

Lewis wrote:Tm1web (9.5.2) stopped opening xlsx worksheets -

? Think it started when I overwrote a test.xlsx file in web app folder with an excel xlsm file

any ideas ?

Thanks in advance
Have you tried deleting the object from the folder and republishing the correct xlsm file?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Lewis
Posts: 31
Joined: Thu Jul 17, 2008 6:03 pm
OLAP Product: Cognos Tm1
Version: 952 FP1 [prod]
Excel Version: 2007 2010

Re: Tm1Web xlsx websheets issue

Post by Lewis »

Yes - did not work - this is 9.5.2 so uploads are xls or xlsx

I "confused" something when I overwrote the test.xlsx web file with the myfile.xlsm

- tm1web does not recognize xlsx file as legit file - when I try to open any xlsx file the

web download box pops up - thanks for your reply
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Tm1Web xlsx websheets issue

Post by jim wood »

XLSM is the macro extension if I remember rightly. I don't think web supports that extension. If you remove it and restart web and the excel service are you able to open other files? Have you tried after removing it, saving it as something else with the xlsx extension? Also what version of excel is installed on your web server?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Lewis
Posts: 31
Joined: Thu Jul 17, 2008 6:03 pm
OLAP Product: Cognos Tm1
Version: 952 FP1 [prod]
Excel Version: 2007 2010

Re: Tm1Web xlsx websheets issue

Post by Lewis »

Excel 2007 - I was not meaning to upload an xlsm fiel ( which is not allowed on 9.5.2)

I have restarted web and excel services - the issue is effecting "all" of my web xlsx file .

Guess I will bring down my app later today & also reboot the server - see if that resets anything
- somewhere something was reset - saw an IBm note about excel 2003 & 2007 on same box but that is
not my case and as stated earlier all was well until I messed up on my upload .

Thanks for you help
Lewis
Posts: 31
Joined: Thu Jul 17, 2008 6:03 pm
OLAP Product: Cognos Tm1
Version: 952 FP1 [prod]
Excel Version: 2007 2010

Re: Tm1Web xlsx websheets issue

Post by Lewis »

Issue corrected with Tm1 server reboot

Thanks for the your replies !
Post Reply