Hi Guys,

I have the formula

=OFFSET('G:\Budgets & Estimates\Budget 2008\S08 Forms Consulting and Retail\Retail\[S08_form_LM.xls]Operating RevenueYTD'!$D9,0,Start!$B$55)

Which only works if the linked file is open.

The formula when the file is open is represeneted as.

=OFFSET('[S08_form_ML.xls]Operating RevenueYTD'!$D9,0,Start!$B$55)

I as using 2007 and my inkling is the length of the formula as it comes up as a compatabilty error message when I try and save it as a 2003 file for my co-workers.

Is there anyway of truncating the formula without renaming folders or files. Maybe some sort of concatenate formula that joined say the file folder and file together.

Would appreciate anything that anyone can suggest.

Cheers,

R