I have the following issue:
I have a sheet, which is protected with "select unlocked cells" only.
That makes sure, that the user cannot change the format of one of
the unlocked cells.

I have a pivot table which I want to show various bits of information from a
block of data. For each group, I want the table to show both a Subtotal
amount and a Subtotal Count. So far, so good.
Problem is down at the Grand Totals. I am unable to select a "second" Grand

can anyone open my eyes on this strange problem:
I need to open a workbook on the fly to be able to read data from it
via VBA.
This piece of code is working while on a button called via click:

I am having trouble converting excel to SQL.  The columns i am having trouble
with are Text columns, but most of the data is dropped and only data that is
alphanumeric is converted.  I would like to know how to fix this.  If i
change the alphanumeric data to numeric, that is the ...

I work in manufacturing and have pulled a set of data off our product
checkweigher:
442.2   452.2   462.2   472.2   482.2   492.2   502.2
       1       17      212     1791    470     41

I copied company logo to a new workbook.  It appears on top of page (line 1),
but prints out half way down the page.

I have a column of dates, and at the bottom, I want to calculate the
number of days between the first and last dates. I' using the formula
  =(DATEDIF(B6,B15,"d"))
The problem is that as I add dates, I have to edit the formula to

I'm not really sure how to explain this, but I'll do my best.
Cell A1 = 10  -  Buy
Cell B1 = 20  -  Current
Cell C1 =SUM(B1-A1)  <-- which would be 10 -  UnProfit

I'm trying to take one date and time away from another but having a problem
fathomining it out
eg
01.04.2008 10:55:27 - 01.04.2008 9:37:13

I'm sorting text that is alpha-numeric in origin in ascending order.
ZFT14
ZT81
ZDT21

I am trying to insert a watermark on my excel worksheet.  I want it to print
on ALL pages.  Does anyone know how to do this?

hi there everyone,
I'm hopeful that someone can help me with my excel problem. Here's my
dilemma: I'm trying to do a results table where results will come from a
worksheet that has different columns, one of which is a date column(let's

I have a range of cells that I want to ck for a "Y", then in the next range
can be "STOP" or a value of "Go"?  Kinda a mix of conditions.

I need to put the password of my ms access database in this code
below, but I don't know where.
This is a query to delete some data in ms access, that I run it in
excel.

Hey Guys
I'm using the following code to set the colours of the slices of all
the pie charts in my spreadsheet based on each slice's legend's label:
VB: AutoLinked keywords will cause extra spaces before keywords. Extra