When I enter '=A1' in B1, and I change the value of A1, the content of B1
isn't updated anymore.
I think the formulas stopped working after installing Service Pack 2 for
Office XP 2003.

I have a form that I'm trying to add some code to that will require a
combobox to be filled in before it is closed.
The problem:
The code I've put under the userform_terminate shows the form, but it

Say I have an array with times and temps:
1:00     75
2:00     77
3:00     78

When auditing for cell dependencies and I get the dotted line with
arrow to another sheet and I double-click on the line to see the
ranges, sometimes the box is not wide enough for me to see the entire
sheet name.  I tried to resize it, but to no avail.  Is there a way to

I'm currently using vlookup to select paragraphs of information depending on
a dropdown list. The vlookup refers to an array in another sheet.
Is there any way of showing an image as well so that when I pick from a
dropdown list, it selects an image from one of the cells in the ...

s

I am trying to find a way of sum all values which precede todays date.
Date                   Payment   
01/01/2007    10   
01/02/2007    12   

I'm in need of some help, u have a column of dates which is called
"Target Date" in here are dates when actions are due by. I want to CF
the due date by a RAG style.
for Example if a traget date is 30/07/07 i want the cell next to it to

I have data that varies on a daily basis. There are three series of
data - sales, productivity and refunds. For every series there's
multiple data for each day. For example, on Monday 7th June there are
three sales figures 10, 20, 30; three productivity figures 10%, 20%

I have a spreadsheet with a list of codes on separate tabs, each tab
is named according to its category.
On the last tab I have a list containing of ALL the above codes, but
not which category the code is in.

My bank allows me to download my transactions to a CSV file.
Unfortunately one of the columns just has content such as 8.03E+11.
How do I get the actual content of that cell to display.  I actually
need the last few digits. Making the cell wider does not help.

If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get
another cell to automatically give me the last date of that month (i.e. 31
March 2007 in cell A2)?

I have an Excel 2003 workbook I get a message box stating if I want to
Update or Don't update a link.  I want to find where  it is asking for this
link within the worksheet or formula.  The problem is I have about 20 sheets
with alot of formulas.  How can I cut to the chase and ...

We have been using Office 2002 for 4 years, with approxiately 6000 users,
have a large selection of macros used by many of our users.
The question we are interested in is how much difficulty will be experienced
with Excel if we upgrade Office to version 2007.

tried to render the dates as general (text)... it works, when i select
a cell I see a number in the formula bar (ex: 39156). then I tried to
reconvert them to dates using a macro, it works, the dates a created.
When i click on cell I see a date in the formula bar (ex  2003-02-12)