General

#NAME? Error??????
=IF(AND('Productions Rates'!C3=0,'Productions Rates'!D3=SF,'Productions Rates'!H3=0),'Productions Rates'!$R$6) This works fine till I enter the 'Productions Rates'!D=3=SF, I receive an error #NAME?. I belive it caused by the SF. Any help to correct this? -- Joe ... 6 Mar 2010 18:30

multiple worksheets
Excel xp (2002) I'm looking to set up a spreadsheet with multiple worksheets for multiple users. Basically they are going to copy and paste names into column A of this spreadsheet and add a date in column B and a location in Column C. Their name will already be listed in Column D. All columns will be the ... 6 Mar 2010 17:24

Excel opens two windows (2007 & 2003 format): I want only 2003.
I have a spreadsheet that must be edited under Win 7 and under Win XP. Opening the file under Win 7 always gives two windows, the one marked "Compatibility Mode" is up-to-date and the one worked with. The other is not only useless to me, it is not even up-to-date. (I am willing to admit I may have done somet... 6 Mar 2010 15:11

How do I insert a timer in an excel worksheet?
:*(** You took the link down? Do you still happen to have that file? "Khaarthic" wrote: Thank you very much for your help. Your effort in creating the sample is greatly appreciated. "JLatham" wrote: Another case of showing you being easier than telling you. Hope you can understa... 6 Mar 2010 15:11

Help with an additing calculation
I am trying to create a calcualtion for the following A B $ $ Qty Text Text 10 15 3 Text Text 5 6 Text Text 2 1 2 34 47 so give a total of column C and D using E as a multiplier Any help greatly received ... 7 Mar 2010 05:16

can I use conditional formating with result be hiding a row?
exemple : if a value is yes then hide the row and if the value is no unhide the row ... 6 Mar 2010 12:58

Macro problem after copying an Excel File
Hello, Can anyone help please? I have a file 2009xxx.xls with many macros. I now wish to copy and call it 2010xxx.xls but the macro's won't run and advise that it needs debugging. Is there any way to update them without re-recording? I've tried to edit the names but they don't run. Kind regards Peter ... 7 Mar 2010 07:26

Excel properties that update when Excel is accessed without saving
I would like to know if there are other Excel 2003 properties, aside from the timestamp and personal metadata, that update whenever an Excel file is simply accessed for viewing but no changes are made to it? And what are those properties? Thanks. ... 6 Mar 2010 04:15

Copy a Table to another place with Column Alignment Displaced
I am using Excel 2007 In earlier version of Excel, I used to utilise a special function (with icon of Camera ?) to copy the contents of a range of cells alongwith the formating to another place in the worksheet, in a sort of 'picture' or 'mirror' so that the column alignment is for columns above the range copied... 6 Mar 2010 05:20

CURSOR SHAPE HAS CHANGED
Please Help. Today when I launched 2003 Excel, I found that my cursor has changed it's shape from the normal default arrow shape, to an animated CROSS shape for no apparent reason. Can anybody explain this? Thanks, Weep ... 6 Mar 2010 16:18