Search results for query: *

Hi, I'm working with XL2007 and have a pivot table with many pivot fields along the columns. When I try to utilize the filters, the items are not in alphabetical order. I can force each one individually by right-clicking and selecting sort, but would like to be able to have all fields done at...

Anyone know how to change the default Chart fonts (i.e. titles, axis, etc...) in XL2007? When I create a chart, I always get a Calibri font and would like to change that setting to conform with the default excel font I'm using in the data (e.g. Ariel 10) Thanks, -ue

I spend a substantial amount of time working with pivot tables on a daily basis and find myself constantly having to re-format the pivot data field using the Field Settings. The default setting appears to be General and I am constantly changing to currency with no decimals. I'd love to be able...

Banging my head on this one! I've got a pivot table (Excel 2003) in which the pivot table options AutoFormat table is not checked and Preserve Formatting is checked. When I open the file and refresh, all formatting seems to be retained with the exception of the Wrap-Text cell formatting. If I...

Does anyone know of a way to conditionally suppress rows without using code? I thought I could simulate this using Auto-Filter and create "flags" on the rows that met a certain condition. This works, however, the filter needs to be reset whenever the "flags" are changed for the rows to hide...

I'm totally baffled!!! I run windows with the background color of light gray (changed from default of white). This makes the background of Excel worksheets gray color. I've got a workbook that whenever I add a Chart in it's own worksheet, the entire workbook background color changes back to...

I've got a worksheet with a large number of records that I need to break out by 1) Account Owner and 2) Customers so I end up with a separate Workbook for each Account Owner with separate worksheet for each Customer. I can do this semi-automatically via Pivot Table - Show Pages, and then...

I've got a pivot table with All as the Page Header and am using the ShowPages method to create indiviual worksheets for each item in the Page field. I would like to be able to select all these new worksheets and perform some formatting such as tab color, alignments, etc...on all these new...

I built an Excel reporting application that will create a Summary worksheet report on the fly. However, I want to allow the user to copy a previous Summary worksheet from another Open workbook (or closed) instead of generating a new Summary sheet. So basically, I would like to cycle through...

Hi All - I've got a weird problem here that I couldn't find in another thread. I'm importing and Excel file into an existing Access table using a command button on a form. My code (as follows), delete all records from the table then imports the excel records. cmdCommand.CommandText = "delete...