SOS--need help w/copying worksheet of formulas

[dtcmp]

I have a rather large worksheet loaded with complex formulated cells. I need to copy the sheet and add it in other worksheets related to other dates. When I do this, within the formulated cell, there is a reference to the original worksheet i.e. October2010 example:
=SUM('T:\[October2010.xls]input'!AL102:AL111)

How do I copy the formulated cells worksheet without the references? I need to do this for every month of the year for several different venues and add it into existing worksheets.

 

[p45cal]

You could edit links, this will allow you to change all the formulae in one swoop.
pre Excel: 2007:Dit|Links…
Excel 2007 onwards:Ribbon: Data|Connections|Edit Links

 

[dtcmp]

Thanks--I'll try it!

 

[dtcmp]

Ok--I thought you were giving me a link to follow. It's 2003 Excel and I don't have the manual. I'll search for what you said and if you have a website that I could go to directly, much appreciate. Thank you!

 

[p45cal]

pre Excel: 2007:Dit|Links…

should read:
pre Excel 2007:Edit|Links…
meaning you go to the standard toolbar in excel 2003, choose Edit, then choose Links…

 

[dtcmp]

Thank you!

 

[dtcmp]

I attempted it and even unlinked when I go to copy the sheet with formulated cells to create a new worksheet separate from the one I copied it from, it still drags over the reference as to where I got it. Now if I go to drop it in a new worksheet, will it attempt to link back to that reference or not? I really appreciate your help; I'm trying to help a new client that I want to keep as a client as they are my only regular client at the moment and if I can't do this, I may lose them.

 

[p45cal]

So why don't you edit the links after copying (in the new sheet)?

 

[dtcmp]

Ok--so if I understand you correctly, first I make a copy of the sheet with all the formulated cells and THEN I unlink the reference to where it was brought over from?

 

[p45cal]

Not knowing your precise circumstances, I'd say yes, but rather than unlinking, don't you want to change the link? I don't know what's left in the sheet formulae when you unlink.