I have the following...

How do you define a named range that is local to a single worksheet without using VBA? i.e. the name only defined in a single worksheet and can't be used on...

I have a QueryTable (i.e. the results of Get External Data - New Database Query)in a worksheet and when I refresh it, it disapears. If I choose to edit the...

I have a set of data in a pivot from which I want to get the count of unique values. The excel spreadsheet has a FREQUENCY function that will work in a...

I have a shared workbook with a data sheet on one tab and a pivot to that data sheet on a separate tab. When I update the data, the pivot won't allow me to...

Can anyone please give me some guideline on how to draw a chart with y-axis is the count of the item in x-axis? I am using Excel 97. Thanks.

How can I freeze a row and a column at the same time using Excel 97? Thanks.

I have created a drawing from several objects (arcs, ovals, triangles, etc.). When I try to print, some objects move (especially annoying is BlocArc)....

hello, I am getting the following error messages when when excel and office crash. (everyday) what does this mesage mean I don’t know how to...

Softwa Excel 2003 I've received a spreadsheet containing various email addresses but the hyperlink for each address is not active (regular text, not...

When I run a query in MS Access and export the results to Excel the date foramt is changed. I know how to change the formatting in the affected columns but...

I am attempting to write a macro that incorporates an advanced filter to search by ~100 criteria, across a list of ~200 columns x3000 rows. Is there a way to...

I have a workbook that has up to 31 worksheets named 1, 2, 3....which contains db log information for each day of the month. Each worksheet has 2 columns...

I get a product key error when trying to install my old version of office 2000 on Windows XP. I know my product key is correct. What am I doing wrong. I...

I am looking for a cell function that allows me to icrease at a set top point of .8 EX. 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 2.0, 2.1, 2.2, 2.3 etc.

Is there a way to count the number of letters that are present in seperate cells. I have a spreadsheet that has either Y or N in the cell and need to count...

I am trying to drag a formula across many cells from a seperate spreadsheet, however i am having a few difficulties. On the second sheet i am wanting to fill...

How do you create a formula to automatically calculate which figure are the highest and place them into a seperate cell? For example, if i have a spreadsheet...

I have a column that contains important dates, and I'd like to say make the forecolor red if they're 3 months away, blue if their 6 months away, etc... How...

i need to enter "1-10" in a cell as a category heading and will need to enter similar data for the same reason, but every time i try this, once i...