Not sure if anyone else had this issue in version 10.1.1 of TM1web, when trying to export a 64 page to PDF or Snapshot to Excel. You get the following error message " Number of sheets to export exceeds maximum allowed"
Anyone have a solution ?
thanks
TM1web v 10.1.1 - Number of Sheets to Export Exceeds maximum
-
- Posts: 6
- Joined: Wed Mar 19, 2014 1:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: Excel 2007
- jim wood
- Site Admin
- Posts: 3961
- 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 v 10.1.1 - Number of Sheets to Export Exceeds max
I've only ever had this when accidentally spliting the export in to too many pages. How have you defined your export?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 6
- Joined: Wed Mar 19, 2014 1:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: Excel 2007
Re: TM1web v 10.1.1 - Number of Sheets to Export Exceeds max
Seems to fail when our accountant tries to Export to PDF or Snapshot to Excel when Entity is select (and it shows 32 elements), note this one of the smallest divisions. but is the accountant select period (1 period) it's fine, no issues. hope that helps.
- jim wood
- Site Admin
- Posts: 3961
- 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 v 10.1.1 - Number of Sheets to Export Exceeds max
What options are they selecting when they export? Are they trying to split it?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 6
- Joined: Wed Mar 19, 2014 1:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: Excel 2007
Re: TM1web v 10.1.1 - Number of Sheets to Export Exceeds max
No splitting. How do they spilt ?
- jim wood
- Site Admin
- Posts: 3961
- 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 v 10.1.1 - Number of Sheets to Export Exceeds max
Select dimension titles. That will create seperate pages. If you don't select any it will export as is.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 6
- Joined: Wed Mar 19, 2014 1:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: Excel 2007
Re: TM1web v 10.1.1 - Number of Sheets to Export Exceeds max
thanks, i'll get them to try that.