General

Are Excell 2007 macros backwaards compatible?
I am having macros made up. The coders are using Excel 2003. I am using Excel 2007. Most of my clients, who will be using the macros, are using Excel 97. The sample macros (2003) that the coders are sending me are showing AddIn Exceptions when I open them in 2007. They are opening and working, but I worry that... 2 Jul 2008 09:50

Time calculation or formula
Hi - very thick question I'm sure but is driving me mad - I have the following and want the time to travel in minutes, how do I then calculate the total cell to show hours & minutes ie: 12 hour shift and 90 minute travel = 13 hours and 30 minutes not 12.90?? Any assistance as always appreciated Mon Length of... 2 Jul 2008 03:42

vlookup
i'm doing a vlookup in column A. let's say a value appears more than once in column A. the first vlookup result will be the first corresponding value that appears, correct? how do I then alter the vlookup to find the 2nd value? 3rd? 4th? 5th? many thanks ... 1 Jul 2008 23:38

How do I delete only the unfiltered row?
Not sure is Microsoft remove or forgot to include the feature. I have filtered my data in excel 2007 and want to delete the row shown out but it just delete everything. Previously in excel 2003, it will not delete those not shown in the filter option and remain it until I unfilter it. ... 1 Jul 2008 23:38

cell locking and sheet protection
Try this: In a clean worksheet, select a range of cells (say C3 to F6). Go to format > cells > protection, and uncheck locked. Now to to tools > protection > protect sheet, and check [Protect worksheet and contects of locked cells] In [Allow all users of this worksheet to:] Make sure only [Select unlocked ... 1 Jul 2008 22:36

Program
Hi, I have the following problem: A table in file1.xls as follows: Person QTY email A 23 personA(a)company.com B 15 personB(a)company.com C 18 personC(a)company.com And also 3 excel files with detailed information for each person, as follows: file_personA.xls... 1 Jul 2008 21:35

convert Inches to the nearest foot
I am trying to convert Inches to the nearest foot in a column ... 1 Jul 2008 22:36

Savecopyas without password
I have an Excel workbook which requires a password to open. I need to savecopyas but when opening the copy (which is read only) not require a password. ... 2 Jul 2008 20:09

lost SKU1CA.CAB
lost file sku1ca.cab cannot open excel ... 2 Jul 2008 08:48

Is 1451.40B equal to 1451.40 x 1,000,000,000?
Is 1451.40B equal to 1451.40 x 1,000,000,000? Does anyone have any suggestions? Thanks in advance for any suggestions Eric ... 2 Jul 2008 08:48