I have a pivot table that we have sent to out side locations, They are
viewing this table as "read Only" although I haven't protected the worksheet.
Do you guys know of any setting I need to check that could have "secretly"
put this Pivot table as read only?

I have a table of daily sales transactions, but need to chart the data
by week (and month). I will be showing the sum of sales for a given
week as a single data point.
Is there a simple way to do this in creating the chart, or do I first

I have a pivot table that includes the sum of sales (a data field) and
the count of sales (a data field) by product.
It looks like this.
                      sum of sales       Count of units

First the spreadsheet we are talking about here was created in Excel '97 and
I am now using Excel 2003.
In each row I have a formula in column P that sums cells in the I & J
columns.

This is a strange one.  I have a person in the UK who can manually change
the format of cell from Euro's to $'s.  But, if we record the macro to do
that same action and run it on other cells (or the original cell after doing
an undo), it changes the format from Euro's to British ...

How do I split a street address field apart?  Field will have 2-3-4-5
digits, followed by a space then a series of alphas.   i.e.   837 Third
Avenue   -or-    6 Street West.
In a column of these address fields, wish to create two fields: the 2-5

I have scanned a document using OCR into Word 2007 with the RTF
format.  I have three columns of data.  I am trying to copy these
three columns to Excel 2007, but having a problem.
When I copy the data in Word, then paste to Excel, all the column data

Greetings.  I'm building a small free EXE that will do the following:
delete all EXD files
delete all files in docs and settings Temp folders and subfolders (for XP)
delete alll files in user Temp folders and subfolders (for Vista)

I am running Excel 2007. Every time I enter the word "cafe" it insists on
putting an accent on the letter e (Café). I have tried everything I know to
turn off auto correct (office buton/proofing) and I can't find where to turn
it off!

I want to transferring a data automatically by using
vba code.But need soeone to point me the right
direction.What I want to do is something simple.
I want the code to run if it meet some condition.

How do I remove all of those little triangles in the upper left hand
corners of the cells?
I think they get created when you change columns around.  They say:
"Formula omits adjecent cells."

I'm using Office 2003. I've set up a small sheet on my laptop, that contain
a few coloured cells.  On the laptop these coloured cells display fine.  On
my PC the colours are not there (but they are displayed in Print Preview).
Any help will be greatly appreciated.

I have the following scenario:
This is happening in both Excel 2003 & Excel 2007 using XP.
I am accessing an external data source though ODBC.
There is one table with Account Number, Date, Month, Amount.

While having a workbook XL file opened, is there a way/menu selection
that will allow me to see the full file path (under Windows XPpro) ?
and possibly the date that the opened file was last revised?
I fear that I might have opened an outdated file and making data

Hello all, I have a spreadsheet that was created using excel 2003, I try to
open it using excel 2007 and a password prompt appears. I know what the
password is, but how can I remove the password prompt on opening the file? I
don't want it password protected anymore.