I have a column of about 1000 dates in Excel 2000, all of them entered in
text format..
All the dates are different and written as in the following example:
20Feb1950

I have an order log which is added to on a daily basis.
I have made a pivot table from this to show ordering by divisions, suppliers
etc.
However, when I add new orders to the log, the pivot table does not update.

When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?

I'm having trouble with the following code. I'm trying to turn on an auto
filter using a value in the range below. From there I'm doing some things,
and then I want to come back to the next value in the range, skipping blanks.
Dim cell As Range

I have a column of data that contains a 7 digit number in each row. I
need to insert a hyphen after the 2nd number for formatting purposes.
Any easy way to do it? I am getting tired of the copy and paste.
Example below

Hi, I am working on a large excel 2003 file which, although not linked to any
other files, has a large number of formulae linking to other worksheets in
the same file. When I change the value in the one cell it doesn't
automatically update the value in the cell which is ...

I am new to excel. It is so confusing. I am trying to figure how to print up
a blank spreadsheet with blank cells. If I leave the cells empty, the
gridlines do not print. Only the cells with text in them show gridlines when
printed. I am trying to make a sign-up sheet where ...

When I open a file and chooses to update links, I get the #VALUE! for
links to a spesific file (the rest of the links update OK). Then I
have to open and close the file where the links points to get rid of
#VALUE!. Does this have to do with which vertions of excel the

I have a huge spreadsheet where I need to remove the lavender fill color
only on the cells that have no text in them. (I want to keep the lavender
fill color in the cells that do have text.)
I tried Find/Replace but it tried to remove the fill color for every cell.

I am trying to set up a vlookup formula to match two database. Following is
the example :
Sheet A List :
Col.A        Col.B

My formula isn't working and having tried to solve it for the past hour -
I'll not throw it out to you clever lot.
I have two worksheets. one is of cash recvd and is laid out like so
A           B             C           D

I know there is a lot of content out there about dynamic range in charts but
as far as I can see my problem is not covered yet (forgive me when I'm wrong).
Problem:
- I have one value to display in a chart, e.g. value=0.5 (cell A1)

I was wondering if there is a way to make a put down menu that acts like a
note pad.
This idea is for data entry. I have the person info, on one row, but i want
to keep the page or work sheet neat. Having a pull down menu that allow me to

I am creating a worksheet that keeps track of each member and how many
minutes they workout at the gym for each day. I have a cover sheet that pulls
information from the information sheet using vlookup functions based on the
identification number entered. I also am using the Now ...

I have just seen an excel spreadsheet that had a similar view feature as in a
MS project file. The first three columns were numbered 1,2&3 and it had a
plus sign which when clicked displayed their respective subtasks. Hope I have
explained this properly!