Bernie, could you put the references into a named-range...

RangeName:
LogRange

RefersTo:
=[c:\documents and settings\myname\my
documents\myOthersheet.xls]Logs!$A$1:$H$10

then the formulas would use the shorter name "LogRange" to represent that
link?

--
Regards,
John


"Bernie Deitrick" wrote:

Rob,

Sorry, but no. The way around this is to put each link into a separate cell, then make your formula
using only those local cells.

HTH,
Bernie
MS Excel MVP


"Rob" wrote in message
...
Is there anyway to have Excel not put the path in a formula when renaming a
file. I have some large long IF statements in my workbook and when I save
the file in a different directory and then try to reopen, I get a "formula is
too long" error. These functions are linked to other spreadsheets on
different drives. Can someone please help?