TM1web v 10.1.1 - Number of Sheets to Export Exceeds maximum

Post Reply
jadawson50
Posts: 6
Joined: Wed Mar 19, 2014 1:54 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: Excel 2007

TM1web v 10.1.1 - Number of Sheets to Export Exceeds maximum

Post by jadawson50 »

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
User avatar
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

Post by jim wood »

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
jadawson50
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

Post by jadawson50 »

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.
User avatar
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

Post by jim wood »

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
jadawson50
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

Post by jadawson50 »

No splitting. How do they spilt ?
User avatar
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

Post by jim wood »

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
jadawson50
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

Post by jadawson50 »

thanks, i'll get them to try that.
Post Reply