Maybe you can visit your IT folks and ask for special dispensation.
Maybe you can visit the site while you're at home and bring it to work (or email
it to work).
Maybe you can open all the sending files and use excel's =indirect() function.



Meenie wrote:

:( I tried to go to that site, but my networks "Barracuda" says I'm not
allowed to go there <sigh

"Dave Peterson" wrote:

The bad news is that David's suggestion to use =indirect() requires that the
sending workbook be open. And then you wouldn't need the drive/path information
in the formula.

But the good news is that Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that allows you to return values from closed
workbooks.

David Biddulph wrote:

=INDIRECT("'C:\Documents and Settings\hawthos1.RHS\Desktop\Susan''s
Documents\Dir Michelle W\Chart and Falls Audits\Falls
Audits\["&TEXT(DATE(2008,ROW(A1),1),"mmmm yy")&" Falls
Compliance.xls]Compliance Question 2'!$B$9")
and copy down.
--
David Biddulph

"Meenie" wrote in message
...
='C:\Documents and Settings\hawthos1.RHS\Desktop\Susan''s Documents\Dir
Michelle W\Chart and Falls Audits\Falls Audits\[January 08 Falls
Compliance.xls]Compliance Question 2'!$B$9

I want to be able to move it down one cell in all of my worksheets so
"January" changes to "February" but nothing else changes in the
formula.???

"RagDyer" wrote:

What does your formula look like?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Meenie" wrote in message
...
Let me try to make this problem clearer...
Actually for all the work areas, there is a work book for January, one
for
February, one for March... etc.
I made a yTD workbook with a page for each work area that has a column
with
all the months and beside January, I linked to the Workbook for January
for
each work area and the number is there on each page. Fine.
But when I drag the formula down for February, it doesn't change
January
to
February in the Formula... how can I get the month to change without
changing
anything else in the formula? It's quite a few pages and I don't want
to
have
to go to each one and do it manually.

"Meenie" wrote:

I have excel 2003
I have a workbook that has numbers relating to each month of the year
for
several different work areas. There are 4 weeks of data on each sheet
with a
summary page showing the average for the 4 weeks for each work area.
I made a ytd workbook where I have a page for each work area that will
show
the the months listed with the average listed beside it.
I linked to the first workbook. The problem is, how can I drag the
formula
down so the month changes? When I drag January's average down to
February's,
it still is linked to January in the formula. I tried grouping all the
pages
and clicking in February's cell and changing January to February, but
it
changed all the cell references to the first sheet also so that didn't
work.
Then I tried using Find and REplace under Edit, but that changed ALL
the
January's to February everywhere!
What am I doing wrong?
Thanks :)




--

Dave Peterson


--

Dave Peterson