-->

1. Where Can I Download Office 2010
2. Word 2010 Download

I have the same issue with opening excel 2003 from exporer on my Win 7 machine with Office 2010. One way around this is to start excel 2010 and open 2003 or 2007. Then save the file as a excel worksheet. This saves the 2003/2007.xls as a.xlsx. Close excel 2010 and then you can open the new.xlsx file from explorer. You can create and change an offline cube (a file with the extension.cub) in Excel. First, you must establish a connection to the Analysis Services by using Microsoft Query (on the Data Tab, Query External Data/From Other Source/From Microsoft Query), or by using the Data Connection Assistant (on the Insert Tab, select PivotTable/Use External Data Source). Collaborate for free with an online version of Microsoft Excel. Save spreadsheets in OneDrive. Share them with others and work together at the same time.

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

When you double-click an icon or file name for a Microsoft Excel workbook, Excel starts and then displays a blank screen instead of the file that you expect to see.

Resolution

Important

Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.

To resolve this problem, try the following options, as appropriate, in the given order.

Option 1: Check for hidden sheets

An Excel sheet may inadvertently have been saved as a hidden document. To check this, follow these steps:

1. Go to the View tab.
2. Select Unhide.
3. Select a workbook from the list.
4. Select OK.

Option 2: Minimizing and maximizing the window

Minimizing and then maximizing the window can sometimes refresh the Excel page and cause any hidden data to appear.

1. In the top-right corner of the Excel spreadsheet, select the minimize button.
2. In the task tray, right-click Excel, and then select your spreadsheet. (Or double click the Excel icon.)

After your sheet is maximized, your data may appear.

Option 3: Disable hardware acceleration

To work around this problem, disable hardware acceleration until a fix is released by your video adapter manufacturer. Make sure to check regularly for updates to your video adapter driver.

To disable hardware acceleration, follow these steps:

1. Start any Office 2013, 2016, 2019, or O365 program.

2. On the File tab, select Options.

3. In the Options dialog box, select Advanced.

4. In the list of available options, select the Disable hardware graphics acceleration check box.

   The following screenshot shows this option in Excel.

5. Select the OK button.

Note

For more information about hardware acceleration, see the following Knowledge Base article:

2768648 Display issues in Office 2013 client applications

Option 4: Ignore DDE

This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected.

When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel. This message instructs Excel to open the workbook that you double-clicked.

If you select the 'Ignore' option, Excel ignores DDE messages that are sent to it by other programs. Therefore, the DDE message that is sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-clicked.

To correct this setting, follow these steps.

Note

Where Can I Download Office 2010

This step can be skipped for Excel 2019 and Excel O365.

1. In the upper-left corner of the Excel window, select File > Options.
2. On the left side of the Options window, select Advanced.
3. In the Advanced window, scroll down to the General section.
4. Clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, and then select the OK button at the bottom of the window.

Note

For more information about how to turn off DDE, see 'An error occurred when sending commands to the program' in Excel.

Option 5: Reset file associations

To check whether the file associations in the system are performing correctly, reset the Excel file associations to their default settings. To do this, follow the steps for your operating system.

Windows 10 and Windows 8.1

1. Locate the file that is opening incorrectly, and copy it to your desktop.
2. Right-click the file, and select Properties.
3. On the General tab, next to Type of file, the type of file will be indicated within parentheses. For example, (.docx), (.pdf), or (.csv).

The Opens with command shows you which app the file is currently associated with.

To open this type of file in a different app:

1. Select Change.
2. Select More apps.
3. Select the desired app, then select the Always use this app checkbox.
4. Select the OK button.

Windows 8

1. On the Start screen, type Control Panel.
2. Select or tap Control Panel.
3. Select Default Programs, then select Set your default programs.
4. Select Excel, then select Choose default for this program.
5. On the Set Program Associations screen, select Select All, and then select Save.

Windows 7

1. Select Start, then select Control Panel.
2. Select Default Programs.
3. Select Associate a file type or protocol with a specific program.
4. Select Microsoft Excel Worksheet, then select change program.
5. Under Recommended Programs, select Microsoft Excel.
6. If Excel does not appear in this list, select Browse, locate the Excel installation folder, select Excel.exe, then select Excel.

Option 6: Repair User Experience Virtualization (UE-V)

If you are running Update User Experience Virtualization (UE-V), install Hotfix 2927019. To do this, see the following Knowledge Base article:

Word 2010 Download

2927019 Hotfix Package 1 for Microsoft User Experience Virtualization 2.0

If you are not sure whether you are running UE-V, examine the program list in the Programs and Features item in Control Panel. An entry for 'Company Settings Center' indicates that you are running UE-V.

Option 7: Repair Office

Try to repair your Office programs. To do this, follow the steps for your installation type and operating system.

For an Office 365 or Office 2019 Click-to-Run installation

Windows 10

1. On the Start screen, type Settings.
2. Select or tap Settings.
3. In the Settings window, select or tap Apps.
4. In the Apps & features window, scroll down to your Office program, and select or tap it.
5. Select or tap the Modify button.
6. In the How would you like to repair your Office programs window, select or tap the Online Repair radio button, then select or tap the Repair button.

Windows 8

1. On the Start screen, type Control Panel.
2. Select or tap Control Panel.
3. Under Programs, select or tap Uninstall a program.
4. Select or tap Microsoft Office 365, then select or tap Change.
5. Select or tap Online Repair, then select or tap Repair. You may have to restart your computer after the repair process is finished.

Windows 7

1. Select Start, then select Control Panel.

2. double-click Programs and Features.

3. Select Microsoft Office 365, then select Change.

4. Select Online Repair, then select Repair.

Note

You may have to restart your computer after the repair process is complete.

For an Office 2013, Office 2010, or Office 2007 installation

To repair Office 2013, Office 2010, or Office 2007, follow the steps in the following Office website topic:

Option 8: Turn off add-ins

Excel and COM add-in programs can also cause this problem. These two kinds of add-ins are located in different folders. For testing, disable and isolate the conflict by turning off each add-in one at a time. To do this, follow these steps:

1. On the File menu, select Options, and then select Add-Ins.
2. In the Manage list at the bottom of the screen, select COM Add-Ins item, and then select Go.
3. Clear one of the add-ins in the list, then select OK.
4. Restart Excel by double-clicking the icon or file name for the workbook that you are trying to open.
5. If the problem persists, repeat steps 1-4, except select a different add-in in step 3.
6. If the problem persists after you clear all the COM Add-ins, repeat steps 1-4, except select Excel Add-Ins in step 2. Then, try each of the Excel add-ins one at a time in step 3.

If Excel loads the file, the add-in that you last turned off is causing the problem. If this is the case, we recommend that you visit the manufacturer's website for the add-in to learn whether an updated version of the add-in is available. If a newer version of the add-in is not available, or if you don't have to use the add-in, you can leave it turned off.

If Excel does not open the file after you turn off all the add-ins, the problem has a different cause.

If none of the above options works, please make sure Excel is not in Compatibility mode.

If you still experience this problem after you try all these options, contact Microsoft Support for additional troubleshooting help.

Home > Sample chapters > Microsoft Office > Excel

• 12/22/2011

1. CUBEKPIMEMBER()

• CUBEKPIMEMBER()

• CUBEMEMBER()

• CUBEMEMBERPROPERTY()

• CUBERANKEDMEMBER()

• CUBESET()

• CUBESETCOUNT()

• CUBEVALUE()

Cube functions were introduced in Microsoft Excel 2007. They are used with connections to external SQL data sources and provide analysis tools. Data cubes are multidimensional sets of data that can be stored in a spreadsheet, providing a means to summarize information from the raw data source. A cube is different from queries in Microsoft Access or Microsoft SQL Server because the data in a cube is already grouped in hierarchies, and calculated measures are saved in the cube. This offers two advantages to the user: Summary information is readily available, and most of the heavy-duty calculations are performed on the server. The user does not have to spend much time consolidating the data in Excel. However, you cannot use calculated fields or elements for a PivotTable.

To use cube functions, you must be working with data that is available in one of these two forms:

• Through a connection to a SQL Server Analysis Services data source

• In an offline cube in the user’s local file system

These conditions limit the usefulness of cube functions. So that you will be able to work through some examples, the sample files accompanying this book include offline cube and data connection files for the example outlined in Chapter 2, “Using Functions and PowerPivot.”

However, you will have to change the sample data connection files (they have either the extension .odc for a workbook connection, or .oqy for Microsoft Query) because the path to a database must be the full path. Use Windows Notepad to change the paths as follows:

The prepared sample workbook serves as a guide. To avoid unnecessary errors when modifying this sample, perform the following steps to create your own workbook:

1. On the Insert tab, select PivotTable/Use External Data Source. (You can search for additional elements and use the existing data connection files.)

2. Create the layout and include the content from the data source.

3. Use the cube functions.

When you open a workbook with data connections and use the default Excel settings, you have to explicitly allow these connections (click the Enable Content button, as shown in Figure 14-2). When you activate a document in Excel 2010, the document is trusted and you don’t have to confirm the activation again until the trusted document is reset in the Trust Center.

Figure 14-2 The security warning that is shown when Excel is accessing external data.

The descriptions of the functions throughout the rest of this chapter refer to the example in Chapter 2. The example uses two store groups named North and South, which sell sweets (chocolate and cookies) from the years 2008 through 2011. Each store group consists of two stores. Table 14-1 describes the functions.

Table 14-1 Overview of the Cube Functions

CUBEKPIMEMBER()

Syntax CUBEKPIMEMBER(connection,kpi_name,kpi_property,caption)

Definition This function returns a Key Performance Indicator (KPI) property and displays the KPI name in the cell.

Arguments

• connection (required) A string with the name of the workbook connection to the cube. After you enter the first quotation mark, the existing context-sensitive data connections are displayed (see Figure 14-4, shown later in this chapter in the description of CUBEMEMBER()).

• kpi_name (required) Specifies the name of the KPI in the cube.

• kpi_property (required) A KPI consists of several components that are specified by using an integer (see Table 14-2).

  Table 14-2 Integers for the Third Argument of the CUBEKPIMEMBER() Function

  Integer	MDX expression	Description
  1	[KPIValue]	Actual value
  2	[KPIGoal]	Target value
  3	[KPIStatus]	State of the KPI at a specific moment in time
  4	[KPITrend]	Measure of the value over time
  5	[KPIWeight]	Relative importance assigned to the KPI
  6	[KPICurrentTimeMember]	Temporal context for the KPI

• caption (optional) A string displayed in the cell instead of the caption of the KPI components in the cube.

Background

Error values and messages provide information about incorrect or missing entries:

• If the connection name is not a valid workbook connection, the CUBEKPIMEMBER() function returns the #NAME? error.

• If the OLAP server (or the offline cube) is not available, you get an error message. The content of the affected cell doesn’t change.

• CUBEKPIMEMBER() returns the #N/A error value when kpi_name or kpi_property is invalid.

• CUBEKPIMEMBER() might return the #N/A error when the connection to the data source is interrupted and cannot be re-established

You can combine CUBEKPIMEMBER() with CUBEVALUE(). Specify CUBEKPIMEMBER() as the second argument or reference for CUBEVALUE().

Example In this example, a KPI named average is saved in the cube. This cube calculates the average of the sales and the total number of sales as integers. Both values are also saved as measures in the cube but cannot be used to calculate fields in the PivotTable. The target value (goal) is $1,500. Figure 14-3 shows the example for cookies.

The formula

displays the word average. The formula

returns 1453 (the rounded average of all sales). In the second formula, you can enter a reference to the cell containing the first formula as the second argument. To get the target value of the average, use the formula

The value of 2 in the last argument is important, because it indicates, in this case, the target value.

You can use the cell containing the formula to create cell captions. The real content of the cell is more informative, as shown by using the CUBEVALUE() function.

Related resources

• By Chris Sorensen, Ammul Shergill
• Online video $299.99

• By Joan Lambert
• Book $24.99

• By Paul McFedries
• Book $24.99