I have a new problem that's come up after upgrading to Office 2007.

I am linking my reporting workbook to the daily workbook that is updated by
someone else. The cells I am linking to are merged cells. When I insert the
link I get... ='[0203 Company 2.xls]Day'!$J$5:$J$6 which results in a
#VALUE error unless I remove the last part of the formula (:$J$6).

Any ideas on how to get around this? It's taking me twice as long to set up
my links now. THANKS!!!!