I just looked at the help menu right now.
I think that makes sense. I'll try a few ideas later.

Thanks for the look,
Ryan---

--
RyGuy


"Jim Cone" wrote:

Did you look at the help file as I suggested?
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





"ryguy7272"
wrote in message
Well, because of the formatting, everything gets really screwed up if I try
to copy and paste to a new sheet. Also, there are some merged cells, and I
encountered some problems when I tried to paste the Summary sheet it to a new
worksheet. then right-click and create new sheet method works well, but I
have all those links in there and every time I rerun the model all the data
in the linked files gets updated...but it shouldn't be updated!! Can anyone
think of any other workarounds? Or, can anyone think of a way to use VBA to
break those links?
Regards,
Ryan---
--
RyGuy