Excel Help 101 – Excel Cannot Open File, Stuck at Group Mode and Monthly Pivot Table

Excel Help 101 – Excel Cannot Open File, Stuck at Group Mode and Monthly Pivot Table

 

Excel is one of the tools I regularly use in my work and sometimes I get into problems that requires me to search online for a solution. In this post, I’ll share a few of my excel problems and their solutions.

Excel cannot open file when you double click it or use the shortcut

I had this problem before where I can’t seem to open any excel file. When I double click on the file, it would say “file not found” but how come I was able to find it but excel can’t?

What this means?

The setting “Ignore other applications that use Dynamic Data Exchange (DDE)” has been activated.

How to solve this?

You need to deactivate that error.

In Vista, it can be found by going to Excel Options -> Advanced -> General

Excel Help 101 - Excel Cannot Open File, Stuck at Group Mode and Monthly Pivot Table

For more info, visit http://support.microsoft.com/kb/211494

 

Excel Stuck in [Group] mode

Excel Help 101 - Excel Stuck in [Group] mode

Sometimes when I’m working with excel, it gets stuck then I would notice that a [group] word has appeared on the window.

What this means?

This means that you are currently editing two sheets at once.

How to solve this?

Just click on any sheet tab to focus on just one sheet.

 

Excel Pivot Table – Group Dates into Months/Years or any value you want

Suppose you have a group of data that you want to represent in a pivot table (e.g. expenses tracker) and you want to group it by months or by years or any grouping you want as long as it is not in the original individual values.

What this means?

For example, you have this…

Excel Help 101 - Group Pivot Table into Months or Years

but you want to change it to this.

Excel Help 101 - Group Pivot Table into Months or Years

How to solve this?

All you have to do is to right click on the column/row header that you want to group (in this example, it is the column header) and click on Group to open the Grouping options. Now pick how you want it to be grouped.

image

 

I hope these simple Excel 101 solutions have helped you as it helped me. If you have more excel questions, feel free to write a comment below.

Till next time,

Allen

Leave a Reply