# Background

Needed to quickly review Microsoft Excel files.

As I don’t have Microsoft Office installed on the server that I was connected to at the time, wanted to install a light weight version.

That version is Excel Viewer.

# Microsoft

## How to obtain the latest Excel Viewer

Retired

How to obtain the latest Excel Viewer

Image

Textual

Excel Viewer has been retired

Important: The Microsoft Excel Viewer was retired in April, 2018. It is no longer available for download or receive security updates. To continue viewing Excel files for free, we recommend installing the Excel mobile app or storing documents in OneDrive or Dropbox, where Excel Online opens them in your browser.

Explanation

1. Retired
• So since April 2018, Microsoft Excel Viewer has been retired
2. Alternatives
• Platform
• Desktop
• Not available
• Mobile Apps
• Available
• Online Storage
• OneDrive
• Dropbox

## MS Office Excel Viewer

1. Github
• Excel Viewer
3. vessoft.com
• Excel Viewer

## MS Office Word Viewer

1. Github
2. vessoft.com
• Word Viewer

# Summary

So if you need to access Microsoft Office files and you do not have a corporate license or do not have installed on the computer you are using, please consider per-using the links above.

# Background

I have a situation where I need to summarize some data and I don’t really want to do so in a database.

# SQL Server

In Database we have roll-up and Windowing Functions.

And, it is really likely the way I should go.

# Excel

But, as the data is not in a database, I will really rather not bring it in.

I will just use Excel and send the Excel file to our business partner.

## SubTotal

### Subtotal – Process – Category – Country

Select the range of data by clicking on the column header as well on last data row.

### Subtotal –  Operation

#### Explanation

1. At each change in : Country
2. Use function :- Sum
3. Add Subtotal to : Population
4. Replace current options :- Checked
5. Page break between groups :- Not Checked
6. Summary below data :- Checked

### Subtotal –  Results

#### Explanation

1. We have subtotals for our two countries, Canada & US
2. And, we have a Grand Total

### Subtotal –  Operation

#### Explanation

1. At each change in : State
2. Use function :- Sum
3. Add Subtotal to : Population
4. Replace current options :- Not Checked
5. Page break between groups :- Not Checked
6. Summary below data :- Checked

### Subtotal –  Results

#### Explanation

1. We have subtotals for State/Regions
2. Cumulative subtotals for the countries
3. And, we have a Grand Total

## Summary

To add secondary sub-totals please make sure to un-check “Replace current options” in the subtotal window.

# Background

Trying to export a SharePoint List, but getting the prompt and error pasted below.

# Prompt

## Do you want to open or save owssvr.iqy from sp..

### Textual

Do you want to open or save owssvr.iqy from sp..

# Error

## Error – SharePoint Foundation-Compatible Application

### Textual

To export a list, you must have a Microsoft SharePoint Foundation-compatible application.

# TroubleShooting

## Microsoft SharePoint Foundation Support

### Is “Microsoft SharePoint Foundation Support” installed?

Accessed “Control Panel \ “Add or Remove Programs” \ “Microsoft Office Professional Plus 2010” \ Changed and made sure that “Microsoft SharePoint Foundation Support” is checked

## Microsoft Office

### Check MS Office Version #

#### MS Word

Using MS Word Help/About, check Version#

##### Version Info:

Product :- Microsoft Office Professional Plus 2010
Version # :- 14.0.7184.5000 ( 32-bit)

#### Version Matrix

##### Tabulate
Product Version Version# – Low Version# – High
Office 2010 – RTM 14.0.4763.1000 14.0.6029.1000
Office 2010 – SP1 14.0.6029.1000 14.0.7015.1000
Office 2010 – SP2 14.0.7015.1000

##### Explanation

Our current version # is 14.0.7184.5000.

And, SP2 is at minimum 14.0.7015.1000.

### Microsoft Office – Repair

#### Image

##### Microsoft Office Professional Plus 2010 – Configuration Progress

Repairing Microsoft Office Professional Plus 2010 ….

##### Microsoft Office Professional Plus 2010 – Configuration Complete

The configuration for Microsoft Office Professional Plus 2010 is complete.
To make your changes take effect, exit and restart and open Office Programs.

##### Microsoft Office Professional Plus 2010 – Configuration Complete

In order to complete setup, a system reboot is necessary.
Would you like to reboot now?

# Validation

Post system reboot, launch Internet Explorer and revisited SharePoint List

## Images

### Microsoft Excel Security Notice

#### Microsoft Office Has identified a potential security concern

##### Textual

Microsoft Office Has identified a potential security concern.

# Summary

To address the error “To export a list, you must have a Microsoft SharePoint Foundation-compatible application“, we were getting we simply repaired our microsoft Office 2010 installation.

In some cases one needs to apply the latest Service Pack, but we verified that we are already on the latest SP.

# References

1. Microsoft
• Technet
• Kim P – MSFT
• To export a list, you must have a Microsoft SharePoint Foundation-compatible application