General

Problem with subsets for multiple Report Filters in 2007 PivotTabl
I have 2 fields in my PivotTable's Report Filter section - 'Country' and 'City'. When I filter by 'Country' it doesn't automatically restrict the possible values in the 'City' filter to cities within the selected country - any ideas how to do this? I'm sure 2003 used to do this sort of subsetting :( Any ... 21 Apr 2010 11:33

Combo Box
Hi, I am trying to create a combo box for first time. Have followed instructions from Debra Dalgleish website, but the combo box will not appear or be activated when a data validation cell is double clicked. I have also downloaded the example from the website and again when the cell with data validation is ... 22 Apr 2010 04:07

Calculating Sum Series
Greetings, I can't seem to find a formula to do series of sums. I would like to calculate the following series: For n = 0 to n=B1/B3 sum: (A1+(A2*n))*A3 Thank you for your help. Deluth ... 21 Apr 2010 03:16

Mandatory/Compulsory
Hi Sir, I need to put a formula for a cell as mandatory/compulsory it has to fill, otherwise it will not go to the next cell. It has to display (customized) error message. Can anybody help me in this regard? I have Office 2000, 2003 & 2007. It has to work in all versions. Rgds, Md.Siddique. mdfiaz2000(a)gmail.... 21 Apr 2010 08:26

How do I add extra data to a pivot table?
I know this might sound slightly simplistic, but my pivot table pulls data from a separate tab. I know if I go in and amend the data in that table and then save and restart, the data in my pivot table will change accordingly. What I cannot figure out is how to add extra rows that will be reflected in the pivot ... 21 Apr 2010 09:28

find and copy it..
hi all... hoping u can help me for saving my time. i have a master data in sheet 1 with more than 1000 rows. and now in sheet 2 i want to copy data from master in sheet 1 which some condition. i.e in sheet 1 Col A(ID), col B(name), Col C(city), Col D(address), Col E(birthday), Col F(Status) etc (until col J(... 21 Apr 2010 08:26

Excel Spreadsheets formulas don't update
Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum. ... 20 Apr 2010 23:01

Excel Spreadsheets formulas don't update
Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum. ... 21 Apr 2010 02:14

Search and Replace, or Add New Row
I am using Excel 2003. Worksheet1 contains columns (A) Invoice (B) Name (C) Address (D) P.O.# ... and others. I need to perform a search of column A using an invoice number and if it IS FOUND, then replace the entire row with new data. If the invoice number IS NOT FOUND, then I need to add a new row.... 21 Apr 2010 04:18

How to use the "shell" command?
Hi, How can I use "shell" to move from Excel to the current (default) web page to copy some comma delimited text data, then open Notepad and save it there? I then can open the saved text in Excel with the captured text displayed as column data and rearrange it. Thanks for any help. TIA Tom ... 26 Apr 2010 20:38