Replacing Two Items Together-Urgent

[Guest]

I have copied a set of formulas from the last months' statement, referring to
two different sheets to a new workbook. The problem is that I cant replace
both links in the formulas by ctrl+h, and the results is that "The formula is
too long".

Any idea how to replace two different items together, with two different
items?

Thanx!

 

[Dave Peterson]

Maybe you can make the references to the other worksheets shorter--open the
workbooks so that the paths are removed from the formulas. Change the worksheet
name to something shorter may help, too.