General

Count function not working in one workbook
The count function is not working in one of my workbooks. It works in others and in new ones. The workbook it is not working in was created last week. It returns either zero or shows the function formula in the cell even though calculate is set at automatic. Carolyn ... 13 Apr 2010 18:30

Insert Rows
Hi, I have a simple excel sheet which is saved in eencrypted format. I am unable to insert rows in the same. Whenever I try, it says, 'To prevent possible loss of data, Excel cannot shift non-blank cells off the document...'. Could find what the real problem is. ... 13 Apr 2010 12:50

Data validation issue with multiple columns
I need something that forces a 2nd response if the word Other is chosen from a drop down. A B C Name Reason Note ----------------------------------------- Jim complete Bob Other left early If the response is anything but other then no note is required, but... 13 Apr 2010 10:36

Change Track Changes Colour
Hi Is it possible to change the colour that Excel 2003 Track Changes appears in? It's currently showing up as navy which is difficult to identify against black. Thanks ... 13 Apr 2010 08:22

total
Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to 1/3/10 etc. Thanks Remarks my data not include any empty raw Working data as below Date Emp #.ID No. of Hours 01/03/10 116 4.00 01/03/10 116 2.00 ... 13 Apr 2010 08:22

Excel 2003 to Excel 2007 graphs
I have a bunch of Excel 2003 graphs that are now being updated with new data. In the course of this, we are also saving as Excel 2007 macro-enabled files (.xlsm). Any time the file is saved it has a message re: invalid name or range and says it will change the name to "_CHARTA_xxyy" for example. You are prompted ... 13 Apr 2010 06:12

How to Insert Excel file into webpage
Hi I have made some tax calculators and would like to know how to insert them onto my website. I have tried the frontpage route but the user will have to download "Excel XP Web component" to be able to view it. Is there any other method where the web user be able to see/use the calculator without downloading... 13 Apr 2010 06:12

To display repetitive text, one time, auomatically
JUNE - 20 DECEMBER - 56 JUNE - 96 JUNE - 56 DECEMBER - 66 dear All, i have this data in 2 columns and what I want is: to appear 'june' automatically in one cell and in the next cell the total of june (172). I got 172 by using 'sumif' function, but ;june' has to appear automatically. please help me to sort o... 13 Apr 2010 02:57

copying causes lock up
Copying the contents of a box causes a lock up for 10 to 20 seconds. The jagged line around the box is stationary and after a period of time start to move. At that time I am able to paste in another location. What causes this delay and how to fix it? ... 13 Apr 2010 01:52

Search and then format by color
I have a column of data that is almost 5000 cells deep. I want to be able to have the groups of duplicates colored a unique color. For example, if there are 12 cells that have a value of 9231, I want to see that those 12 and only those 12 get colored red. Then, maybe there are 200 cells that have a value of ... 13 Apr 2010 01:52