Tagged Questions

I hope this is the correct forum to post this, I believe this to be an Excel issue.
Ever since I upgraded to Win 7 (64 bit), whenever I try to add an ActiveX control to a worksheet in Excel 2003, I ...

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...

I am in need of working out how to have sequence numbering in the excel database I'm creating.
I am trying to have the following
001/15,
002/15,
003/15...
I am having no luck in getting this to work ...

I am on a W7 64bit pro edition, on a Lenovo T420
With regard to Show Excel column filter information in cells, is there a reason why it is not working in Excel 2003?
Thanks in advance
Gilberto
PS
I ...

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...

On my work machine I have Excel 2003. The first time (per instance) I try to save a file or quit, there is a noticeable delay. For saving the delay is somewhere around 10-15 seconds and for quitting ...

I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...

I tried using various combinations of functions but it seems that there's no specific function can return non-searched/matched values. Doing it manually takes days cause of the large amount data that ...

Hello to all the superusers!
My new question regarding conflict problem betweend an access application ad a excel wookbook/worksheet
I have a worksheet where using "Get External Data" on the "Data" ...

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...

I currently use excel to create a shopping list to make it easier at the store. All rows have an item name, cost, and total based on the qty entered in the A column. Is there any way (with little to ...

I need to create an excel spread sheet. I am doing a time study. ( The time a project was started to finish) I will be entering in times frequently in military time. I havent used excel for years and ...

First of all I have tried a lot but failed to get a solution for the following problem and I hence request all the superusers to help me with their best if possible....
I tried unpivoting but it did ...

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...

I was wondering how would i through VBA conditionally format the whole row or a row in a range based on the first cell in that row? Also it would require a comparison to the previous row to current ...

Each day of the year has a value which I would like to consolidate by day of the week, i.e. all 52 Mondays consecutively, all 52 Tuesdays consecutively etc. They are recorded chronologically on Sheet ...

When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the ...

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines.
Some members receive more than one copy of the magazine, which will be indicated in ...