We cannot locate a server to load the workbook Data Model.

Problem Description:

Assume that you use an Analysis Services source to create a PivotTable in Microsoft Excel 2013. You upload the Excel Workbook to a Microsoft SharePoint site.

When you try to either refresh the PivotTable or filter the data in the PivotTable, you receive the following error message:

We cannot locate a server to load the workbook Data Model.

Probable cause:

This issue occurs because the Analysis Services instance has not been configured in the Central Administration site.

Workaround/Resolution:

1.    To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps:

2.    In the Application Management section of the Central Administration home page, click Manage service applications.

3.    On the Manage Service Applications page, click the Excel Services service application that you want to configure.

4.    On the Manage Excel Services page, click Data Model.

5.    Click Add Server.

6.    In the Server Name box, type the name of the Analysis Services instance that you want to add.

7.    Click Ok.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J

Unable to See "+" and "-" Group/Ungroup in Certain Excel Worksheets

When I select and Group multiple rows, I cannot see the "-" (collapse) or the "+" (expand) signs on the left of the spreadsheet.  This happens for both Rows and Column groups.  This happens for only certain Tabs (Worksheets) within the Workbook.

OR I have grouped some columns, but now I can't see the button on the top of the grouped ones. I tried to group/ungroup again and, as there were some hidden rows, I tried to unhide them all and it is still not working.

OR how do you group and ungroup rows or columns in new Excel?

Resolution:

Show or hide outlined data

1. If you don't see the outline symbols 1,2,3, +, and -, click the Microsoft Office Button, click Excel Options, click the Advanced category, and then under the Display for this worksheet section, select the worksheet, and select the Show outline symbols if an outline is applied check box.

2. Do one or more of the following:

Show or hide the detail data for a group

• To display the detail data within a group, click the + for the group.
• To hide the detail data for a group, click the - for the group.

Expand or collapse the entire outline to a particular level

• In the 1,2,3 outline symbols, click the number of the level that you want. Detail data at lower levels is then hidden.

For example, if an outline has four levels, you can hide the fourth level while displaying the rest of the levels by clicking 3.

Show or hide all of the outlined detail data

• To show all detail data, click the lowest level in the 1,2,3 outline symbols. For example, if there are three levels, click 3.
• To hide all detail data, click1.

Role of Excel Services in SharePoint 2010

Excel Services is part of Microsoft SharePoint Server 2010

Excel Services is built on ASP.NET and SharePoint Foundation technologies

Excel Services enables you to load, calculate, and display Microsoft Excel workbooks on Microsoft SharePoint Server

Core Components are:-

·         Excel Web Access

·         Excel Web Services

·         User-defined functions (UDFs)

·         ECMAScript (JavaScript, JScript)

·         Representational State Transfer (REST) service

·         Excel Calculation Services

An important aspect of Excel Services is that solution developers can use its power programmatically from their applications.

There are five types of development that you can do by using Excel Services:

·         Develop solutions by using Excel Web Services

·         Extend the Microsoft Excel function library in Excel Services by using user-defined functions (UDFs)

·         Customize the Excel Web Access Web Part

·         Develop solutions by using ECMAScript (JavaScript, JScript)

·         Use the REST API to perform operations against Excel workbooks

It supports sharing, securing, managing, and using Excel 2010 workbooks in a browser by providing the following:

Global settings for managing workbooks,

·         settings for security

·         load balancing

·         session management

·         memory utilization

·         workbook caches,

·         external data connections

·         Trusted file locations

An extensive list of trusted data providers for connecting to your data, plus the ability to add your own trusted data provider.

·         Trusted data connection libraries, which allow you to define which data connection libraries in your farm are trusted by Excel Services

·         The ability to add your own user-defined function assemblies.

"Setup is missing prerequisites" error message when you try to install the PowerPivot add-in for Excel in FAST Search Server 2010 for SharePoint

Problem Description:

Consider the following scenario:

• You have a server that has the Business Intelligence Indexing Connector feature installed in Microsoft FAST Search Server 2010 for SharePoint. 

• You have to crawl Microsoft Excel 2010 files that contain PowerPivot content. 

• You install the PowerPivot add-in for Excel on the server. 

In this scenario, the PowerPivot add-in for Excel does not install.

Additionally, you receive the following error message:

Setup is missing prerequisites:

This add-in requires Excel 2010. If you have 32-bit Excel, you must install the 32-bit version of the add-in. If not, you must install the 64-bit version. This add-in requires that the Office Shared Features component of Microsoft Office 2010 is installed.

Go to http://go.microsoft.com/Fwlink/?LinkId= 168472

Probable cause:

This issue occurs because Excel 2010 is not installed on the server.

Resolution:

To resolve this issue, install Excel 2010 on the server.

OR—Follow this article: http://support.microsoft.com/kb/982765

Please let me know in case of any queries/questions.

I would be more than happy to help you as well as resolves your issues, Thank you J

Note: When installing PowerPivot add-in for Excel, you don’t look at whether you have a 32-bit machine or a 64-bit machine; instead, you should look at whether you have 32-bit Excel or 64-bit Excel. In other words, if you are using the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot and if you are using the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot.

The Excel Services Application for SharePoint 2010 does not load or display workbooks

Problem Description:

The Excel Services application for Microsoft SharePoint 2010 does not load or display workbooks.

This problem may occur in one of the following scenarios:

• In a custom-security configuration. 

• When you add a new Web application to a farm. 

• When you do not perform a default installation. 

Probable causes:

This problem occurs because the service account that runs the Excel Services Application does not have access to the SharePoint content databases.

Resolution:

To resolve this problem, the administrator must grant access to the account to run the Excel Services Application. To do this, follow these steps for each Web application:

·         Click Start

·         click All Programs . 

·         Click Microsoft SharePoint 2010 Products

·         Click SharePoint 2010 Management Shell

At the Windows PowerShell command prompt (PS C:\>), type the following command, and then press ENTER:

PS> $w = Get-SPWebApplication –Identity < URL of the Web application >

PS> $w.GrantAccessToProcessIdentity("< insert service account >")

Note: The placeholder <insert service account> represents the service account that you use to run the Excel Services Application. 

After you do this, the service account is granted db_owner access to the SharePoint content databases.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J Thank you.

The file is corrupt cannot be opened

Excel 2010 is spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows you to store manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Sparklines and Slicers.

Problem Description:

After you install Microsoft Office 2010, you cannot open .xls files, and you may receive the following message:

The file is corrupt cannot be opened.

In addition, you may experience a problem in which any Microsoft Office programs, such as Word or Outlook, crashes when you open .xls files. 

Resolution:

1)   Follow these steps:

2)   Click Start

3)   Control Panel

4)   Programs

5)   Uninstall a program under Programs and Features. 

6)   Select Microsoft Office. 

7)   Click Change, and then wait while the change and repair is carried out.  

8)   Exit after the process is completed. 

9)   Double-click the Excel file that you want to open or open the file through an HTML link as you could by using previous versions of the program.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J Thank you