worksheet copying, changing source link

sometimes i get a "formula too long" message when i copy a worksheet from one
workbook to another and try to change the source link to the new workbook. is
there a way to avoid this because it gets locked up when this happens.
--
john

shorten the name? or the formula or use defined names

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"jtaiariol" <jtaiariol@discussions.microsoft.com> wrote in message
news:CE0B4E99-22C1-4318-9058-B55C3A26D1C9@microsoft.com...
> sometimes i get a "formula too long" message when i copy a worksheet from
> one
> workbook to another and try to change the source link to the new workbook.
> is
> there a way to avoid this because it gets locked up when this happens.
> --
> john