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

Many, Many, Thanks Gavin!!! - didn't think of the looping technique...works like charm. -Ed

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...

Thanks guys for the responses. However, I'm still grappling with this. Let me restate what I've done. I've created a Pivot table that has a text field that I'm using as Column Header. The Column Header title is pretty long (it's a question) and therefore I've formatted as wrap-text. The...

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...

Thanks JP for the response. After much searching the document (and virus scanning just in case) I discovered that I somehow modified the Color palette in that workbook. Fixed the issue by just resetting the palette to the defaults. Can't for the life of me figure out how I managed to change...

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...

Thanks Skip!!! Worked perfectly! Thanks for the idea...i'm a bit rusty in my vba coding and appreciate you help with these seemingly simple questions:) -ue

Thanks for the reply Skip!! Yes, I do have other pivot tables in the workbook, they each have different PivotNames. Is there a way to specify in the look just to look at the Pivot Tables that have a specific PivotName? What does Excel to when you create multiple pivot tables via the...

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...

Thanks Skip...that got me going in the right direction, howver, I'm not sure what I'm doing wrong here, but I can't seem to get the targeted worksheet copied to the main file. I've declared CurrentWorkbook as a String and assigned the source workbook. When I attempt the Copy command, I get a...

Thanks for the tip PHV, got me going in the right direction! However, now I'm trying to cycle through the worksheets of each open workbook to determine whether a worksheet exists. Here are the loops I have...I can't figure out how to reference the workbook and it's associated worksheets (i've...

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...

I think I found a solution (I don't necessarily like it however). I found forum that discussed this and provided a solution. I incorporated some of this and my code is as follows: cmdCommand.CommandText = "delete * from Opportunities" cmdCommand.Execute Set openXL =...

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...