Excel Slice/Snapshot problem

Post Reply
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Excel Slice/Snapshot problem

Post by Herman Moller »

Hello,

Has anyone seen this problem before?

Problem description

2 users (out of around 70) who, when they use the Slice to Excel functionality, Excel creates a worksheet (called something like ASO followed by a number, sorry, don't have a screenshot), but then the Excel screen goes completely white, freezes and has to be killed. We have checked the Ignore Other Applications setting and this is set corrrectly.

The environment uses roaming profiles, which have been deleted and recreated for these users with no effect.
One of the users can log on to other machines with his own profile and can use Slices, the other can not even do this. Other users can create slices from the same views.

TM1 version 9.0 SP3 U9, Excel 2003

Any thoughts.

Thanks in advance

Herman
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: Excel Slice/Snapshot problem

Post by jim wood »

Herman,

Have you tried changing the slice settings so they slice in to a current work book. Also which version of Excel are they using? We uased to have random errors like this but since we upgraded up to excel 2003 they have become more rare,

Jim.
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
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: Excel Slice/Snapshot problem

Post by Herman Moller »

Jim,

The users are using Excel 2003. I will give your suggestion a try with the slicing to a current workbook.

Thanks

Herman
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: Excel Slice/Snapshot problem

Post by Herman Moller »

Jim,

Once the users sliced to a current workbook the problem is solved.

Very odd bug.

Thanks for the assistance.

Herman
Post Reply