Hey, wonder what I might do here. Using excel 2007 to link to a sharepoint "list". I then "pivot" this list for a variety of reports. However, when I...

I want to add a column to a speadsheet that has been conditionally formatted, I want the column to be included in the rules. How do I do this?

Hi, I have a cell with the following conditional formatting =AND(S2TODAY(),W2="",D2="x") If these conditions are met the cell S2 is bolded in red. I need...

I created a custom theme from an exisiting workbook (2003). I tried to apply it to a new workbook by clicking the icon from Themes. It doesn't change from...

When I try to change anything in option I get the error "cannot access directory J:\\" I no longer have the flash drive that I used when I original set the...

is there still no fix for this or am I now alone in aeropeek on win 7 with excel 2007 working intermittently or not at all with more than one file...

Is there a way to stop a worksheet from accepting data after a certain date? I have a workbook with 26 worksheets, 1 for each pay period. I would like to...

I no longer have a flash drive that I had previously used. How can I get past this error?

I have a cell AD7 with a formatted date "dd/mmm/yyyy" to count orders and i need to count how many orders for each month. how do i count MMM as 1 to another...

Hello, Can any one help me with my dilemma he I am tring to convert my "cross-table" looking table to a regular table, see below details: "cross-tbl" clmn...

I Have a workbook with a number of sheets one is Stock with headings "Item(Number) Category, Stock, On Order, Sold then sizes 7*5, 6*8, 9*6, 12*9, A3. I...

Hello, I would like to change the font, positioning of text etc. on my dropdown menu items. The items have been stored in a cell range on another sheet. Is...

I find the choices of marker options for plotting XY-Scatter plots is quite limited to just 9 characters (like box, triangle, star, +, - etc.,). Is there a...

Hi I have a column of around 2000 customer mobile numbers, the numbers are having space in between nad some numbers entered with two zero in the front. How...

When creating a combo box with the listfillrange originating from an external spread sheet the combo box is blank when the spread sheet is opened. All of...

I asked about this before, but didn't really help, so I'll try rephrasing There are three columns, one for dates (Column A), another for amounts on each date...

Any way to insert a picture in a cell, fitted so as to set the row height/column width accordingly and making the same of the exact size? -- Thanx in...

How do you write in VBA:- to select a column then select the range of data held in the column (say B1) then return to Cell a1. The data in the column can...

I have a cell with a formula in it, this cell displays #NUM! as it answer. I want to be able to set the format using conditional formating so that this...