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
Tm1Web xlsx websheets issue
-
- 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
Have you tried deleting the object from the folder and republishing the correct xlsm file?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
-
- 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
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
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
- 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
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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
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
-
- 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
Issue corrected with Tm1 server reboot
Thanks for the your replies !
Thanks for the your replies !