is it possible to create a chart using information from cells in a different
excel file from the same pc.
thanks for any help.

In an other topic I asked about how to retrieve the filename from an
Excelfile.
Many solutions followed.
I tested many of them at home but, when i got to work they didn't work

I automatically save a copy of a file to a communal location (Y drive), so
that other persons may read it, using the following code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

How can you change the items in a list after you have made a selection in a
previous list: i.e. if you select 1 in the first drop down you want the
options in the next drop down to be A-K and if you select 2 you want the list
to be L-M.

I'm officially stumped regarding this formula. The formula works correctly
for month 2-12, but for month 1 the formula also returns results for cells
in the specified D range that are blank.
=SUMPRODUCT(--(MONTH(Reinstatements!$D$5:$D$77)=1),Reinstatements!$M$5:$M$77)

I seem to have trawled every setting but can't find this.
If you insert two fields into the Data Items section, they appear below
each other, but if you format with some of the AutoFormat's, such as
Report 4, then they appear next to each other.

I would like to extract the last names from a group of cells
containing a first and last name and place them into a separate
column. Is there an easier way to accomplish this other than
highlghting the last name and using cut&paste to move into the new

I have a row of data as follows:
0.8
23.7
42.0

Hey, people!! I need some help, I want to create an excel worksheet that
checks which files are in a directory (C:\) and lists them in my worksheet.
When I click on the listed files it takes me to the directory were they are
located. If you can open the files when clicked even ...

I appreciate that when a filter is active, the arrow turns blue. However, is
it possible to make this more visible, ie: make the actual button yellow for
example? Or even shade the cell which the button sits in, to yellow?
Trivial I know, but it would help if the active filter was ...

User A creates a Pivot and assigns the sort order of a column. If User A
opens and refreshes the Pivot the column stays sorted. If User B opens the
Pivot the sort order is lost in the column. If User A then reopens the Pivot
and refreshes the sort order comes back properly. We ...

I've a datadump from a database containing work hours from five different
departments, categorized as several different types like 'sick leave', 'on
training' etc and of course the usual workstuff categories...
I'ld want a pivot table of a specifik work type per department, like ...

If (for example ) I create an excel doc like in the forward example and
print it everything is O.K.
Example (4 column  * 4 Rows):
aaa    bbb ccc ddd

I read the help, but it doesn't tell me where to enter the formula.

Using Excel 2000, I've suddenly lost the ability to have different
spreadsheets appear in different windows (ie, to open Excel in different
windows) which I can move around the screen. They all replace each other in
the same window. I can toggle between them using the list in the ...