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

You are attempting to open a file that is blocked by your registry policy setting.

Number of error messages that will be fixed when you will apply the resolution:

You are attempting to open a file that is blocked by your registry policy setting.

You are attempting to open a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

You are attempting to open a file that was created in an earlier version of Microsoft Office. This file type is blocked from opening in this version by your registry policy setting.

You are attempting to save a file that is blocked by your registry policy setting.

You are attempting to save a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

Your error message will be anyone which are mentioned above. but don't worry Microsoft has already published a KB for this and your issue will be resolved when you will apply the mentioned resolution.

Resolution:

To resolve this issue, click the following article number under the name of the Office program that you are using to view the article in the Microsoft Knowledge Base: 

Word 2010, Word 2007, or Word 2003

I receive an error message when I try to open or save a file in Word

Excel 2010, Excel 2007, or Excel 2003

I receive an error message when I try to open or save a file in Excel

PowerPoint 2010, PowerPoint 2007, or PowerPoint 2003

I receive an error message when I try to open or save a file in PowerPoint


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, thank you

Excel 2010 Help and How-to | Excel 2010 Training | Excel 2010 Videos

Make the switch to Excel 2010

Training Are you switching to Excel 2010 from a previous version? This course is for you.

Getting started with Excel 2010

Article If you know Excel 2007, used an earlier version of Excel, or have never used Excel before, explore these resources to begin learning how to use the latest...

Get to know Excel 2010: Create your first spreadsheet

Training New to Excel? Learn how to create a spreadsheet, do basic math, create and format column titles, freeze the top row, and set some printing options.

Office 2010 Security: Protecting your files

Training In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars...

Get to know Excel 2010: Create formulas

Training Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.

Download Office 2010 training

Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them for group training or...

VLOOKUP: What it is, and when to use it

Training You may have heard of the VLOOKUP function, and you may have heard reasons why you should use it. But what does it do, exactly? In this training course...

Understand data at a glance with conditional formatting

Training Have you heard about conditional formatting? Get hands-on practice using conditional formatting to make data stand out.

Sparklines: Use tiny charts to show data trends

Training Overview As you look at rows and rows of data, sometimes it’s hard to immediately make sense of it. Add tiny charts called sparklines next to data to...

Use Excel tables to manage information

Training Learn how to use Excel tables to sort and filter data, get special table formatting, and see table formulas auto fill.

The IF function: what it is, and how to use it

Training Overview The IF function checks to see if a condition you specify is true, or false. If true, one thing happens; if false, something else happens. For...

How to create a basic chart in Excel 2010

Training Learn how to create a chart and how to make changes to a chart after you create it.

Save time by creating and running macros in Excel 2010

Training Overview Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know you can create macros so that Excel can do...

Figure out dates by using formulas in Excel 2010

Training Figure out dates by using formulas in Excel 2010 Overview Use formulas to figure out dates such as how many workdays until vacation, or calculate the...

Plan payments and savings in Excel 2010

Training Learn how to use financial functions in Excel formulas to figure out payments and savings

Excel 2010 keyboard shortcuts I: CTRL key shortcuts

Training Learn Excel 2010 keyboard shortcuts. Learn CTRL key shortcuts that let you do everything from selecting and editing cells, to inserting cells, rows, and columns.

Excel 2010 keyboard shortcuts II: ALT key shortcuts

Training Learn how to use ALT key shortcuts that let you access almost any command in Excel 2010. These keyboard shortcuts are also called access keys, and they...