General

1+3+5+7+9+11+13+15+17+19=100 make a sum of 5 numbers make 50
1+3+5+7+9+11+13+15+17+19=100 Choose 5 numbers from these 10 figures so there sum is = 50 ... 4 Dec 2008 07:22

Como fazer um grafico de pareto utilizando o Excel 2007
Tenho uma tabela de valores acumulados como posso elaborar um grafico de pareto ou diagrama de pareto utilizando o excel 2007 home and student? ... 11 Jul 2008 07:53

Status Bar - SUM function adding grouped cells
I have a set of 5 cells grouped and hidden/collapsed. When I highlight a set of numbers over these grouped cells, the status bar includes the grouped cells in the summation...it used to not do this and I want to only sum the visible numbers. Do I have a setting is off or something? ... 10 Jul 2008 22:41

This pivot table report is not valid
I have encountered the same problem when saving Excel 2007 reports in .xls (2003) format. In this case the option to refresh data is not available - nor do any pivot controls (e.g. Pivot Wizard) function. Most of my colleagues are still on Excel 2002 or 2003 - this is becoming a real problem - is there somethin... 10 Jul 2008 11:20

Excel 2003 errors when opening Excel 2007 document.
I have Excel 2003 users on SP2 and SP3 trying to open an Excel 2007 document They have the compatibility pack loaded. They receive the error “the converter failed to open the file”. ... 23 Jun 2008 09:38

date
How can I put a date in an excel cells and make sure that this date will appears in my outlook calendar. thanks ... 2 Jun 2008 10:18

.xlsx file opens as read-only
Using an older verion of Excel with the compatiblity pack installed. File opens okay on one pc with older version of excel, but (you knew there was a but). On another pc Excel opens file as xl0000001.xls Read-Only file in the Temporary directory. Suggestions? Michelle ... 30 Apr 2008 13:18

Excel Header Question - Help
I have a 12 sheet workbook. I want to create headers with the format xxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxx &Tab so when it prints - the actual tab name prints. I have tried using the Repeat page setup, but it puts the name of the tab I copied from as &Tab. How is I create one ... 1 Sep 2007 16:58

The message EUROTOOL.XLA!fshow TTO Dialog cannot be found
When transferring a file from AS/400 to Excel 2003 the above message appears on clickinl the transfer add in icon - any ideas ... 23 Jul 2007 07:30

Office Open XML Format?
In Excel 2007 we get the following warning: This document is both encypted and password protected. The Office Open XML Formats available in the 2007 release provide stronger encryption. Do you want to increase the security of this document by converting to an Office Open XML format? YES / NO How can I get ... 23 May 2007 16:55