Let's keep the problem simple.
I have one cell that uses an exchange rate from the internet.
That cell changes every minute.
What I want to do:

In XL2003, I would click the X in the upper right corner and all Excel
files would close.  Now in XL2007, I must close each one
individually.  So does that mean that in XL2007, each file opens in a
separate process like Word does?

hi all, i'm not much of a guru with Excel. how do i prevent the #DIV/0! when
a column i'm dividing by is a 0.
i'm using Excel to calculate the Delta %. i'm using a simple formula
(K-L)/K. a lot of rows have values but obviously if for example K9 is 0 i'm

When I go to Windows -> Freeze Panes, I encounter this error. Any idea on
how to solve it? Thanks in advance.

Hi i need some formula calculation.
i just want to use this formulas for payroll purpose.
For Eg. If Column B6    shows Start Date,(01/08/1980)
Column B7 Termination Date.(01/05/2008)

I'm using Excel 2003. I can create columns, rows, data, new worksheets, etc.,
so I have a very basic knowledge of using Excel.
With that said, here is what I'm trying to accomplish:
First of all, I'm the manager of several apartment complexes. We have

Anyone here familiar with "Office 12" version of Excel and how to enable
split-panes?  I''ve been trying to coach a friend via email on some Excel
features and only now discover that we aren't even using the same version.
I'm working with the "Office 2007" version, and my friend ...

In my sales worksheet, in the last column I need to put a formula in
order to sum the values for each month, I mean, sometime I need the
accumulated value from jan to june or jan to may for example.
Then I need to put this formula (in case of line 2, but I have many

I would like to write a macro that essentially does a Find and
Replace, but instead of replacing with a string, it replaces with a
reference to a cell that contains that string.
As an example, the meat of the macro currently looks something like

I am a excel n00b so, please be gentle!!
I have a caolumn with a list of values of cars like:
Ford
Chrysler

I created a Macro which will be used by different users. In this macro I do
add a new sheet which I want to rename.
However based on the regional settings the new sheet will receive a
different name. I.e. in US a new sheet will be named "Sheet1" in Dutch it is

I have a sheet of data where in column C I want to insert Chr10 in
each cell at the point where if I'm doing it manually I F2 to edit the
cell then Ctrl L Arrow thrice...
I've tried recording a Macro to do this but it just includes the text

I need a macro that will basically look at one column and if it says
“Yes” put the email address in the email column in the .bcc.  All the
email addresses need to be in one email by the way.  Here is what my
data looks like starting in A4:

I have an Excel spreadsheet, and derived from it 5 charts.
How can I attach one of the charts to an email to send to
someone?
(I know how to attach the whole spreadsheet, and the

I have created a spreadsheet for filling in details in a section and I want
the user to input the data as and when it's needed.  It contains the field
headers to guide the user to fill-in the correct data)
I created a macro to copy the section of the spreadsheet  i.e. rows 3 to 10 ...