I may have breakup the formulas as you suggest (similar to Dave Peterson's
response). However, it is very time consuming to do this since I have about
7 columns that are invovled.

As for the named range idea...how would that work with each year? I usually
Save As the prior year file into the current year folder. This would make
the named range the same between the two files. How would I update it to
look at the new file? I haven't dealt much with named ranges.

Thanks!
--
Audrey G.


"Jim Thomlinson" wrote:

Since all you are doing is adding up some numbers try breaking the formula up
into 2 or 3 formulas and then add up the results. Alternatively you could
make the individual cell references into named ranges and then add up the
named ranges...

Insert - Name - Define
Create a name such as BisBudget
and in the reference add
'Z:\Finance\Budget & Financials\Business Plan\2009\Operating Exp\[Oper
Exp-Bis.xls]2009 Budget'!$I7

Next year you would just have to change the named range references...
--
HTH...

Jim Thomlinson


"Audrey G." wrote:

Have a formula that links other files to master file. Links must be updated
annually to look at new folder and file name within certain path. I'm not at
liberty to shorten the folder or file names (company protocol).

When I try to change the source under Edit -- Links, I get "Formula too
long" error. This has not been the case in prior years. How can I get
around this error? I have also tried Find/Replace to simply change the
years, which would do the same as changing the source, but I still get
"Formula too long" error.

I need help on this one fast, as I have to provide worksheets to managers
today! One formula is as follows:
=+'Z:\Finance\Budget & Financials\Business Plan\2009\Operating Exp\[Oper
Exp-Bis.xls]2009 Budget'!$I7+'Z:\Finance\Budget & Financials\Business
Plan\2009\Operating Exp\[Oper Exp-Corp All.xls]2009
Budget'!$I7+'Z:\Finance\Budget & Financials\Business Plan\2009\Operating
Exp\[Oper Exp-DM.xls]2009 Budget'!$I7+'Z:\Finance\Budget &
Financials\Business Plan\2009\Operating Exp\[Oper Exp-FW.xls]2009
Budget'!$I7+'Z:\Finance\Budget & Financials\Business Plan\2009\Operating
Exp\[Oper Exp-JC.xls]2009 Budget'!$I7+'Z:\Finance\Budget &
Financials\Business Plan\2009\Operating Exp\[Oper Exp-LS.xls]2009
Budget'!$I7+'Z:\Finance\Budget & Financials\Business Plan\2009\Operating
Exp\[Oper Exp-LW.xls]2009 Budget'!$I7+'Z:\Finance\Budget &
Financials\Business Plan\2009\Operating Exp\[Oper Exp-MH.xls]2009
Budget'!$I7+'Z:\Finance\Budget & Financials\Business Plan\2009\Operating
Exp\[Oper Exp-SJ.xls]2009 Budget'!$I7+'Z:\Finance\Budget &
Financials\Business Plan\2009\Operating Exp\[Oper Exp-Top Total.xls]2009
Budget'!$I7

Thanks!
--
Audrey G.