Here is the setup. I have three columns (Month, Day, and Number Collected)
that I am trying to obtain weekly totals for by using the dsum function
=DSUM(A1:C65,3,H1:I2). My criteria appear as follows:  H1-Month         I1-Day
H2-March         I2- ?

I have several work books link to a master work book I use to update part #,
prices, materials, etc.  My question is- is there anyway to add rows or
delete rows in the source work book with out changing the destination data
that is link to the master work book?

The document i exported to excel from IE, i can Not find PLEASE HELP need asap!
c.hooks123@yahoo.com

I did not download the "Compatability Pack" but somehow I seem to have been
blessed with it regardless. The problem is I do not want to open XL2003 files
in XL2007 as it can lead to loss of data (particularly any formulae that use
the XL2003 Analysis Toolpak).

I have a worksheet with a hidden column.  I want people to be able to access
the worksheet and make changes/entries in it in every cell except the hidden
column.  When they make their entries and save and email the worksheet back
to me I want to be able to access the hidden ...

This is a very general and basic question. However, I would like to know if
you have any recommendations for printing various styles and sizes of excel
documents to their optimum size on the printer page.
Previous ways that I have done this include...center aligning data onto the

I'm using Excel 2007. I'm not sure if there's a way to do this, but I want to
have more columns/different width columns in a couple rows here an there than
I have in the rest of the rows. I need some of my columns to be a little
wider/skinnier than others without shrinking them ...

I've been trying learn, very slowly, how to do some things with macros.  The
book I have, as well as many of the posts I've read over, say to not Select
things, but to just act on the range or cells directly.  I'm posting part of
a macro I've written with a couple of questions in ...

I am using Office 2007 with Vista on a new computer.  Long tyime user of the
Office products but never experienced this issue before.  When I send a file
as an attachment to an email and try to send the email from Excel, the email
will remain open for several mintues instead of ...

I have 250 plus seperate excel spreadsheets that I need to merge into one.
They are all formatted the same and have all of the same fields. They just
have different data that I need to consolidate. Does anyone knnow of a way to
make this happen other than copy and paste each ...

I have been using XP on a laptop which has suffered a major problem. Put the
wrong disc in and reformatted losing all my data - Silly me.
Any way it was quite old and I wanted a new one anyawy so bought a new one
running Vista and put Office 2007 on it..

Hi, I'm trying to create the following two formulas in two separate columns.
Column G (Annual Salary)  Column J (STD Benefit)  Column K (LTD Benefit)
In Column J My Formula is =(G9*(0.18/10))*12/24+IF(G9>173200,2000,()) Where
weekly benefit amount cannot exceed $2,000.  I'm not ...

I have the MS Office Disk and it seems this is a common missing file but
where can I find it so I can add the solver add-in.  Any help would be
greatly appreciated.

Good morning.  I have a spreadsheet that contains a pivot table and am
wondering if there is a formula that can be used at the top of the
spreadsheet to provide the last date the pivot table was refreshed?  Any help
is much appreciated.

I have a column of data, some of which I want to mathematically operate on
and some of which I do not.  The cells which I do wish to use to flag the
need to operate will all contain text that starts with the letter "U".  Is
there a way to say in an IF Statement "IF cell B3 ...