General

Pivot table formulas
How do I delete the calculated fields that I added to a pivot table? The field list for the pivot table doesn't seem to be modifiable. Thanks, Sduffield ... 28 Apr 2010 11:44

conditional formating
I have the following formula for column D and E =D2<Today() red =(D2-Today())<30 green I need to add a formula that if a date is in column c then column D and E are black. ... 29 Apr 2010 20:22

Excel 2007: Saving a file with a Macro
This question will seem silly, but I am going to ask in spite of that. I have created a spreadsheet/file with a Macro in it. When I attempt to save it as an .xlsx file I am given a message that includes the following: The following features cannot be saved in macro-free workborks: *VB Project To save ... 28 Apr 2010 10:36

Line charting the same series using data from multiple sheets?
I have data for each day of the week per sheet for four weeks, ie 4 sheets. I'd like to line chart this data on the same series using the data from each of the four sheets continuously. eg. graph (sheet 1) mon, tue, wed, thur, fri, (sheet 2) mon, tue, wed, thu, fri, (sheet 3) mon, tue, wed, thu, fri, (sheet 4) m... 29 Apr 2010 18:05

spreadsheet problem
66 years old. I have been asked to record daily my weight and blood-sugar count. I am using Excel 2003 on a Vista machine. I am trying to compare averages between doctor visits. I have both columns formatted as number (select column>format>cells>number, 2dp) yet when I try to sum or average the numbers,... 28 Apr 2010 11:44

col width
Hi all, I want to know the existing col width, what code do I need? TIA Jack Sons The Netherlands ... 28 Apr 2010 10:36

Autofill formulas when inserting rows in excel tables
Is it possible to have the formula in a column automatically be placed in a cell when you add a new row into an excel table (not a data table). Seems I saw this somewhere. ... 28 Apr 2010 09:29

Blanks ("") by Formula
Excel2003 ... Range (H3:H13) contains Formulas returning a space ("") Cell H15 contains ... =IF(OR(D1="",COUNTA(H3:H13)=0),"",SUM(H3:H13)) Cell H15 returning correct value when values in Range (H3:H13) manually entered ... but, now that I have Formulas in this Range returning a space ("") the COUNTA(H3:H13) ... 28 Apr 2010 20:53

Referring the cell instead of typing the sheet name
Hi, I'm just preparing a summery sheet for an work book that contains more then 60sheets (date wise) In Column B7 - Sheet Name(i.e. 26th April In Column C7 to G7 - Array Formula (i.e. {='26th April'!C21:G21}) In Column J7 to N7 - Array Formula (i.e. {='26th April'!J20:N20}) Is there any way to change th... 28 Apr 2010 10:36

Custom list limited to 255 characters? (XL 2007)
I have a client who claims that she could create longer custom lists in Excel 2003 compared to the limit of 255 characters that she managed to Exceed when trying to regain her customizations in the newly installed Office. It seems as if she is right? Anyone else who had this problem or can point me towards a b... 29 Apr 2010 08:59