Excel 2010: Insert / Data menus greyed out, can’t click on PivotCharts / PivotTables

Now group mode is very useful when you are editing several worksheets at once, all changes you make to one worksheet are made to all others in the group as well, but certain functions, such as all “Data” tools are disabled.

I was playing around with Excel spreadsheets and wanted to perform some filtering but for some weird reason all items in the quick access toolbar under “Data” was not available to me.

Resolution:

Here is the article which resolves my issue:

http://www.dracata.net/2011/07/excel-2010-insert-data-menus-greyed-out-cant-click-on-pivotcharts-pivottables

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.

Office File Validation detected a problem while trying to open this file. Opening it may be dangerous

When you open Microsoft Office 97-2003 binary file (such as .doc) the file is compared to a binary schema. If the file fails this validation, you are notified that the document could be considered to be compromised. In Office 2003 and in the 2007 Office system, you are prompted about the file status and can decide to cancel opening the file or to continue to open the file.

Office File Validation detected a problem while trying to open this file. Opening it may be dangerous.

Resolution:

Resolution is very simple and Million thanks to Microsoft’s Office Product team for publishing this fix: http://support.microsoft.com/kb/2501584

This fix is available for:

Disable Edit in Protected View: Excel 2010, PowerPoint 2010, Word 2010.

Enable Edit in Protected View: Excel 2010, PowerPoint 2010, Word 2010.

For Office 2003 and 2007 Office system

Disable the opening of documents

Excel 2003 and 2007, Word 2003 and 2007, PowerPoint 2003 and 2007

Enable the editing of documents

Excel 2003 and 2007, Word 2003 and 2007, PowerPoint 2003 and 2007

Duplicate items appear when viewing items in Datasheet view in SharePoint

ISSUE:

Duplicate items appear when viewing items in Datasheet view in SharePoint.  This also happens when using the Export to Spreadsheet (Excel).  If duplicates appear in Datasheet view, they will also appear during Export to Spreadsheet and vice versa.

DESCRIPTION:

The list has got versioning switched off, and views fine in standard list view. However, when you switch to either datasheet view or Excel Export it shows the same rows up to three times in sequential rows.

WORAROUND/SOLUTION:

The affected lists have a REQUIRED lookup field which allows multiple values.

If you have a view that does NOT include this field and it is either a datasheet or you "Switch to Datasheet" then datasheet shows duplicate items depending on how many multi-values are selected. 

Our work-around was to create a specific Datasheet view with the field included.  The multi-value field does not show in datasheet, because multi-value lookup fields don't seem to work in datasheet.  However, it's important to include the field in the view to avoid duplicates.

Unfortunately, if you have a view that does not include the field and then "Switch to Datasheet" you will encounter the same problem.

The duplicates appear also when you try to Export to Excel.  If you have a view that would be affected by the "Switch to Datasheet" duplicates problem, when you try to Export to Excel, it will also appear.

Unable to “Edit series” for a repeating event in sharepoint calendar list

Issue:

Unable to “Edit series” for a repeating event in sharepoint calendar list

Problem Description:

There is a repeating event (event series) in sharepoint calendar list with “All day event” selected and no specific start and end time.

When someone opens an event and then clicks on "Edit series", it opens up the series in edit mode. But after making any type of changes, page can’t be saved and clicking “Ok” returns to same edit page reflecting some validation errors which doesn't allow us to commit the changes.

Workaround\Resolution:

Solution for this problem issue is extremely simple very unobvious.

Whether we make changes to the series or not, we must uncheck the box for “All day event” and then select the check box again.