Hi, Whenever you open a new Excel sheet, the macro security level is set to "Medium" by default. How can I set to be "low" permanently?

I am using a drop down list for categorization, however, frequently the category titles change, is there a way to force the data to change when I update the...

Whenever I open a new Excel Worksheet, it contains the name of an old file - instead of Book1 -- How do I correct?

I have a certificate signed macro that users access and create data files from. When some of my users migrated from Excel 2003 to Excel 2007, I provided...

I’d like to hear if anyone else has seen this anomaly. A colleague had this happen. I’ve not been able to recreate the problem with a new file. This...

=IF(AND(B113="Anne",ISNUMBER(V113)), R113+S113) What am I doing wrong? All I get is "VALUE", with no help.

Is there a way to set the number of a cell (A5) as a variable (A(variable)) so that I would be able to select different cells in column A by changing the...

Hi all, I'm fairly new with Excel so let's see if I can get a quick answer for my question :). I am trying to add a base number to whatever number i Input...

Excel 2003 thru and including 2007 Is it possible to lock or protect ONLY the pattern and/or border formatting in a select range of cells in any of these...

Hi there, I would like to know is it possible mail merge from excel data base into another excel sheet. What I am doing is setting up our quote templates in...

Hi there, What i am trying to do is I am using V lookup formula to generate a mailing address for invoices. But what I want is if the 2nd line of the...

Excel/2003 ... INDEX/MATCH array Formula (2 comparison) Formula working fine. Issue ... Formula in 2 Cols each 40,000 Cells ... Formula Fills 1st Col, but...

I currently receive a file that has a person’s ID # and then a list of work skill #s they have been assigned. I need to have that data modified. EX: the...

Hi all, Anyone know why the file size for a .xlsm version of a wbook is much larger than a .xlsb? I know xlsb is a binary "raw" save so I would have thought...

I have a worksheet that has numerous hyperlinks attached to many of the cells. I would like to remove all Hyperlinks associated with this worksheet. Is...

Hi, I have a workbook with three sheet: Numerator, Denominator and Area Rate. The Numerator workbook has a pivot table which is based on an access query. ...

I'm trying to compare two lists of names. I would like to compare the first name in list one against all of list two. Once that cycles through, I would like...

I need to change cell border line color to RGB(222,201,150)? I'm using Excel 2003

Excel2003 ... Pivot Table & Chart working fine ... (Excel Range A1:P40000) Above said ... I repopulated Table Source Range with new data (4 pns only instead...

I have a shared excel workbook that contains pivot table reports. How do I refresh the pivot table reports after changing sourse data without unsharing the...