Troubleshooting
TANDBERG Analytics Extension Admin guide
18
applies to certain combinations of old versions of Excel and SSAS. The following Microsoft Connect
page describes a workaround
Error when creating an Excel Pivot Table from a SSAS project
.
1. Right click the connection in the
Select Data Source window
and select
Open with > Notepad
(Figure 7) to edit the connection file as described in the Microsoft Connect page,.
2. Locate the
<odc:ConnectionString>
element, and append
“;Locale Identifier=1033”
(note the semicolon) to the end o
f the element‟s content (Figure 8). Click
Save
.
3. The connection is now updated and ready for use.
Figure 7: Opening the connection for editing
