I recently updated to 2003 and when I did my data analysis capabilities disappeared. How do I get that back?

Would appreciate help with what I am doing wrong.. vba does not like the lines containing the variables for setting chart parameters: Sub last1500() Dim...

I am working on a spreadsheet where the data is imported from Access. The data includes employee numbers where on Access they are zero-filled to 5 digits, so...

I think my follow-up to my original question got buried in the sands of time ; ) so I am re-posting as a new question. I think the solution given below should...

Can I set up a worksheet to automatically only print the active cells each time it is printed?

I am trying to get a series of cells to fill with a color if the word "insert" is inserted into the first cell. I.E. cells A2-A5 and cell A2 has "insert" typed...

I have 3 sheets in my workbook. the first two sheets will load the data and adjust the row. Problem that I am having is that the 3rd sheet keeps losing its...

We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets. When you highlight...

Hello! I'm not sure if this is the right Excel group to post this question in, but I am hopeful that someone can point me in the right direction: I have a...

MS word has capability to customize toolbars with shortcut buttons for "superscript" and "subscript". This feature has never been added to Excel for some...

How would I find the frequency between two values, my data is in cells c1:c470 with some empty spaces and i want to find how many of the values fall within...

I've a long column of numbers in excel which i need to flip round or invert but dont know how. I cant use the sort function as it only sorts it in ascending or...

How do I format a cell in MS Excel to enable me to enter a mobile...

As I never got any response to my previous question "How to create a counter that ignores hidden rows?", I'm assuming that either I stumped everyone or I did a...

I am trying to format a list using bullets in one cell in an excel spreadsheet. Can somone please provide some suggestions on how to do this? I have tried...

I need a formula that will allow the automatic population of a cell or group of cells based on selection from a user defined pick-list. Example: Pick List...

I'm trying to do an if,then function that looks at data in a cell and compares to 13 different possible results but excel on allows 7 nested IF functions. Any...

Is it possible to concatenate dates? In A1 I have 01/01/05 and in B1 I have 01/02/05. What I ant is for C1 to show "01/01/05 - 01/02/05" but when I try =A1&" -...

When I copy and paste information from a particular web site it will not allow me to add/subtract the informaiton in my excel spreadsheet. I have tried...

How do I figure which in a column are 30+, 60+, etc over today's date?