I tried to used a link in an OFFSET function this way:
=OFFSET([abc.xls]Sheet1!$A$1,0,0,1,1)
where I pass as a first argument a external reference
(link) to another file.

I'm having a big problem with excel...
All the links that I had in my excel file to over 300 images in my pc
have been suddenly change to this:
"mk:@MSITStore:C:\Programme\Microsoft%20Office\Office\1031\xlmain9.chm::/html/directory

I was wondering if were possible to create a macro that would insert a
specific number of rows based on information provided and then
populate the inserted rows with information provided?
For example I have the following columns in sheet1:

Can you help me to find the way to retrieve the week number from the
computer date. There is an excel function for it??
Thank you
Shaul

I am a student at a community college just starting excel 2002...my teacher
is an arrogant bastard and told everyone in class they couldn't write or
find a formula for a bowling score sheet. And he was correct about writing
one I tried and with the statements I know it would take 3 ...

I have a Pivot-Table that gets its data from an OLAP-Cube that is
generated from an .mdb-File (Pivot-Wizard: "external source" ->
"OLAP-Cube"). This means that the .xls-file is linked to an .mdb-file
with an absolute path. Now I need to relocate the database, but I

Hi..
i have a spreadsheet linked to 1 or max 2 other
spreadsheets, which supplies info to various people across
our network.  Due to varying network speed, when someone

I no longer want two workbooks linked and as I didn't create the links
initially I have no idea how to get rid of them.  They don't need to be
linked at this point.
thanks

I work in the Juvenile Justice field and use excell to
record forthcoming appointments, review meetings etc.for
young people who receive supervision orders.
I would like to automatically send 'name' and 'date/time'

Does anyone know if the ChangeLink command in VBA can be
used with a Range or Cell, and if so how?
Cheers
Joe

I found on excel helpfile the description of the functin DATEDIF
but it does not exsit on excel function list.
Can you help me find it?
Thank you

I'm trying to retrieve data from an Excel ODBC data source using the OLEDB
ODBC drivers all seems well, my ODBC source seems happy, and the ADO call
talks to the ODBC source, but I'm getting an error back complaining that
"object not found 'LIST'" from "select A FROM LIST" where ...

I have a function F() implemented in an XLL, which depends on cell C.
Even though it calls Excel4(xlCoerce) on that cell, Excel doesn't seem to
add the cell to the dependency graph.  As a result, changes to cell C don't
cause Excel to recalculate cells which call F().

I have a file that I have created that provides a summary of data from a
series of weekly produced files. It has also been set up to accept data from
files that will be produced for the rest of the year.
The problem I have is that whenever the summary file is now opened and I

I have a workbook with a worksheet that contains multiple graphs. I need to
create OLE links to each graph and display the in object frames in a MS Access
database. It seems that I need to be able to refer to each graph in the
"language of Excel". I need a way to express the path to ...