General

Appointments won't open
When I look at my calendar in OWA and go to create or change an event,then try to save and close it, I get "Appointment Can't Be Opened" -- Message posted via http://www.officekb.com ... 12 Apr 2010 11:26

formula help PLEASE PT 2
I need to get the information from sheet 2 row 16 using the date in sheet 1 C4 and the same date in sheet 2 A16 sheet 1 REPORT DATE 4/12/2010 APR 11 - 18 KPI No Genesis KPI's UOM sheet2 15-Apr 16-Apr 17-Apr Apr11-17 11 19 10 18-Apr 19-Apr or can I lookup a sum of cells usi... 12 Apr 2010 09:13

missing styles
I had Excel 2007 crash while several files were open. It auto-recovered them, but the formatting was gone from one of the workbooks. Now, when I try to use the comma style for formatting a cell, it tells me that it cannot be found. Any ideas about how to restore this? ... 10 Apr 2010 19:02

I need to link 4 pivot tables that are on a single page.
I have the tables all set and their labels are in place and I have the box ready with the reference to the list of years - which is the common value in the tables. However, when I opened this workbook for the first time in a couple of years, the code that made the box work is missing. Right now, I am brain de... 10 Apr 2010 16:49

IF nested problem ..!
Good afternoon, I have been attempting to create a formula to do the following: In three columns: B, C & H. If B3 & C3 do not contain a value I want to H3 to also be blank despite H2 containing a figure. However, if B2 and or C2 contain a figure, I wish to display the result - if this makes sense! The existin... 11 Apr 2010 09:02

How to convert text "JAN" into number 1?
Does anyone have any suggestions on how to convert text "JAN" into number 1? Does excel have any built in function to do it? For all the months' symbol into numbers "JAN" into 1 ... "MAR" into 3 ... "DEC" into 12 Does anyone have any suggestions? Thanks in advance for any suggestions Eric ... 10 Apr 2010 16:49

Autofilter header row
My experience has been that the first row is where the controls (down arrow) appear when autofilter is invoked. But I've now been sent a spreadsheet (just unformatted data in a large table) where the autofilter chooses the second row. I've compared the new spreadsheet with previous versions and don't see any di... 11 Apr 2010 12:21

Audit Trail
I would like to build an audit trail into a spreadsheet so that anyone who opens the file is is logged in a worksheet with user name and time stamp. What's the easiest / best way to achieve this? -- Rich http://www.rhodes-pefkos.co.uk http://www.rhodes-lindos.co.uk ... 10 Apr 2010 16:49

Cell Referencing
Hi, When I refer to a cell in another spreadsheet, the cell reference always automatically defaults to absolute (e.g. $A$4). In most cases I don't want the $ so have to manually remove them which is time consuming. Is there a way to change the options in Excel 2003 so that the $'s don't appear ? Thanks ... 10 Apr 2010 04:48

Excel Jululian
Please help in this formula {=SUM(('[Summary1.xls]A1 1-3'!$C$3:$C$19268=B$11)*('[Summary1.xls]A1 1-3'!$E$3:$E$19268=$A9)*('[Summary1.xls]A1 1-3'!$G$3:$G$19268=$H3)*'[Summary1.xls]A1 1-3'!$S$3:$Y$19268)} the result should read 24 anf it give 0 please advise regards ... 10 Apr 2010 13:31