Please help! Thanks!

I have designed a pivot table that I intended to update each month.
My data table includes a column for the date at the monthly level.
Until this month, it was working fine.  As each month passed, I would
simply check off the new month in the drop down menu in the pivot

When opening a new workbook in Excel 2003 the Doc Mgr toolbar always opens.  
I have gone to Tools>Customize>Toolbars and unchecked the entry but to no
avail.  It removes it for the workbook I am currently in but as soon as I
open another workbook, there it is even after exiting ...

Dear Excel Gurus,
I am wondering if I can somehow pull the coefficients from the trendline
equation and display them in cells separately, e.g if the equation is
y = -5.21250E-21x5 + 2.35760E-17x4 + 7.99900E-13x3 - 4.69050E-08x2 -

I have a workbook with 2 sheets.
Currently - Sheet 1, A1 is a dollar amount entered by the user
Sheet 2, B1 references Sheet 1, A1 and is locked.
Now - We would like the user to be able to change Sheet 2, B1 and have

My userform has a combo box that upon entry event is populated via a sub procedure.
The sub procedure defines a column of data on the active spreadsheet as a range and manipulates the range to add unique values only in alphabetical order into a collection.
Which the collection is ...

I'm trying to get the cell reference of a value looked up in a table.
For example:
A table of values are found in A4 to J13 (10x10 table).  A4=1,
B4=2,A5=11, B5=12 and so on (ie 1 to 10 is in the first row, 11 to 20

I have been running the following macro and it works fine except i have to
push button 6 twice to get it to recalculate and display the correct number
in cell c14. can anyone tell me why and how to fix this annoyance.
Sub Button6_Click()

We have Macros in our excel worksheets. In Excel 2003 when opening an excel
worksheet with VBA code you could set it to ask on opening if the macros
should be enabled or not and the question had to be answered before
continuing, however with Excel 2007 you are asked but in a much ...

Okat, a spreadsheet with two tabs. Let's say tab one has | UID | DOB | NOSE
SIZE | (for example), tab 2 has |UID| No of Ears | Nose hair |
I would like to take duplicates where UID is the same out of tabs 1 and 2
and put into a new tab with | UID | DOB | No of ears | Nose hair | ...

What is the best way in EXCEL to compare two spreadsheets so I can determine
any differences in content?
Each spreadsheet would have the same # of columns and the same # of rows.  
The only difference would be the data within some of the cells.

Is it possible to replace multiple values within a string simultaneously?
eg. I have over 600 records of links to external workbooks where each fiscal
period I need to change the Period #
='F:\VC FPBS\FY07-08\Performance Analysis\Community\P07\[VC Consolidated

I have an interesting situation where a client is interested in only
entering the year in the field but the a date format.  The
unfortunate year result is 1905.   Even with a custom value such as
yyyy Excel still returns the 1905 "year".   Now after some reading on

I would like to subtract 15% from a cell which already has a formula.
for example:
=SUM(3600/H16) This gives me an answer, but I now want to take 15% off
that answer without using any other cells.

Hey all,
I am having issues with excel crashing when I go to save the document. I
believe it has to do with the macros but am unsure at this point. The sheet
works perfectly fine in Office 2003. Attached is the error message. Any