General

autoformat add or change
Can you add a new auto format and/or change one. There is an autoformat list1 that hilites every other row in light grey is there a way to make it a different color? list 2 is green, but it hilites every two rows. ... 12 Jan 2010 18:35

Adv. Filter - Want to copy to inactive sheet
Hi Whenever I do Advanced Filter >Copy to another location, Excel wouldn't allow me to specify the destination (i.e. Copy to:) on worksheet other than the one I'm currently working on. Isn't there a way around this? -- Maki @ Canberra.AU ... 12 Jan 2010 18:35

Shared book (sorry!) bloating and not disconnecting
We have a shared workbook (which also has some VBA modules) which is shared over a WAN, and it's causing us some problems: 1. The user appears to be disconnected and has to lose unsaved changes 2. The file thinks it is still connected and shows all the users connected multiple times - even when they've switched... 12 Jan 2010 10:41

invioice email
how to send invoice as an attachedment email ... 12 Jan 2010 10:41

Pivot Tables
Does anyone knows how to display the values under the headers on the Pivot table? I have not been able to copy the values into a new work sheet and then filter them. I will show me only the header on that especific column. Thanks to anyone that can help me. ... 12 Jan 2010 12:58

One cell is printing per page
When trying to print a worksheet, one cell is printing per page. I have tried changing the width to 1 page Wide and "Automatic" pages tall, as well as resetting the print area, with no fix. When I change the scale %, it will move the page breaks, but then my sheet will not fit on one page. When I try dragg... 11 Jan 2010 14:16

MOUSE POINTER JUMPS TO TOP RIGHT CORNER WHEN I AM WORKING
While I am working in XL my mouse pointer jumps to the top right corner of the screen evry few minutss. How can I stop this? ... 11 Jan 2010 12:01

How to filter listbox data in a form?
A Form contains Filter dropdown for Year selection and a list box. How to filter listbox data based on selected year. Any helps or thoughts could be appreciated. Advnaced Thanks ~Vins ... 11 Jan 2010 09:46

Formatting a drop down list
The source from my drop down list has intentional strikethroughs on some of the entry fonts. However when i click on the drop down list, the strikethroughs don't show up. How can I have the font effects show up on the drop down list? ... 12 Jan 2010 09:34

cannot access office 2007 after windows update
i updated my windows and now every office program says" microsoft excel has not been installed for current user. please run setup to install the application" i cant access the setup ... 10 Jan 2010 15:14