Using formulas in another file without including a link to file of origin.
I have a worksheet that has a lot of formulas that I can use in other files. What is the best way for me to transfer this sheet to another file? I find that if I use Move/Copy worksheet it works well EXCEPT that it is now referring to its file of origin :-(. Any suggestions on how I can use this sheet in other files without referencing the original file. Thank you. I think I should know this but turns out I don't :-(